ado.net 328

  1. MetadataException: Unable to load the specified metadata resource
  2. How do I view the SQL generated by the Entity Framework?
  3. Entity Framework VS LINQ to SQL VS ADO.NET with stored procedures?
  4. Get connection string from App.config
  5. Using MySQL with Entity Framework
  6. SET NOCOUNT ON usage
  7. Entity Framework and Connection Pooling
  8. Can you get the column names from a SqlDataReader?
  9. How to use DbContext.Database.SqlQuery<TElement>(sql, params) with stored procedure? EF Code First CTP5
  10. Under what circumstances is an SqlConnection automatically enlisted in an ambient TransactionScope Transaction?
  11. What size do you use for varchar(MAX) in your parameter declaration?
  12. Get the generated SQL statement from a SqlCommand object?
  13. entity object cannot be referenced by multiple instances of IEntityChangeTracker. while adding related objects to entity in Entity Framework 4.1
  14. Mixed mode assembly is built against version ‘v2.0.50727′ of the runtime
  15. How to create a DataTable in C# and how to add rows?
  16. Entity Framework with NOLOCK
  17. Call a stored procedure with parameter in c#
  18. How can i query for null values in entity framework?
  19. ADO.NET DataRow - check for column existence
  20. Connection timeout for SQL server
  21. What is the difference between ExecuteScalar, ExecuteReader and ExecuteNonQuery?
  22. DbArithmeticExpression arguments must have a numeric common type
  23. How to change the DataTable Column Name?
  24. A connection was successfully established with the server, but then an error occurred during the pre-login handshake
  25. ExecuteReader requires an open and available Connection. The connection's current state is Connecting
  26. ADO.NET Entity Framework: Update Wizard will not add tables
  27. Get output parameter value in ADO.NET
  28. Connection to SQL Server Works Sometimes
  29. Check if SQL Connection is Open or Closed
  30. How to view a DataTable while debugging
  31. Should I commit or rollback a read transaction?
  32. What is the recommended batch size for SqlBulkCopy?
  33. How to get Database Name from Connection String using SqlConnectionStringBuilder
  34. Microsoft.ACE.OLEDB.12.0 provider is not registered
  35. Is it necessary to manually close and dispose of SqlDataReader?
  36. How do you Sort a DataTable given column and direction?
  37. Populate data table from data reader
  38. Is it possible to run native sql with entity framework?
  39. TransactionScope Prematurely Completed
  40. MultipleActiveResultSets=True or multiple connections?
  41. Entity Framework Vote of No Confidence - relevant in .NET 4?
  42. ADO.NET |DataDirectory| where is this documented?
  43. Invalid attempt to read when no data is present
  44. Calling stored procedure with return value
  45. MySQL Data Source not appearing in Visual Studio
  46. C# ADO.NET: nulls and DbNull — is there more efficient syntax?
  47. SQL: Update a row and returning a column value with 1 query
  48. What's better: DataSet or DataReader?
  49. SQL Server: Isolation level leaks across pooled connections
  50. What's the best method to pass parameters to SQLCommand?