Data Access Technologies

(Data Access, XML, SSIS, SQL-CE ...)

How to convert an IEnumerable to a DataTable in the same way as we use ToList or ToArray

LINQ provides us some extension methods to convert an IEnumerable to a collection e.g. ToList(),...

Author: Snehadeep Date: 04/08/2009

How to force System.Xml.Xsl.XslCompiledTransform class to not use self closing tags for empty nodes

In .NET 2.0 framework when you use System.Xml.Xsl.XslCompiledTransform class for transforming a...

Author: Snehadeep Date: 04/08/2009

Hung condition on a query to SQLCLR stored procedure doing P/Invoke on a native dll

If you run into a scenario where you see your managed stored procedure from SQLCLR hung perpetually...

Author: Snehadeep Date: 02/25/2009

How to find out the data-reader referencing an ADO.NET connection object to fix the error: "There is already an open DataReader associated with this Command which must be closed first"

Sometimes while executing a DB command in ADO.NET we come across below error. There is already an...

Author: Snehadeep Date: 02/25/2009