数据工厂

最新推荐文章于 2024-08-16 08:35:36 发布

爱雨浮龙

最新推荐文章于 2024-08-16 08:35:36 发布

阅读量576

点赞数

文章标签： database command string object

本文链接：https://blog.csdn.net/williamrt/article/details/2740683

版权

public static DbCommand CreateCommand()
{
    // Obtain the database provider name
    string dataProviderName = BalloonShopConfiguration.DbProviderName;
    // Obtain the database connection string
    string connectionString = BalloonShopConfiguration.DbConnectionString;
    // Create a new data provider factory
    DbProviderFactory factory = DbProviderFactories.GetFactory(dataProviderName);
    // Obtain a database specific connection object
    DbConnection conn = factory.CreateConnection();
    // Set the connection string
    conn.ConnectionString = connectionString;
    // Create a database specific command object
    DbCommand comm = conn.CreateCommand();
    // Set the command type to stored procedure
    comm.CommandType = CommandType.StoredProcedure;
    // Return the initialized command object
    return comm;
}