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); } }