LINQ provides us some extension methods to convert an IEnumerable to a collection e.g. ToList(), ToArray() etc. But what if you want to convert the enumerable to a DataTable. There is no built in extension method for that currently. var v = ( from...

In .NET 2.0 framework when you use System.Xml.Xsl.XslCompiledTransform class for transforming a document then we always get self closing tags for all the elements which have nothing inside their body. There is no direct way to ask it to use separate closing...

If you run into a scenario where you see your managed stored procedure from SQLCLR hung perpetually while calling a native dll method using P/Invoke, You may have to check following things. Run following query from another connection select os.task_address...

Sometimes while executing a DB command in ADO.NET we come across below error. There is already an open DataReader associated with this Command which must be closed first This error is generated when we try to execute some query using a connection...