public void Create_Sqlite_Database()
{
var dbPath = "~/App_Data/db.sqlite".MapAbsolutePath();
var dbFactory = new OrmLiteConnectionFactory(
dbPath, SqliteOrmLiteDialectProvider.Instance);
if (File.Exists(dbPath)) File.Delete(dbPath);
NorthwindData.LoadData();
dbFactory.Exec(dbCmd =>
{
dbCmd.CreateTables(false, NorthwindFactory.ModelTypes.ToArray());
dbCmd.SaveAll(NorthwindData.Categories);
dbCmd.SaveAll(NorthwindData.Customers);
dbCmd.SaveAll(NorthwindData.CustomerCustomerDemos);
dbCmd.SaveAll(NorthwindData.Employees);
dbCmd.SaveAll(NorthwindData.EmployeeTerritories);
dbCmd.SaveAll(NorthwindData.OrderDetails);
dbCmd.SaveAll(NorthwindData.Orders);
dbCmd.SaveAll(NorthwindData.Products);
dbCmd.SaveAll(NorthwindData.Products);
dbCmd.SaveAll(NorthwindData.Regions);
dbCmd.SaveAll(NorthwindData.Shippers);
dbCmd.SaveAll(NorthwindData.Suppliers);
dbCmd.SaveAll(NorthwindData.Territories);
});
}
