ado.net 311

  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. Entity Framework and Connection Pooling
  7. SET NOCOUNT ON usage
  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. Get the generated SQL statement from a SqlCommand object?
  12. What size do you use for varchar(MAX) in your parameter declaration?
  13. Mixed mode assembly is built against version ‘v2.0.50727′ of the runtime
  14. How to create a DataTable in C# and how to add rows?
  15. Entity Framework with NOLOCK
  16. entity object cannot be referenced by multiple instances of IEntityChangeTracker. while adding related objects to entity in Entity Framework 4.1
  17. ADO.NET DataRow - check for column existence
  18. Connection timeout for SQL server
  19. How can i query for null values in entity framework?
  20. What is the difference between ExecuteScalar, ExecuteReader and ExecuteNonQuery?
  21. Call a stored procedure with parameter in c#
  22. DbArithmeticExpression arguments must have a numeric common type
  23. ExecuteReader requires an open and available Connection. The connection's current state is Connecting
  24. Get output parameter value in ADO.NET
  25. ADO.NET Entity Framework: Update Wizard will not add tables
  26. Connection to SQL Server Works Sometimes
  27. Check if SQL Connection is Open or Closed
  28. Should I commit or rollback a read transaction?
  29. Microsoft.ACE.OLEDB.12.0 provider is not registered
  30. MultipleActiveResultSets=True or multiple connections?
  31. Calling stored procedure with return value
  32. MySQL Data Source not appearing in Visual Studio
  33. C# ADO.NET: nulls and DbNull — is there more efficient syntax?
  34. SQL: Update a row and returning a column value with 1 query
  35. What's the best method to pass parameters to SQLCommand?
  36. Handling ExecuteScalar() when no results are returned
  37. Check if a SQL table exists
  38. ADO.NET Entity Framework vs NHibernate
  39. When should “SqlDbType” and “size” be used when adding SqlCommand Parameters?
  40. Can I get a reference to a pending transaction from a SqlConnection object?
  41. How do you deal with transport-level errors in SqlConnection?
  42. How to get Return Value of a Stored Procedure
  43. How to write a .Net application that works with both SqlServer and Oracle (now that System.Data.OracleClient is deprecated)
  44. How to pass a table-value parameter
  45. ADO.NET Entity Framework tutorials
  46. Delete an object and all of its related entities in Entity Framework
  47. DataView.RowFilter Vs DataTable.Select() vs DataTable.Rows.Find()
  48. Do you think it's advantageous to switch to Entity Framework?
  49. WHERE IN (array of IDs)
  50. How do you catch exceptions with “using” in C#