public void Insert()
{
var dapperInstance = _dapper;
#region 实体对象赋值
var entity = new DapperTestEntity()
{
bigint_value = 1,
bit_value = true,
bool_value = true,
boolean_value = true,
date_value = DateTime.Now.Date,
char_null_value = null,
dec_value = 1,
decimal_value = 1,
double_value = 1,
fix_value = 1,
float_value = 1,
int_value = 1,
integer_value = 1,
longtext_null_value = null,
mediumint_value = 1,
mediumint_null_value = null,
nchar_null_value = null,
nvarchar_null_value = null,
numeric_value = 1,
real_value = 1,
smallint_value = 1,
text_null_value = "",
tinytext_null_value = null,
tinyint_value = 1,
varbinary_null_value = new byte[] { 0x01, 0x02, 0x03 },
binary_null_value = new byte[] { 0x01, 0x02, 0x03 },
id = 1
};
#endregion
try
{
ClearDapperTestEntity();
//Dapper插入对象
dapperInstance.Insert(entity);
string sql = string.Format("select * from dapper_all_test where id = '{0}'", entity.id);
helper.ExecuteReader("select * from dapper_all_test where id=1", reader =>
{
while (reader.Read())
{
CompareHelper.Compare(reader, entity);
}
});
}
finally
{
ClearDapperTestEntity();
}
}
private DapperTestEntity CreateDapperTestEntity(int id = 1)
{
var entity = new DapperTestEntity
{
bigint_value = 1,
bit_value = true,
bool_value = true,
boolean_value = true,
date_value = DateTime.Now,
char_null_value = null,
dec_value = 1,
decimal_value = 1,
double_value = 1,
fix_value = 1,
float_value = 1,
int_value = 1,
integer_value = 1,
longtext_null_value = null,
mediumint_null_value = null,
nchar_null_value = null,
nvarchar_null_value = null,
mediumint_value = 1,
numeric_value = 1,
real_value = 1,
tinytext_null_value = null,
smallint_value = 1,
text_null_value = "",
tinyint_value = 1,
id = id,
datetime_value = new DateTime(2016, 12, 12, 4, 4, 4)
};
var sql = string.Format(@"
insert into dapper_all_test(
bigint_value,bit_value,bool_value,boolean_value,date_value,dec_value,decimal_value,double_value,fix_value,float_value,int_value,integer_value,
mediumint_value,numeric_value,real_value,smallint_value,text_null_value,tinyint_value,id,datetime_value)
value ({0},{1},{2},{3},'{4}','{5}',{6},{7},{8},{9},{10},{11},{12},{13},{14},{15},'{16}',{17},{18},'{19}')",
entity.bigint_value, entity.bit_value == true ? 1 : 0, entity.bool_value == true ? 1 : 0, entity.boolean_value == true ? 1 : 0, entity.date_value.ToString("yyyy-MM-dd HH:mm:ss"), entity.dec_value,
entity.decimal_value, entity.double_value, entity.fix_value, entity.float_value, entity.int_value, entity.integer_value, entity.mediumint_value, entity.numeric_value, entity.real_value, entity.smallint_value, entity.text_null_value
, entity.tinyint_value, entity.id, entity.datetime_value.ToString("yyyy-MM-dd HH:mm:ss"));
if (helper.ExecuteSQL(sql, cmd => cmd.ExecuteNonQuery()) > 0)
{
return(entity);
}
return(null);
}
public static void Compare(DbDataReader reader, DapperTestEntity entity)
{
reader.ColumnValueCompare("id", Convert.ToInt32, entity.id)
.ColumnValueCompare("bigint_value", entity.bigint_value)
.ColumnValueCompare("bigint_null_value", entity.bigint_null_value)
.ColumnValueCompare("bit_value", Convert.ToBoolean, entity.bit_value)
.ColumnValueCompare("bit_null_value", entity.bit_null_value)
.ColumnValueCompare("bool_value", entity.bool_value)
.ColumnValueCompare("bool_null_value", entity.bool_null_value)
.ColumnValueCompare("boolean_value", entity.boolean_value)
.ColumnValueCompare("boolean_null_value", entity.boolean_null_value)
.ColumnValueCompare("char_null_value", entity.char_null_value)
.ColumnValueCompare("date_value", dt => dt == null ? null : Convert.ToDateTime(dt).ToString("yyyy-MM-dd"), entity.date_value.ToString("yyyy-MM-dd"))
.ColumnValueCompare("date_null_value", entity.date_null_value == null ? string.Empty : entity.date_null_value.Value.ToString("yyyy-MM-dd"))
.ColumnValueCompare("datetime_value", entity.datetime_value)
.ColumnValueCompare("datetime_null_value", entity.datetime_null_value)
.ColumnValueCompare("dec_value", entity.dec_value)
.ColumnValueCompare("dec_null_value", entity.dec_null_value)
.ColumnValueCompare("decimal_value", entity.decimal_value)
.ColumnValueCompare("decimal_null_value", entity.decimal_null_value)
.ColumnValueCompare("double_value", entity.double_value)
.ColumnValueCompare("double_null_value", entity.double_null_value)
.ColumnValueCompare("fix_value", entity.fix_value)
.ColumnValueCompare("fix_null_value", entity.fix_null_value)
.ColumnValueCompare("float_value", entity.float_value)
.ColumnValueCompare("float_null_value", entity.float_null_value)
.ColumnValueCompare("int_value", entity.int_value)
.ColumnValueCompare("int_null_value", entity.int_null_value)
.ColumnValueCompare("integer_value", entity.integer_value)
.ColumnValueCompare("integer_null_value", entity.integer_null_value)
.ColumnValueCompare("longtext_null_value", entity.longtext_null_value)
.ColumnValueCompare("mediumint_value", entity.mediumint_value)
.ColumnValueCompare("mediumint_null_value", entity.mediumint_null_value)
.ColumnValueCompare("mediumtext_null_value", entity.mediumtext_null_value)
.ColumnValueCompare("nchar_null_value", entity.nchar_null_value)
.ColumnValueCompare("numeric_value", entity.numeric_value)
.ColumnValueCompare("numeric_null_value", entity.numeric_null_value)
.ColumnValueCompare("nvarchar_null_value", entity.nvarchar_null_value)
.ColumnValueCompare("real_value", entity.real_value)
.ColumnValueCompare("real_null_value", entity.real_null_value)
.ColumnValueCompare("smallint_value", entity.smallint_value)
.ColumnValueCompare("smallint_null_value", entity.smallint_null_value)
.ColumnValueCompare("text_null_value", entity.text_null_value)
.ColumnValueCompare("tinyint_value", entity.tinyint_value)
.ColumnValueCompare("tinyint_null_value", entity.tinyint_null_value)
.ColumnValueCompare("tinytext_null_value", entity.tinytext_null_value)
.ColumnValueCompare("varchar_null_value", entity.varchar_null_value ?? string.Empty);
if (entity.binary_null_value == null)
{
reader.ColumnValueCompare("binary_null_value", string.Empty);
}
if (entity.varbinary_null_value != null)
{
reader.ColumnValueCompare("varbinary_null_value",
bytes => System.Text.Encoding.Default.GetString((byte[])bytes),
System.Text.Encoding.Default.GetString(entity.varbinary_null_value));
}
else
{
reader.ColumnValueCompare("varbinary_null_value", string.Empty);
}
}