操作数据
using (Model1 dbContext = new Model1())
{
DbContextTransaction trans = null;
try
{
trans = dbContext.Database.BeginTransaction();
string sql = "Update [Areas] Set Name='Dobong-gu' WHERE Id=@Id";
SqlParameter parameter = new SqlParameter("@Id", 1);
dbContext.Database.ExecuteSqlCommand(sql, parameter);
trans.Commit();
}
catch (Exception ex)
{
if (trans != null)
trans.Rollback();
throw ex;
}
finally
{
trans.Dispose();
}
}
查询数据
using (Model1 dbContext = new Model1())
{
DbContextTransaction trans = null;
try
{
trans = dbContext.Database.BeginTransaction();
string sql = "SELECT * FROM [Areas] WHERE Id=@Id";
SqlParameter parameter = new SqlParameter("@Id", 1);
List<Areas> userList = dbContext.Database.SqlQuery<Areas>(sql, parameter).ToList<Areas>();
trans.Commit();
}
catch (Exception ex)
{
if (trans != null)
trans.Rollback();
throw ex;
}
finally
{
trans.Dispose();
}
}