express版的数据库文件能不能直接附加到企业版里,他们的程序操作是不是通用的。我看到一个express版的数据库连接操作与我通常使用的不一样。
public class DbConnectionStore
{
public static DbConnectionStore TheInstance = new DbConnectionStore();
public static readonly string DBNAME = System.Web.Configuration.WebConfigurationManager.AppSettings["DBName"]; private DbConnectionStore()
{
} public DbConnection GetConnection()
{
ConnectionStringSettings cnSettings = DbConnectionStore.TheInstance.GetConnectionStringSettings();
DbProviderFactory providerFactory = DbProviderFactories.GetFactory(cnSettings.ProviderName);
DbConnection cn = providerFactory.CreateConnection();
cn.ConnectionString = cnSettings.ConnectionString;
try
{
cn.Open();
return cn;
}
catch (Exception ex)
{
throw new Exception("无法连接到服务器", ex);
}
} public ConnectionStringSettings GetConnectionStringSettings()
{
ConnectionStringsSection connectionStringsSection = WebConfigurationManager.GetSection("connectionStrings") as ConnectionStringsSection;
ConnectionStringSettingsCollection connectionStrings = connectionStringsSection.ConnectionStrings;
ConnectionStringSettings connStringSettings = connectionStrings[DBNAME];
return connStringSettings;
}
}这里面怎么没有用到sqlconnection?
public class DbConnectionStore
{
public static DbConnectionStore TheInstance = new DbConnectionStore();
public static readonly string DBNAME = System.Web.Configuration.WebConfigurationManager.AppSettings["DBName"]; private DbConnectionStore()
{
} public DbConnection GetConnection()
{
ConnectionStringSettings cnSettings = DbConnectionStore.TheInstance.GetConnectionStringSettings();
DbProviderFactory providerFactory = DbProviderFactories.GetFactory(cnSettings.ProviderName);
DbConnection cn = providerFactory.CreateConnection();
cn.ConnectionString = cnSettings.ConnectionString;
try
{
cn.Open();
return cn;
}
catch (Exception ex)
{
throw new Exception("无法连接到服务器", ex);
}
} public ConnectionStringSettings GetConnectionStringSettings()
{
ConnectionStringsSection connectionStringsSection = WebConfigurationManager.GetSection("connectionStrings") as ConnectionStringsSection;
ConnectionStringSettingsCollection connectionStrings = connectionStringsSection.ConnectionStrings;
ConnectionStringSettings connStringSettings = connectionStrings[DBNAME];
return connStringSettings;
}
}这里面怎么没有用到sqlconnection?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货