public override LastInsertId ExecuteInsert(DbCommand cmd, string idKey)
{
cmd.Execute();
cmd.Reset();
cmd.CommandText = "select @@IDENTITY as id";
var rez = cmd.GetRawValue();
return new LastInsertId(rez);
}
public override LastInsertId ExecuteInsert(DbCommand cmd, string idKey)
{
if (!string.IsNullOrEmpty(idKey))
{
cmd.CommandText += (" returning " + EscapeName(idKey));
}
return new LastInsertId(cmd.GetRawValue());
}
public override LastInsertId ExecuteInsert(DbCommand cmd, string idKey)
{
if (idKey != null)
{
cmd.CommandText += ";SELECT last_insert_rowid()";
var rez = cmd.GetRawValue();
return new LastInsertId(rez);
}
cmd.Execute();
return LastInsertId.Empty;
}
public override LastInsertId ExecuteInsert(DbCommand cmd, string idKey)
{
cmd.CommandText += ";SELECT LAST_INSERT_ID()";
var rez = cmd.GetRawValue();
return new LastInsertId(rez);
}
public override LastInsertId ExecuteInsert(DbCommand cmd, string idKey)
{
cmd.CommandText += ";Select SCOPE_IDENTITY() as id";
var rez = cmd.GetRawValue();
return new LastInsertId(rez);
}
