public void RemoveDatabase(string name)
{
OrmLiteConfig.DialectProvider = SqlServerOrmLiteDialectProvider.Instance;
DatabaseParam dBParam = ConfigStringsFactory.NewDatabaseParam();
var connectionString = string.Format(ConnectionString, dBParam.ServerName, dBParam.DatabaseName, dBParam.UserId, dBParam.Password);
using (IDbConnection con = connectionString.OpenDbConnection())
{
int exist = con.Scalar <int>(string.Format(DatabaseSelectSql, name));
IDbCommand cmd = con.CreateCommand();
if (exist > 0)
{
///杀死所有连接
List <SpWho> spWhoes = con.SqlList <SpWho>(" sp_who ;");
foreach (var item in spWhoes)
{
if (item.dbname == name)
{
cmd.CommandText = string.Format(DatabaseKillSql, item.spid);
cmd.ExecuteNonQuery();
}
}
///删除数据库
cmd.CommandText = string.Format(DatabaseDeleteSql, name);
cmd.ExecuteNonQuery();
}
}
}
public void CreateDataBase(string name)
{
OrmLiteConfig.DialectProvider = SqlServerOrmLiteDialectProvider.Instance;
DatabaseParam dBParam = ConfigStringsFactory.NewDatabaseParam();
var connectionString = string.Format(ConnectionString, dBParam.ServerName, dBParam.DatabaseName, dBParam.UserId, dBParam.Password);
dBParam.DatabaseName = name;
using (IDbConnection con = connectionString.OpenDbConnection())
{
con.ExecuteNonQuery(string.Format(DatabaseCreateSql,
dBParam.DatabaseName,
dBParam.DataFileSize,
dBParam.DataFileGrowth,
dBParam.LogFileSize,
dBParam.LogFileGrowth,
dBParam.Path));
}
}
public void CopyData <T>(string datasource)
{
OrmLiteConfig.DialectProvider = SqlServerOrmLiteDialectProvider.Instance;
var connectionString = string.Format(ConfigStringsFactory.NewConfigStrings().IHPMSConnectionString, "");
IRoadsDao roadDao = MyApp.Dal.RoadsDao;
roadDao.DataSource = datasource;
using (IDbConnection sourceConn = connectionString.OpenDbConnection())
{
List <T> data = sourceConn.Select <T>();
if (data.Count > 0)
{
using (IDbConnection targetConn = roadDao.IHPMS.OpenDbConnection())
{
targetConn.InsertAll <T>(data);
}
}
}
}
public RoadsDao()
{
_configStrings = ConfigStringsFactory.NewConfigStrings();
}