Shulou(Shulou.com)06/02 Report--

Editor to share with you how to use the ADO.NET DbProviderFactories class, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to understand it!

The development of ADO.NET is still very fast. I have studied it deeply using ADO.NET DbProviderFactories and extending compatible mysql. I would like to share it with you here. Let's take a look at it now. ADO.NET2.0 introduces a model of a provider factory and a common base class for various ADO.NET classes. Limitations of the ADO.NET generic interface: the interface is not easy to extend, ADO.NET1.1 cannot create instances of certain classes, and ADO.NET1.1 cannot determine which .NET data providers are available. Provide the factory model how to solve the above limitations, through abstract accumulation to extend the ADO,NET model

Use the ADO.NET DbProviderFactories class to create objects. Due to the limitations of the provider factory model, many query structures are database-specific. When setting up CommandText for parameterized queries, provider-specific code may be required, and specifying parameter data types may require provider-specific code. In order to make the developed code universal, not limited to a specific database, this development decided to use the DbProviderFactory+ standard SQL to develop a package suitable for mysql and sqlserver, but DbProviderFactories does not provide support for mysql's DbProviderFactory, so it is necessary to extend the ADO.NET DbProviderFactories class to be compatible with mysql, and both mysql and sqlserver's ParameterMarkerFormat in ADO.net 2.0 have bug, so the extension class has to solve this bug.

Public static class DbProviderFactoriesEx {public static DbProviderFactory GetFactory (string providerName) {if (providerName = = null) throw new ArgumentNullException ("providerName"); DbProviderFactory dbFactory; switch (providerName) {case "MySql.Data.MySqlClient": return new MySqlClientFactory (); default: return DbProviderFactories.GetFactory (providerName);} public static string GetParameterMarkerFormat (DbConnection connect) {if (connect = = null) throw new ArgumentNullException ("connect"); Type type = connect.GetType () If (type = = typeof (MySql.Data.MySqlClient.MySqlConnection)) return "? {0}"; / / mysql bug if (type = = typeof (System.Data.SqlClient.SqlConnection)) return "@ {0}"; / / ms bug connect.Open (); string result = connect.GetSchema ("DataSourceInformation"). Rows [0] ["ParameterMarkerFormat"] .ToString (); connect.Close (); return result }} above is all the content of the article "how to use ADO.NET DbProviderFactories classes". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.