Top "Ado.net" questions

How should I multiple insert multiple records?

I have a class named Entry declared like this: class Entry{ string Id {get;set;} string Name {get;set;} } and …

c# sql-server-2005 ado.net multiple-insert

Is it possible to run native sql with entity framework?

I am trying to search an XML field within a table, This is not supported with EF. Without using pure …

sql entity-framework ado.net

.net connection pooling

I don't get what is the syntax difference between regular connection and connection pool. When I'm using the using key …

c# .net ado.net connection-pooling

Creating a SQL Server table from a C# datatable

I have a DataTable that I manually created and loaded with data using C#. What would be the most efficient …

c# sql-server ado.net datatable

Getting binary data using SqlDataReader

I have a table named Blob (Id (int), Data (Image)). I need to use SqlDataReader to get that image data. …

c# ado.net

How do I return multiple result sets with SqlCommand?

Can I execute multiple queries and return their results executing a SqlCommand just once?

c# sql-server ado.net

IEnumerable to string

I have a DataTable that returns IDs ,1 ,2 ,3 ,4 ,5 ,100 ,101 I want to convert this to single string value, i.e: ,1,2,3,4,5,100,101 How can …

c# asp.net linq ado.net datatable

What's the best method to pass parameters to SQLCommand?

What's the best method to pass parameters to SQLCommand? You can do: cmd.Parameters.Add("@Name", SqlDbType.VarChar, 20).Value = "Bob"; …

.net sql-server ado.net sqlcommand

Check if a SQL table exists

What's the best way to check if a table exists in a Sql database in a database independant way? I …

c# .net sql ado.net odbc

WHERE IN (array of IDs)

I have webservice which is passed an array of ints. I'd like to do the select statement as follows but …

c# sql-server tsql ado.net sqlparameter