public void TestMethon3()
{
NewCity n = new NewCity()
{
CityID = 1,
CityName = "保定",
NewName = "新北京"
};
City c = new City();
c = n;
Console.WriteLine(c.CityName);
//string _connectionString = "Data Source=.;Initial Catalog=SportsDB;Persist Security Info=True;User ID=sa;Password=11111111;Integrated Security=True";
//System.Data.IDbConnection connection = new System.Data.SqlClient.SqlConnection(_connectionString);
System.Data.IDbConnection connection = Comm.Helper.DapperHelper.Instance;
connection.Open();
System.Data.IDbTransaction transaction = connection.BeginTransaction();
List <M_User> user = new List <M_User>()
{
new M_User()
{
UserName = "******", Pwd = "111111"
},
new M_User()
{
UserName = "******", Pwd = "11111111111111111111111111111111"
},
};
try
{
connection.Insert <M_User>(user, transaction);
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
}
}
