private static void BuildPrimaryKey(MetaTable table, StringBuilder sb)
{
foreach (MetaDataMember mm in table.RowType.IdentityMembers)
{
if (sb.Length > 0)
{
sb.Append(", ");
}
sb.Append(SqlIdentifier.QuoteCompoundIdentifier(mm.MappedName));
}
}
internal static string GetCreateDatabaseCommand(string catalog, string dataFilename, string logFilename)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("CREATE DATABASE {0}", SqlIdentifier.QuoteIdentifier(catalog));
if (dataFilename != null)
{
sb.AppendFormat(" ON PRIMARY (NAME='{0}', FILENAME='{1}')", Path.GetFileName(dataFilename), dataFilename);
sb.AppendFormat(" LOG ON (NAME='{0}', FILENAME='{1}')", Path.GetFileName(logFilename), logFilename);
}
return(sb.ToString());
}
private static string BuildKey(IEnumerable <MetaDataMember> members)
{
StringBuilder sb = new StringBuilder();
foreach (MetaDataMember mm in members)
{
if (sb.Length > 0)
{
sb.Append(", ");
}
sb.Append(SqlIdentifier.QuoteCompoundIdentifier(mm.MappedName));
}
return(sb.ToString());
}
private static IEnumerable <String> GetCreateForeignKeyCommands(MetaType type)
{
string tableName = type.Table.TableName;
foreach (MetaDataMember mm in type.DataMembers)
{
if (mm.IsDeclaredBy(type) && mm.IsAssociation)
{
MetaAssociation assoc = mm.Association;
if (assoc.IsForeignKey)
{
StringBuilder sb = new StringBuilder();
string thisKey = BuildKey(assoc.ThisKey);
string otherKey = BuildKey(assoc.OtherKey);
string otherTable = assoc.OtherType.Table.TableName;
string name;
name = mm.MappedName;
if (name == mm.Name)
{
name = String.Format(Globalization.CultureInfo.InvariantCulture, "FK_{0}_{1}", tableName, mm.Name);
}
string cmd = "ALTER TABLE {0}" + Environment.NewLine + " ADD CONSTRAINT {1} FOREIGN KEY ({2}) REFERENCES {3}({4})";
//In DLinq we put the constraint on the child object (which triggers the behavior when deleted),
//but in SQL it is part of the parent constraint (the parent row gets changed / deleted to satisfy the constraint)
MetaDataMember otherMember = mm.Association.OtherMember;
if (otherMember != null)
{
string delConstr = otherMember.Association.DeleteRule;
if (delConstr != null)
{
cmd += Environment.NewLine + " ON DELETE " + delConstr;
}
}
sb.AppendFormat(cmd,
SqlIdentifier.QuoteCompoundIdentifier(tableName),
SqlIdentifier.QuoteIdentifier(name),
SqlIdentifier.QuoteCompoundIdentifier(thisKey),
SqlIdentifier.QuoteCompoundIdentifier(otherTable),
SqlIdentifier.QuoteCompoundIdentifier(otherKey));
yield return(sb.ToString());
}
}
}
}
internal static string GetCreateTableCommand(MetaTable table)
{
StringBuilder sb = new StringBuilder();
StringBuilder decl = new StringBuilder();
BuildFieldDeclarations(table, decl);
sb.AppendFormat("CREATE TABLE {0}", SqlIdentifier.QuoteCompoundIdentifier(table.TableName));
sb.Append("(");
sb.Append(decl.ToString());
decl = new StringBuilder();
BuildPrimaryKey(table, decl);
if (decl.Length > 0)
{
string name = String.Format(Globalization.CultureInfo.InvariantCulture, "PK_{0}", table.TableName);
sb.Append(", ");
sb.AppendLine();
sb.AppendFormat(" CONSTRAINT {0} PRIMARY KEY ({1})", SqlIdentifier.QuoteIdentifier(name), decl.ToString());
}
sb.AppendLine();
sb.Append(" )");
return(sb.ToString());
}
internal static string GetCreateSchemaForTableCommand(MetaTable table)
{
StringBuilder sb = new StringBuilder();
List <string> parts = new List <string>(SqlIdentifier.GetCompoundIdentifierParts(table.TableName));
// table names look like this in Yukon (according to MSDN):
// [ database_name . [ schema_name ] . | schema_name . ] table_name
// ... which means that either way, the schema name is the second to last part.
if ((parts.Count) < 2)
{
return(null);
}
string schema = parts[parts.Count - 2];
if (String.Compare(schema, "DBO", StringComparison.OrdinalIgnoreCase) != 0 &&
String.Compare(schema, "[DBO]", StringComparison.OrdinalIgnoreCase) != 0)
{
sb.AppendFormat("CREATE SCHEMA {0}", SqlIdentifier.QuoteIdentifier(schema));
}
return(sb.ToString());
}
private static int BuildFieldDeclarations(MetaType type, Dictionary <object, string> memberNameToMappedName, StringBuilder sb)
{
int n = 0;
foreach (MetaDataMember mm in type.DataMembers)
{
// Only generate declarations for the current type.
if (mm.IsDeclaredBy(type))
{
if (!mm.IsAssociation)
{
if (mm.IsPersistent)
{
object dn = InheritanceRules.DistinguishedMemberName(mm.Member);
string mappedName;
if (memberNameToMappedName.TryGetValue(dn, out mappedName))
{
if (mappedName == mm.MappedName)
{
continue;
}
}
else
{
memberNameToMappedName.Add(dn, mm.MappedName);
}
if (sb.Length > 0)
{
sb.Append(", ");
}
sb.AppendLine();
sb.Append(string.Format(Globalization.CultureInfo.InvariantCulture, " {0} ", SqlIdentifier.QuoteCompoundIdentifier(mm.MappedName)));
if (!string.IsNullOrEmpty(mm.Expression))
{
// Generate "AS <expression>" for computed columns
sb.Append("AS " + mm.Expression);
}
else
{
sb.Append(GetDbType(mm));
}
n++;
}
}
}
}
return(n);
}
