private void ExecuteSqls(string[] sqls) { foreach (string sql in sqls) { Database.ExecuteSql(sql); } }
public virtual void AddForeignKey(string fkName, string table, string column, string referencingTable, string referencingColumn, OnDelete onDelete) { string sql = Dialect.GetForeignKeySql(fkName, table, column, referencingTable, referencingColumn, onDelete); Database.ExecuteSql(sql); }
public virtual void RemoveColumn(string tableName, string columnName) { string[] sqls = Dialect.GetDropColumnSql(tableName, columnName); for (int i = 0; i < sqls.Length; i++) { Database.ExecuteSql(sqls[i]); } }
public virtual int InsertSql(string table, string[] columns, object[] values) { if (values == null) { values = new object[columns.Length]; } string sql = Dialect.GetInsertSql(table, columns, values); return(Database.ExecuteSql(sql, Dialect.ConvertToNamedParameters(values))); }
public virtual int DeleteSql(string table, Filter filter) { string sql = Dialect.GetDeleteSql(table); if (filter != null) { string whereSql = Dialect.GetWhereSql(filter, 0); object[] pars = filter.GetAllValueParameters(); In[] parameters = Dialect.ConvertToNamedParameters(0, pars); return(Database.ExecuteSql(sql + " " + whereSql, parameters)); } return(Database.ExecuteSql(sql)); }
public virtual object InsertReturningSql(string table, string columnToReturn, string[] columns, object[] values) { var returningPar = new Out { Name = "returning_" + columnToReturn, Size = 4000 }; string retSql = Dialect.GetInsertReturningColumnSql(table, columns, values, columnToReturn, returningPar.Name); object[] pars = Dialect.ConvertToNamedParameters(values); List <object> listPars = pars.ToList(); listPars.Add(returningPar); Database.ExecuteSql(retSql, listPars.ToArray()); return(returningPar.Value); }
public virtual int UpdateSql(string table, string[] columns, object[] values, Filter filter) { if (values == null) { values = new object[columns.Length]; } string sql = Dialect.GetUpdateSql(table, columns, values); In[] parameters = Dialect.ConvertToNamedParameters(values); if (filter != null) { string whereSql = Dialect.GetWhereSql(filter, parameters.Count()); object[] pars = filter.GetAllValueParameters(); In[] filterParameters = Dialect.ConvertToNamedParameters(parameters.Count(), pars); filterParameters = filterParameters.Where(x => x.Value != null && x.Value != DBNull.Value).ToArray(); parameters = parameters.Concat(filterParameters).ToArray(); sql = sql + " " + whereSql; } return(Database.ExecuteSql(sql, parameters)); }
public void AddColumnComment(string tableName, string columnName, string comment) { string sql = Dialect.GetAddCommentToColumnSql(tableName, columnName, comment); Database.ExecuteSql(sql); }
public void ModifyColumn(string tableName, string columnName, Column columnDefinition) { Database.ExecuteSql(Dialect.GetModifyColumnSql(tableName, columnName, columnDefinition)); }
public virtual void RemoveForeignKey(string foreigKeyName, string tableName) { string sql = Dialect.GetDropForeignKeySql(foreigKeyName, tableName); Database.ExecuteSql(sql); }
public void RenameTable(string tableName, string newTableName) { string sql = Dialect.GetRenameTableSql(tableName, newTableName); Database.ExecuteSql(sql); }
public void RenameColumn(string tableName, string columnName, string newColumnName) { string sql = Dialect.GetRenameColumnSql(tableName, columnName, newColumnName); Database.ExecuteSql(sql); }
public void RemovePrimaryKey(string tableName, string primaryKeyName) { string sql = Dialect.GetDropPrimaryKeySql(tableName, primaryKeyName); Database.ExecuteSql(sql); }
public virtual void RemoveColumnComment(string tableName, string columnName) { string sql = Dialect.GetRemoveCommentFromColumnSql(tableName, columnName); Database.ExecuteSql(sql); }
public virtual void AddUniqueKey(string uniqueKeyName, string tableName, params string[] columnNames) { string sql = Dialect.GetUniqueKeySql(uniqueKeyName, tableName, columnNames); Database.ExecuteSql(sql); }
public virtual void RemoveUniqueKey(string uniqueKeyName, string tableName) { string sql = Dialect.GetDropUniqueKeySql(uniqueKeyName, tableName); Database.ExecuteSql(sql); }
public virtual void AddColumn(string tableName, Column column) { string sql = Dialect.GetAddColumnSql(tableName, column); Database.ExecuteSql(sql); }
public virtual void RemoveIndex(string indexName, string table) { string sql = Dialect.GetDropIndexSql(indexName, table); Database.ExecuteSql(sql); }
public virtual void AddIndex(string indexName, string tableName, params string[] columnNames) { string sql = Dialect.GetCreateIndexSql(indexName, tableName, columnNames); Database.ExecuteSql(sql); }
public virtual void AddNamedPrimaryKey(string tableName, string pkName, params string[] columnNames) { string sql = Dialect.GetPrimaryKeySql(tableName, pkName, columnNames); Database.ExecuteSql(sql); }
public virtual void RemoveTableComment(string tableName) { string sql = Dialect.GetRemoveCommentFromTableSql(tableName); Database.ExecuteSql(sql); }