//private string Clean(string cleanthis, string table, string nameparameter, string datatype) //{ // return new StringBuilder(cleanthis) // .Replace("%TABLE%", table) // .Replace("%PRIME%", nameparameter) // .Replace("%TYPE%", datatype) // .ToString(); //} public void ForTable() { if (!IfExists(tableName)) { var sql = $@"CREATE TABLE {tableName} ([Id] INT IDENTITY (1, 1) NOT NULL, PRIMARY KEY CLUSTERED ([Id] ASC));"; var handlerBase = new SQLHandlerBase(); handlerBase.DoQueryNonScaler(sql); } }
public void ForIndex(string indexColumn) { if (!IfIndexExists(tableName, indexColumn)) { var sql = $"CREATE UNIQUE NONCLUSTERED INDEX [ix{tableName}_{indexColumn}] " + " ON [dbo].[CIM_{tableName}]([{indexColumn}] ASC);"; var handlerBase = new SQLHandlerBase(); handlerBase.DoQueryNonScaler(sql); } }
public void ForColumn(string columnName, string datatype, bool nullable, bool indexed) { if (!IfColumnExists(tableName, columnName)) { var nullvalue = nullable ? "NULL" : ""; var sql = $"Alter Table {tableName} Add Column {columnName} {nullvalue}"; var handlerBase = new SQLHandlerBase(); handlerBase.DoQueryNonScaler(sql); if (indexed) { ForIndex(columnName); } } }
public void ForIndex(string indexColumn) { var ixName = ("ix" + tableName + '_' + indexColumn).Replace('[', '_').Replace(']', '_'); //if (!IfIndexExists(tableName, indexColumn)) if (!IfIndexExists(tableName, ixName)) { //var sql = $"CREATE UNIQUE NONCLUSTERED INDEX [ix{tableName}_{indexColumn}] " + // $" ON [dbo].[CIM_{tableName}]([{indexColumn}] ASC);"; var sql = $"CREATE UNIQUE NONCLUSTERED INDEX [{ixName}] " + $" ON {tableName} ({indexColumn} ASC);"; var handlerBase = new SQLHandlerBase(); handlerBase.DoQueryNonScaler(sql); } }