public override bool TryFetchInsertedKey(FetchInsertedKeyLocation location, out string sql)
{
switch (location)
{
case FetchInsertedKeyLocation.BeforeValues:
sql = "OUTPUT Inserted.Id";
return(true);
default:
sql = null;
return(false);
}
}
public override bool TryFetchInsertedKey(FetchInsertedKeyLocation location, out string sql)
{
switch (location)
{
case FetchInsertedKeyLocation.AfterStatement:
sql = "SELECT LAST_INSERT_ROWID() AS \"Id\"";
return(true);
default:
sql = null;
return(false);
}
}
public bool TryFetchInsertedKey(FetchInsertedKeyLocation location, out string sql)
{
switch (location)
{
case FetchInsertedKeyLocation.AfterStatement:
sql = $"SELECT LAST_INSERT_ROWID() AS {Quote}Id{Quote}";
return(true);
case FetchInsertedKeyLocation.BeforeValues:
sql = null;
return(false);
default:
sql = null;
return(false);
}
}
public abstract bool TryFetchInsertedKey(FetchInsertedKeyLocation location, out string sql);
public bool TryFetchInsertedKey(FetchInsertedKeyLocation location, out string sql)
{
sql = null;
return(false);
}
public bool TryFetchInsertedKey(FetchInsertedKeyLocation location, out string sql)
{
throw new NotImplementedException();
}