public static void DeleteById(this IDbCommand dbCmd, Type objectType, object id)
{
var modelDef = ModelDefinition.GetModelDefinition(objectType);
var sql = string.Format("DELETE FROM {0} WHERE {1} = {2}",
OrmLiteConfig.DialectProvider.GetQuotedTableName(modelDef),
OrmLiteConfig.DialectProvider.GetQuotedColumnName(modelDef.PrimaryKey.FieldName),
OrmLiteConfig.DialectProvider.GetQuotedValue(id, id.GetType()));
dbCmd.ExecuteSql(sql);
}
public static Object ConvertTo(this IDataReader dataReader, Type returnType)
{
var fieldDefs = ModelDefinition.GetModelDefinition(returnType).FieldDefinitionsArray;
using (dataReader)
{
if (dataReader.Read())
{
var row = Activator.CreateInstance(returnType);
row.PopulateWithSqlReader(dataReader, fieldDefs);
return(row);
}
return(null);
}
}
public static List <Object> ConvertToList(this IDataReader dataReader, Type rowType)
{
var fieldDefs = ModelDefinition.GetModelDefinition(rowType).FieldDefinitionsArray;
var to = new List <Object>();
using (dataReader)
{
while (dataReader.Read())
{
var row = Activator.CreateInstance(rowType);
row.PopulateWithSqlReader(dataReader, fieldDefs);
to.Add(row);
}
}
return(to);
}
public static Object GetByIdOrDefault(this IDbCommand dbCmd, Type returnType, object idValue)
{
return(FirstOrDefault(dbCmd, returnType, OrmLiteConfig.DialectProvider.GetQuotedColumnName(ModelDefinition.GetModelDefinition(returnType).PrimaryKey.FieldName) + " = {0}".SqlFormat(idValue)));
}
