Under what circumstances is an SqlConnection automatically enlisted in an ambient TransactionScope Transaction?
What does it mean for an SqlConnection to be “enlisted” in a transaction? Does it simply mean that commands I execute on the … Read more
ado.net
What size do you use for varchar(MAX) in your parameter declaration?
I normally set my column size when creating a parameter in ADO.NET. But what size do I use if the column is of … Read more
Get the generated SQL statement from a SqlCommand object?
I have the following code: Using cmd As SqlCommand = Connection.CreateCommand cmd.CommandText = “UPDATE someTable SET Value = @Value” cmd.CommandText &= ” WHERE … Read more
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 … Read more
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 … Read more
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, … Read more
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 … Read more
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
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, … Read more
Get connection string from App.config
var connection = ConnectionFactory.GetConnection( ConfigurationManager.ConnectionStrings[“Test”] .ConnectionString, DataBaseProvider); And this is my App.config: <?xml version=”1.0″ encoding=”utf-8″ ?> <configuration> <connectionStrings> <add name=”Test” connectionString=”Data Source=.;Initial Catalog=OmidPayamak;Integrated … Read more