The Enterprise Library Data Access Application Block can connect to any database that has a .NET Data Provider. One of the common questions is - “Does Enterprise Library support Microsoft Access?“ The answer is yes! You can use OLEDB or ODBC to connect to the Microsoft Access Database using the Data Access Application Block. In this article I show both ways...
I was answering a number of questions on the Enterprise Library 2.0 DAAB Message Board today, and this one was worth a blog post since the question comes up a lot in various forums. Although I am showing this using Enterprise Library 2.0 DAAB, the answer applies to SqlClient as well. Let's say you're inserting a new customer row in the Customers Table and you want to retrieve the PK and Timestap ( Rowversion ) of the row..
The question about how to store and display photos in SQL Server using ASP.NET came up in the MSDN Forums, so I thought I would write a tutorial on it. I wrote a very similar tutorial on this subject using Enterprise Library 2.0 DAAB, called Saving and Retrieving Images From SQL Server Using DAAB, but it didn't discuss how to display photos using ASP.NET. In this tutorial I will show you how to store the photo uploaded from a FileUpload Control into SQL Server using the SQL Server Managed Provid
A question came up in the MSDN forums as to how to handle Data Column Expressions within a DataTable in ADO.NET. The expression syntax available to create calculated columns is probably much richer than you might think if you don't play around a lot with the Expression Property of the DataColumn. The question was on how to...