本文整理汇总了C#中IDbConnection.CreateTables方法的典型用法代码示例。如果您正苦于以下问题：C# IDbConnection.CreateTables方法的具体用法？C# IDbConnection.CreateTables怎么用？C# IDbConnection.CreateTables使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类IDbConnection的用法示例。
在下文中一共展示了IDbConnection.CreateTables方法的5个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: CreateNorthwindTables
public static void CreateNorthwindTables(IDbConnection db)
{
db.DropTable<EmployeeTerritory>();
db.DropTable<Territory>();
db.DropTable<Region>();
db.DropTable<CustomerDemographic>();
db.DropTable<CustomerCustomerDemo>();
db.DropTable<OrderDetail>();
db.DropTable<Product>();
db.DropTable<Order>();
db.DropTable<Supplier>();
db.DropTable<Shipper>();
db.DropTable<Customer>();
db.DropTable<Category>();
db.DropTable<Employee>();
db.CreateTables
(
true,
typeof (Employee),
typeof (Category),
typeof (Customer),
typeof (Shipper),
typeof (Supplier),
typeof (Order),
typeof (Product),
typeof (OrderDetail),
typeof (CustomerCustomerDemo),
typeof (CustomerDemographic),
typeof (Region),
typeof (Territory),
typeof (EmployeeTerritory)
);
}示例2: Setup
public static void Setup(IDbConnection db)
{
var drop = false;
//drop = true;
if (drop)
{
//string databaseName = db.Database;
//db.ChangeDatabase("postgres");
//db.ExecuteSql(String.Format("DROP DATABASE {0}", databaseName));
//db.ExecuteSql(String.Format("CREATE DATABASE {0}", databaseName));
//db.ChangeDatabase(databaseName);
db.DropTable<CategoryToTransaction>();
db.DropTable<BudgetToTransaction>();
db.DropTable<BudgetToCategory>();
db.DropTable<UserToTransaction>();
db.DropTable<UserToBudget>();
db.DropTable<Transaction>();
db.DropTable<Bill>();
db.DropTable<Category>();
db.DropTable<Budget>();
db.DropTable<User>();
db.CreateTables
(
true,
typeof(User),
typeof(Budget),
typeof(Category),
typeof(Bill),
typeof(Transaction),
typeof(UserToBudget),
typeof(UserToTransaction),
typeof(BudgetToCategory),
typeof(BudgetToTransaction),
typeof(CategoryToTransaction)
);
}
}示例3: CreateNorthwindTables
public static void CreateNorthwindTables(IDbConnection db)
{
db.CreateTables
(
true,
typeof(Employee),
typeof(Category),
typeof(Northwind.Common.DataModel.Customer),
typeof(Shipper),
typeof(Supplier),
typeof(Northwind.Common.DataModel.Order),
typeof(Product),
typeof(OrderDetail),
typeof(CustomerCustomerDemo),
typeof(Category),
typeof(CustomerDemographic),
typeof(Region),
typeof(Territory),
typeof(EmployeeTerritory)
);
}示例4: InsertData
/// <summary>Inserts a data described by db.</summary>
/// <param name="db">The database.</param>
public void InsertData(IDbConnection db)
{
if (this.IsFirstRun)
{
db.CreateTables(true, NorthwindFactory.ModelTypes.ToArray());
}
else
{
NorthwindFactory.ModelTypes.ForEach(x => db.DeleteAll(x));
}
NorthwindData.Categories.ForEach(x => db.Insert(x));
NorthwindData.Customers.ForEach(x => db.Insert(x));
NorthwindData.Employees.ForEach(x => db.Insert(x));
NorthwindData.Shippers.ForEach(x => db.Insert(x));
NorthwindData.Orders.ForEach(x => db.Insert(x));
NorthwindData.Products.ForEach(x => db.Insert(x));
NorthwindData.OrderDetails.ForEach(x => db.Insert(x));
NorthwindData.CustomerCustomerDemos.ForEach(x => db.Insert(x));
NorthwindData.Regions.ForEach(x => db.Insert(x));
NorthwindData.Territories.ForEach(x => db.Insert(x));
NorthwindData.EmployeeTerritories.ForEach(x => db.Insert(x));
}示例5: CreateTables
private void CreateTables(bool overwrite, IDbConnection db)
{
db.CreateTables(overwrite, typeof(Kurs), typeof(Klasse), typeof(KursWahl), typeof(Schueler));
}