public override IDbCommand CreateLastInsertIdCommand(string tableName, IDbCommandFactory commandFactory)
{
return commandFactory.Create(null, "select @@identity");
}
public override IDbCommand CreateGetTableMetadataCommand(string tableName, IDbCommandFactory commandFactory)
{
var parameters = new[] { new Parameter("tableName", tableName) };
var sql = string.Format("select * from information_schema.columns where table_name = {0}tableName", parameterPrefix);
return commandFactory.Create(parameters, sql);
}
public override IDbCommand CreateGetTableMetadataCommand(string tableName, IDbCommandFactory commandFactory)
{
var parameters = new[] { new Parameter("tableName", tableName) };
var sql = string.Format("SELECT * FROM `information_schema`.`COLUMNS` WHERE `TABLE_NAME` = {0}tableName", parameterPrefix);
return commandFactory.Create(parameters, sql);
}
public override IDbCommand CreateLastInsertIdCommand(string tableName, IDbCommandFactory commandFactory)
{
return commandFactory.Create(null, "SELECT LAST_INSERT_ID() FROM " + tableName);
}
public override IDbCommand CreateLastInsertIdCommand(string tableName, IDbCommandFactory commandFactory)
{
return commandFactory.Create(null, "SELECT last_insert_rowid()");
}