public void ExecuteDDL() { if (ContinueIfTableExists()) { _db.ExecuteCommand(GetSql()); } }
public static int DeleteFrom <T>(this IAccessDb db, string condition, params object[] args) { var ti = TableInfo.ForType(typeof(T)); return (db.ExecuteCommand( string.Format("delete from {0} where {1}", db.Provider.EscapeName(ti.Name), condition), args)); }
public void Untrack(params string[] schemas) { if (schemas.Length == 0) { return; } _db.ExecuteCommand("delete from " + TableName + " where SchemaName in (@0)", schemas.ToList()); }
public void ExecuteDDL() { using (var t = _db.BeginTransaction()) { _db.ExecuteCommand(GetSql()); t.Commit(); } }
private static int Update(IAccessDb db, TableInfo ti, object data, object id = null, string filterColumn = null) { var sb = new StringBuilder(); sb.AppendFormat("update {0} set", db.Provider.EscapeName(ti.Name)); var d = data.ToDictionary(); bool hasId = false; int i = 0; var args = new List <object>(); foreach (var k in d) { if (k.Key == ti.PrimaryKey) { hasId = true; continue; } if (ti.Excludes.Any(c => c == k.Key)) { continue; } sb.AppendFormat(" {0}={1},", db.Provider.EscapeName(k.Key), db.Provider.ParamPrefix + i); if (ti.ConvertToString.Any(s => s == k.Key)) { args.Add(k.Value.ToString()); } else { args.Add(k.Value); } i++; } sb.Remove(sb.Length - 1, 1); if (filterColumn.IsNullOrEmpty()) { filterColumn = ti.PrimaryKey; } if (id != null || hasId) { sb.AppendFormat(" where {0}={1}", db.Provider.EscapeName(filterColumn), db.Provider.ParamPrefix + i); hasId = true; if (id == null) { id = d[ti.PrimaryKey]; } } if (hasId) { args.Add(id); } return(db.ExecuteCommand(sb.ToString(), args.ToArray())); }
public static int DeleteFrom <T>(this IAccessDb db, Expression <Func <T, bool> > criteria = null) { var builder = new ExpressionSqlBuilder <T>(db.Provider.BuilderHelper); builder.WriteDelete(); if (criteria != null) { builder.Where(criteria); } return(db.ExecuteCommand(builder.ToString(), builder.Parameters.ToArray())); }
public int Execute() { return(_db.ExecuteCommand(_builder.ToString(), _builder.Parameters.ToArray())); }