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();
}