private static void DapperInsertTest()
{
using (var conn = DepperService.MySqlConnection())
{
string sqlCommandStr = @"INSERT INTO address(CreateBy, Created, LastUpdate, LastUpdateBy, ModifiedNum, AddressDescription, ContactId, GeographyId) VALUE(@CreateBy,@Created,@LastUpdate,@LastUpdateBy,@ModifiedNum,@AddressDescription,@ContactId,@GeographyId);";
//返回自增主键
//sqlCommandStr += "SELECT @@Identity";
var address = new Address
{
CreateBy = 1,
Created = DateTime.Now,
LastUpdate = DateTime.Now,
LastUpdateBy = 1,
ModifiedNum = 1,
AddressDescription = "",
ContactId = 11,
GeographyId = null
};
//var categoryId1 = conn.Execute(sqlCommandStr, category);
//var categoryId = conn.Query<long>(sqlCommandStr, category).ToList().FirstOrDefault();
var ee = conn.Execute(sqlCommandStr, address);
Console.WriteLine(ee);
}
}
private static void DapperQueryTest()
{
using (var conn = DepperService.MySqlConnection())
{
string sqlCommandStr = @"SELECT * FROM address";
var userList = conn.Query <Address>(sqlCommandStr).ToList();
Console.ReadLine();
}
}
