ado.net 306

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