本文整理汇总了C#中DatabaseSchemaReader.SqlGen.DdlGeneratorFactory.AllTablesGenerator方法的典型用法代码示例。如果您正苦于以下问题:C# DdlGeneratorFactory.AllTablesGenerator方法的具体用法?C# DdlGeneratorFactory.AllTablesGenerator怎么用?C# DdlGeneratorFactory.AllTablesGenerator使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DatabaseSchemaReader.SqlGen.DdlGeneratorFactory
的用法示例。
在下文中一共展示了DdlGeneratorFactory.AllTablesGenerator方法的2个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: TestSqlServerCeSchema
public void TestSqlServerCeSchema()
{
//arrange
var schema = new DatabaseSchema(null, SqlType.SqlServerCe);
//two tables with a FK between them
schema.AddTable("Categories")
.AddColumn<int>("Id").AddIdentity().AddPrimaryKey()
.AddColumn<string>("Name").AddLength(200)
.AddTable("Products")
.AddColumn<int>("Id").AddIdentity().AddPrimaryKey()
.AddColumn<string>("Name").AddLength(200)
.AddColumn<int>("CategoryId").AddForeignKey("Categories")
;
var factory = new DdlGeneratorFactory(SqlType.SqlServerCe);
var tablesGenerator = factory.AllTablesGenerator(schema);
tablesGenerator.IncludeSchema = false;
//act
var ddl = tablesGenerator.Write();
//assert
Assert.IsTrue(ddl.Contains("GO")); //batch separators
Assert.IsFalse(ddl.Contains(";")); //valid but useless in SqlServer CE because you can't batch
}
示例2: CreateDatabaseScript
private static string CreateDatabaseScript(DatabaseSchema schema)
{
var ddlFactory = new DdlGeneratorFactory(SqlType.SQLite);
var generator = ddlFactory.AllTablesGenerator(schema);
return generator.Write();
}