private static SQL.Components.Field CreatePrimaryKey(Table t) { SQL.Components.Field f = null; try { f = new SQL.Components.Field() { AllowNull = false, IsPrimary = true, IsClustered = true, IdentitySpecification = new IdentitySpecification(), Name = t.Name + "Id", DataType = new Enums.DataType() { HasTypeError = false, IsBaseType = true, IsList = false, IsNullable = false, Name = Enums.SQLCondensedDataType.SMALLINT.ToString() }, OriginalName = "Missing Primary Key" }; } catch (Exception ae) { string s = ae.ToString(); } return(f); }
public static Table ConfirmPrimaryKeys(Table t) { try { //Test for tables without a primary key if (t.Fields.Count(f => f.IsPrimary) != 1) { if (t.Fields.Count(f => f.IsPrimary) < 1) { //Table does NOT have a Primary Key SQL.Components.Field pkN = CreatePrimaryKey(t); t.Fields.Insert(0, pkN); } else if (t.Fields.Count(f => f.IsPrimary) > 1) { } } //Test for tables with an unrecognised primary key name SQL.Components.Field pk = t.Fields.FirstOrDefault(f => f.IsPrimary); if (pk.Name != t.Name + "Id") { SQL.Components.Field fpk = CreatePrimaryKey(t); t.Fields.Insert(0, fpk); } } catch (Exception ae) { string s = ae.ToString(); } return(t); }
public static Table LimitedTextLengths(Table t) { try { SQL.Components.Field f = t.Fields.FirstOrDefault(fs => fs.IsPrimary == true); if (!f.DataType.Name.Contains("INT")) { if (f.DataType.Name == "NVARCHAR") { f.DataType.Para1 = 255; } else if (f.DataType.Name == "VARCHAR") { f.DataType.Para1 = 512; } else { f.DataType.Para1 = 512; } } } catch (Exception ae) { string s = ae.ToString(); } return(t); }
public static string HasValidName(SQL.Components.Field f, SQL.Components.Table t) { try { if (f.Name == null || f.Name == "") { string s = t.Name + "Missing"; return(s); } } catch (Exception ae) { string s = ae.ToString(); } return(f.Name); }