public static int Insert <T>(this DbAccessor db, object objParameters)
{
var mapping = new TableMapping(typeof(T));
mapping.FilterColumn(objParameters);
ISqlBuilder sqlBuilder = new DefaultSqlBuilder(mapping);
return(db.ExecuteNonQuery(sqlBuilder.BuildInsert(), objParameters));
}
public void TableMapping()
{
TableMapping table = new TableMapping(typeof(SysProduct));
Console.WriteLine(table.TableName);
foreach (var col in table.Columns)
{
Console.WriteLine(col.ColumnName + " " + col.IsPrimaryKey);
}
DefaultSqlBuilder sqlb = new DefaultSqlBuilder(table);
Console.WriteLine(sqlb.BuildDelete());
Console.WriteLine(sqlb.BuildInsert());
Console.WriteLine(sqlb.BuildUpdate());
}
public static int Insert(this DbAccessor db, object objEntity)
{
ISqlBuilder sqlBuilder = new DefaultSqlBuilder(new TableMapping(objEntity.GetType()));
return(db.ExecuteNonQuery(sqlBuilder.BuildInsert(), objEntity));
}