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()));
}
