ado.net Archives - IT Nursery

I have the following code: Using cmd As SqlCommand = Connection.CreateCommand cmd.CommandText = "UPDATE someTable SET Value = @Value" cmd.CommandText &= " WHERE ...

May 28, 2022
0 Comments

How to create a DataTable in C# and how to add rows?

How do create a DataTable in C#? I did like this: DataTable dt = new DataTable(); dt.clear(); dt.Columns.Add("Name"); dt.Columns.Add("Marks"); How do I see ...

May 24, 2022
0 Comments

Using MySQL with Entity Framework [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. Want to improve this question? Update the question ...

May 20, 2022
0 Comments

How to use DbContext.Database.SqlQuery(sql, params) with stored procedure? EF Code First CTP5

I have a stored procedure that has three parameters and I’ve been trying to use the following to return the results: context.Database.SqlQuery<myEntityType>("mySpName", param1, ...

May 20, 2022
0 Comments

Entity Framework and Connection Pooling

I’ve recently started to use the Entity Framework 4.0 in my .NET 4.0 application and am curious about a few things relating to ...

May 19, 2022
0 Comments

Can you get the column names from a SqlDataReader?

After connecting to the database, can I get the name of all the columns that were returned in my SqlDataReader? 10 Answers 10

May 16, 2022
0 Comments

SET NOCOUNT ON usage

Inspired by this question where there are differing views on SET NOCOUNT… Should we use SET NOCOUNT ON for SQL Server? If not, ...

May 11, 2022
0 Comments

Get connection string from App.config

var connection = ConnectionFactory.GetConnection( ConfigurationManager.ConnectionStrings...

May 7, 2022
0 Comments