public void InsertSync()
{
ClearTestEntity();
var dapperInstance = _dapper;
#region 实体对象赋值
var entity = new DapperAllTest()
{
BigintValue = 1,
BitValue = true,
BoolValue = true,
BooleanValue = true,
DateValue = DateTime.Now.Date,
CharNullValue = null,
DecValue = 1,
DecimalValue = 1,
DoubleValue = 1,
FixValue = 1,
FloatValue = 1,
IntValue = 1,
IntegerValue = 1,
LongtextNullValue = null,
MediumintValue = 1,
MediumintNullValue = null,
NcharNullValue = null,
NvarcharNullValue = null,
NumericValue = 1,
RealValue = 1,
SmallintValue = 1,
TextNullValue = "",
TinytextNullValue = null,
TinyintValue = 1,
VarbinaryNullValue = new byte[] { 0x01, 0x02, 0x03 },
BinaryNullValue = new byte[] { 0x01, 0x02, 0x03 },
Id = 1
};
#endregion
try
{
//Dapper插入对象
dapperInstance.InsertAsync(entity).GetAwaiter().GetResult();
string sql = string.Format("select * from DapperAllTest where id = '{0}'", entity.Id);
helper.ExecuteReader(sql, reader =>
{
while (reader.Read())
{
CompareHelper.ComparePascalCase(reader, entity);
}
});
}
finally
{
ClearTestEntity();
}
}
private DapperAllTest CreateTestEntity(int id = 1)
{
var entity = new DapperAllTest
{
BigintValue = 1,
BitValue = true,
BoolValue = true,
BooleanValue = true,
DateValue = DateTime.Now,
CharNullValue = null,
DecValue = 1,
DecimalValue = 1,
DoubleValue = 1,
FixValue = 1,
FloatValue = 1,
IntValue = 1,
IntegerValue = 1,
LongtextNullValue = null,
MediumintNullValue = null,
NcharNullValue = null,
NvarcharNullValue = null,
MediumintValue = 1,
NumericValue = 1,
RealValue = 1,
TinytextNullValue = null,
SmallintValue = 1,
TextNullValue = "",
TinyintValue = 1,
Id = id,
DatetimeValue = new DateTime(2016, 12, 12, 4, 4, 4)
};
var sql = string.Format(@"
insert into DapperAllTest(
BigintValue,BitValue,BoolValue,BooleanValue,DateValue,DecValue,DecimalValue,DoubleValue,FixValue,FloatValue,IntValue,IntegerValue,
MediumintValue,NumericValue,RealValue,SmallintValue,TextNullValue,TinyintValue,Id,DatetimeValue)
value ({0},{1},{2},{3},'{4}','{5}',{6},{7},{8},{9},{10},{11},{12},{13},{14},{15},'{16}',{17},{18},'{19}')",
entity.BigintValue, entity.BitValue == true ? 1 : 0, entity.BoolValue == true ? 1 : 0, entity.BooleanValue == true ? 1 : 0, entity.DateValue.ToString("yyyy-MM-dd HH:mm:ss"), entity.DecValue,
entity.DecimalValue, entity.DoubleValue, entity.FixValue, entity.FloatValue, entity.IntValue, entity.IntegerValue, entity.MediumintValue, entity.NumericValue, entity.RealValue, entity.SmallintValue, entity.TextNullValue
, entity.TinyintValue, entity.Id, entity.DatetimeValue.ToString("yyyy-MM-dd HH:mm:ss"));
if (helper.ExecuteSQL(sql, cmd => cmd.ExecuteNonQuery()) > 0)
{
return(entity);
}
return(null);
}
public static void ComparePascalCase(DbDataReader reader, DapperAllTest entity)
{
reader.ColumnValueCompare("Id", Convert.ToInt32, entity.Id)
.ColumnValueCompare("BigintValue", entity.BigintValue)
.ColumnValueCompare("BigintNullValue", entity.BigintNullValue)
.ColumnValueCompare("BitValue", Convert.ToBoolean, entity.BitValue)
.ColumnValueCompare("BitNullValue", entity.BitNullValue)
.ColumnValueCompare("BoolValue", entity.BoolValue)
.ColumnValueCompare("BoolNullValue", entity.BoolNullValue)
.ColumnValueCompare("BooleanValue", entity.BooleanValue)
.ColumnValueCompare("BooleanNullValue", entity.BooleanNullValue)
.ColumnValueCompare("CharNullValue", entity.CharNullValue)
.ColumnValueCompare("DateValue", dt => dt == null ? null : Convert.ToDateTime(dt).ToString("yyyy-MM-dd"), entity.DateValue.ToString("yyyy-MM-dd"))
.ColumnValueCompare("DateNullValue", entity.DateNullValue == null ? string.Empty : entity.DateNullValue.Value.ToString("yyyy-MM-dd"))
.ColumnValueCompare("DatetimeValue", entity.DatetimeValue)
.ColumnValueCompare("DatetimeNullValue", entity.DatetimeNullValue)
.ColumnValueCompare("DecValue", entity.DecValue)
.ColumnValueCompare("DecNullValue", entity.DecNullValue)
.ColumnValueCompare("DecimalValue", entity.DecimalValue)
.ColumnValueCompare("DecimalNullValue", entity.DecimalNullValue)
.ColumnValueCompare("DoubleValue", entity.DoubleValue)
.ColumnValueCompare("DoubleNullValue", entity.DoubleNullValue)
.ColumnValueCompare("FixValue", entity.FixValue)
.ColumnValueCompare("FixNullValue", entity.FixNullValue)
.ColumnValueCompare("FloatValue", entity.FloatValue)
.ColumnValueCompare("FloatNullValue", entity.FloatNullValue)
.ColumnValueCompare("IntValue", entity.IntValue)
.ColumnValueCompare("IntNullValue", entity.IntNullValue)
.ColumnValueCompare("IntegerValue", entity.IntegerValue)
.ColumnValueCompare("IntegerNullValue", entity.IntegerNullValue)
.ColumnValueCompare("LongtextNullValue", entity.LongtextNullValue)
.ColumnValueCompare("MediumintValue", entity.MediumintValue)
.ColumnValueCompare("MediumintNullValue", entity.MediumintNullValue)
.ColumnValueCompare("MediumtextNullValue", entity.MediumtextNullValue)
.ColumnValueCompare("NcharNullValue", entity.NcharNullValue)
.ColumnValueCompare("NumericValue", entity.NumericValue)
.ColumnValueCompare("NumericNullValue", entity.NumericNullValue)
.ColumnValueCompare("NvarcharNullValue", entity.NvarcharNullValue)
.ColumnValueCompare("RealValue", entity.RealValue)
.ColumnValueCompare("RealNullValue", entity.RealNullValue)
.ColumnValueCompare("SmallintValue", entity.SmallintValue)
.ColumnValueCompare("SmallintNullValue", entity.SmallintNullValue)
.ColumnValueCompare("TextNullValue", entity.TextNullValue)
.ColumnValueCompare("TinyintValue", entity.TinyintValue)
.ColumnValueCompare("TinyintNullValue", entity.TinyintNullValue)
.ColumnValueCompare("TinytextNullValue", entity.TinytextNullValue)
.ColumnValueCompare("VarcharNullValue", entity.VarcharNullValue ?? string.Empty);
if (entity.BinaryNullValue == null)
{
reader.ColumnValueCompare("BinaryNullValue", string.Empty);
}
if (entity.VarbinaryNullValue != null)
{
reader.ColumnValueCompare("VarbinaryNullValue",
bytes => System.Text.Encoding.Default.GetString((byte[])bytes),
System.Text.Encoding.Default.GetString(entity.VarbinaryNullValue));
}
else
{
reader.ColumnValueCompare("VarbinaryNullValue", string.Empty);
}
}
public static void Compare(DbDataReader reader, DapperAllTest entity)
{
reader.ColumnValueCompare("id", Convert.ToInt32, entity.Id)
.ColumnValueCompare("bigint_value", entity.BigintValue)
.ColumnValueCompare("bigint_null_value", entity.BigintNullValue)
.ColumnValueCompare("bit_value", Convert.ToBoolean, entity.BitValue)
.ColumnValueCompare("bit_null_value", entity.BitNullValue)
.ColumnValueCompare("bool_value", entity.BoolValue)
.ColumnValueCompare("bool_null_value", entity.BoolNullValue)
.ColumnValueCompare("boolean_value", entity.BooleanValue)
.ColumnValueCompare("boolean_null_value", entity.BooleanNullValue)
.ColumnValueCompare("char_null_value", entity.CharNullValue)
.ColumnValueCompare("date_value", dt => dt == null ? null : Convert.ToDateTime(dt).ToString("yyyy-MM-dd"), entity.DateValue.ToString("yyyy-MM-dd"))
.ColumnValueCompare("date_null_value", entity.DateNullValue == null ? string.Empty : entity.DateNullValue.Value.ToString("yyyy-MM-dd"))
.ColumnValueCompare("datetime_value", entity.DatetimeValue)
.ColumnValueCompare("datetime_null_value", entity.DatetimeNullValue)
.ColumnValueCompare("dec_value", entity.DecValue)
.ColumnValueCompare("dec_null_value", entity.DecNullValue)
.ColumnValueCompare("decimal_value", entity.DecimalValue)
.ColumnValueCompare("decimal_null_value", entity.DecimalNullValue)
.ColumnValueCompare("double_value", entity.DoubleValue)
.ColumnValueCompare("double_null_value", entity.DoubleNullValue)
.ColumnValueCompare("fix_value", entity.FixValue)
.ColumnValueCompare("fix_null_value", entity.FixNullValue)
.ColumnValueCompare("float_value", entity.FloatValue)
.ColumnValueCompare("float_null_value", entity.FloatNullValue)
.ColumnValueCompare("int_value", entity.IntValue)
.ColumnValueCompare("int_null_value", entity.IntNullValue)
.ColumnValueCompare("integer_value", entity.IntegerValue)
.ColumnValueCompare("integer_null_value", entity.IntegerNullValue)
.ColumnValueCompare("longtext_null_value", entity.LongtextNullValue)
.ColumnValueCompare("mediumint_value", entity.MediumintValue)
.ColumnValueCompare("mediumint_null_value", entity.MediumintNullValue)
.ColumnValueCompare("mediumtext_null_value", entity.MediumtextNullValue)
.ColumnValueCompare("nchar_null_value", entity.NcharNullValue)
.ColumnValueCompare("numeric_value", entity.NumericValue)
.ColumnValueCompare("numeric_null_value", entity.NumericNullValue)
.ColumnValueCompare("nvarchar_null_value", entity.NvarcharNullValue)
.ColumnValueCompare("real_value", entity.RealValue)
.ColumnValueCompare("real_null_value", entity.RealNullValue)
.ColumnValueCompare("smallint_value", entity.SmallintValue)
.ColumnValueCompare("smallint_null_value", entity.SmallintNullValue)
.ColumnValueCompare("text_null_value", entity.TextNullValue)
.ColumnValueCompare("tinyint_value", entity.TinyintValue)
.ColumnValueCompare("tinyint_null_value", entity.TinyintNullValue)
.ColumnValueCompare("tinytext_null_value", entity.TinytextNullValue)
.ColumnValueCompare("varchar_null_value", entity.VarcharNullValue ?? string.Empty);
if (entity.BinaryNullValue == null)
{
reader.ColumnValueCompare("binary_null_value", string.Empty);
}
if (entity.VarbinaryNullValue != null)
{
reader.ColumnValueCompare("varbinary_null_value",
bytes => System.Text.Encoding.Default.GetString((byte[])bytes),
System.Text.Encoding.Default.GetString(entity.VarbinaryNullValue));
}
else
{
reader.ColumnValueCompare("varbinary_null_value", string.Empty);
}
}
