Follow @PDSAInc ADO.NET - Paul Sheriff's Blog for the Real World

Paul Sheriff's Blog for the Real World

This blog is to share my tips and tricks garnered over 25+ years in the IT industry

Paul's Favorites

Browse by Tags

All Tags » ADO.NET (RSS)
Creating Collections of Entity Objects using Reflection
In my last blog posts I have been showing you how to create collection of entity objects using code that is custom for each table and object you create. Well, if you use a little reflection code you can shrink this code quite a bit. Yes, we all know that...
Creating Collections of Entity Objects using LINQ
As discussed in my last two blog posts you have a variety of ways to create collections of Entity classes. Using a DataSet or DataTable is a little slower than using a DataReader, but in most cases the difference is in milliseconds so in a real world...
Posted: Feb 11 2013, 07:17 AM by psheriff | with 3 comment(s)
Filed under: , ,
Using The ConnectionStringBuilder class
Building a connection string from scratch can sometimes be a little daunting when you do not know the exact syntax. Of course, you can always visit www.connectionstrings.com and find some great help there. In lieu of this you can also use the ConnectionStringBuilder...
Posted: Sep 08 2009, 11:48 AM by psheriff | with 3 comment(s)
Filed under: ,
Cloning a DataRow
I can't even tell you how many times over the last few years I have had to clone a row from one DataTable to another DataTable. To make this easier, I created a method that I can call at anytime to create this new DataRow and return a new DataTable back...
Posted: Aug 27 2009, 09:56 AM by psheriff | with 3 comment(s)
Filed under: ,
More Posts