public static ModelSqlTable Ensure(ModelSqlSchema modelSqlSchema, string name)
{
var sqlName = modelSqlSchema.Name.Child(name, ObjectLevel.Object);
return(modelSqlSchema.Tables.GetValueOrDefault(sqlName)
?? new ModelSqlTable(modelSqlSchema, name));
}
private static ModelSqlDatabase GetTestModelSqlDatabase()
{
ModelSqlServer modelSqlServer = new ModelSqlServer();
modelSqlServer.Name = new SqlName(null, "default", ObjectLevel.Server);
var serverScope = modelSqlServer.GetScope();
var result = new ModelSqlDatabase(modelSqlServer, "OfaSchlupfer");
result.Name = new SqlName(null, "OfaSchlupfer", ObjectLevel.Database);
ModelSqlSchema schema = new ModelSqlSchema(result, "dbo");
ModelSqlTable table = new ModelSqlTable(schema, "name");
var col = (new ModelSqlColumn(table, "key"));
return(result);
}
/// <summary>
/// Initializes a new instance of the <see cref="ModelSqlTable"/> class.
/// </summary>
/// <param name="schema">the owner</param>
/// <param name="name">the name</param>
public ModelSqlTable(ModelSqlSchema schema, string name)
: this(schema.GetScope())
{
this.Name = schema.Name.Child(name, ObjectLevel.Object);
this.Schema = schema;
}
public static ModelSqlTable Ensure(ModelSqlDatabase database, SqlName name)
{
var schema = ModelSqlSchema.Ensure(database, name.Parent?.Name ?? "dbo");
return(Ensure(schema, name.Name));
}
/// <summary>
/// Initializes a new instance of the <see cref="ModelSqlType"/> class.
/// </summary>
/// <param name="schema">the owner schema</param>
/// <param name="name">the name</param>
public ModelSqlType(ModelSqlSchema schema, string name)
{
this.Name = schema.Name.Child(name, ObjectLevel.Object);
this.Schema = schema;
}
