protected override string BuildFKScript(Mapping.IMemberMapping member)
{
var mapping = member.Entity;
var m = member as MemberMapping;
var FKName = mapping.TableName.Replace(" ", "_") + "_" + member.Member.Name;
if (FKName.Length > 28)
{
FKName = FKName.Substring(0, 27);
}
const string fmt = "ALTER TABLE {0}{1} ADD CONSTRAINT FK_{2} FOREIGN KEY ({3}) REFERENCES {4}({5}){1}";
return(string.Format(fmt
, GetTableName(mapping)
, Environment.NewLine
, FKName
, m.thisKey
, GetTableName(member.RelatedEntity)
, m.otherKey));
}
protected override string BuildFKScript(Mapping.IMemberMapping member)
{
return(null);
}
