事务:///<summary>/// 删除考勤///</summary>///<param name="dto">Id</param>///<returns></returns>public ResultEntity<bool> DeleteAttend(DelAttendEditorDTO dto){//SqlConnection con = new SqlConnection(@"Data Source=.SQLEXPRESS;database=aaaa;uid=sa;pwd=jcx");//con.Open();using (var context = new HRModelsContainer()){var trans = context.Database.BeginTransaction();try{foreach (var Id in dto.Ids){//先删...
privatestaticvoid Execute(string connectionString){using (SqlConnection connection = new SqlConnection(connectionString)){connection.Open();SqlTransaction transaction;using (SqlCommand cmd = connection.CreateCommand()){//启动事务transaction = connection.BeginTransaction();cmd.Connection = connection;cmd.Transaction = transaction;try{cmd.CommandText = "sql语句!";cmd.ExecuteNonQuery();//完成提交 ...
转自http://blog.csdn.net/allen3010/article/details/6336717
这个是针对ACCESS数据库操作的类,同样也是从SQLHELPER提取而来,分页程序的调用可以参考MSSQL那个类的调用,差不多的,只是提取所有记录的数量的时候有多一个参数,这个需要注意一下!c# 代码using System;? ? using System.Text;? ? using System.Collections;? ? using System.Collections.Specialized;? ? using System.Data;? ? using System.Data.OleDb;? ? usi...
1.引入相应的命名空间using System.Transactions;2.代码事例(using (TransactionScope ts = new TransactionScope())) 1public JsonResult DriverCommentAdd(OrderComment orderComment)2 {3 4try 5 {6using (TransactionScope ts = new TransactionScope())7 {8var order = db.Orders.SingleOrDefault(p => p.ID == orderComment.OrderID);9if (order.OrderStatus == (byte)OrderStatus.Command...
本文转载:http://www.cnblogs.com/lovecherry/archive/2007/08/20/862365.html检测并发 首先使用下面的SQL语句查询数据库的产品表:select * from products where categoryid=1 查询结果如下图:
为了看起来清晰,我已经事先把所有分类为1产品的价格和库存修改为相同值了。然后执行下面的程序: var query = from p in ctx.Products where p.CategoryID == 1 select p; foreach (var p in qu...
1//2015/07/03 2using System;3using System.Collections.Generic;4using System.Linq;5using System.Text;6using System.Threading.Tasks;7using System.Data;8using System.Data.SqlClient;910namespace Ado.netstart_1
11{
12class Program
13 {
14staticvoid Main(string[] args)
15 {
16//特殊的字符串,数据库连接串
17//第一种18string connectionString = "server=.;database=BookSample;uid=LJK;pwd=123456;";
...
关于业务有涉及到事务的,例子简单使用,就基本知识而已。只是EF的版本不同,写法不同罢了。 1using (var trans = _db.Database.BeginTransaction()) //EF 6.0版本;EF 4.0版本是:_db.Database.Connection.BeginTransaction() 2{3 4//业务逻辑代码 5 6 _db.Entry<Model>(model).State = System.Data.Entity.EntityState.Add;7}8}9try10{
11_db.SaveChanges();
12trans.Commit();
13}
14catch (Exception)
15{
16trans.Rollback();...
(一)简介事务的主要特征是,任务要么全部完成,要么都不完成。 (二)概述事务由事务管理器来管理和协调。每个影响事务结果的资源都由一个资源管理器来管理。事务管理器与资源管理器通信,以定义事务的结果。 1、事务处理阶段激活阶段:在这个阶段创建事务。准备阶段:在这个阶段,每个资源管理器都可以定义事务的结果。提交阶段:当所有的资源管理器都成功准备好了,就开始这个阶段。 2、ACID属性事务的特征可以用术语ACID来定...
代码如下:/// <summary> /// 执行多条sql语句,实现事务 /// </summary> /// <param name="arraySql">多条sql语句</param> public int ExecutrSqlTran(System.Collections.ArrayList arraySql) { int itemnum; DbOpen(); SqlCommand cm = new SqlCommand(); cm.Connection = scn; SqlTransaction tx = scn.BeginTransaction(); cm.Transaction = tx; try { for (int i = 0; i < arraySql.Count; i++) { string strSql = arraySql[i...
//2015/07/032 using System;3 using System.Collections.Generic;4 using System.Linq;5 using System.Text;6 using System.Threading.Tasks;7 using System.Data;8 using System.Data.SqlClient;9
10 namespace Ado.netstart_1
11 {
12 class Program
13 {
14 static void Main(string[] args)
15 {
16 //特殊的字符串,数据库连接串
17 //第一种
18 string conne...
Program{class Result<T>{public T data;public string Message;public bool Success;public string StackTrace;}struct ExecuteableUnit{public string SQL;public SqlParameter[] param;}/// <summary>/// 执行多条SQL语句,实现数据库事务。/// </summary>/// <param name="SQLStringList">SQL语句的哈希表(key为sql语句,value是该语句的SqlParameter[])</param>private static Result<int> ExecuteSqlTransaction(params Ex...
static void Execute(string connectionString){using (SqlConnection connection = new SqlConnection(connectionString)){connection.Open();SqlTransaction transaction;using (SqlCommand cmd = connection.CreateCommand()){//启动事务transaction = connection.BeginTransaction();cmd.Connection = connection;cmd.Transaction = transaction;try{cmd.CommandText = "sql语句!";cmd.ExecuteNonQuery();//完成提交transacti...
static bool CreateUserOrder(UserOrder model, string Ids){List<string> SQLStringList = new List<string>();List<DbParameter[]> Parameters = new List<DbParameter[]>();StringBuilder strSql = new StringBuilder();//添加OrderInforSqlParameter[] parameters1 = OrderInforDAL.BuildOrderInforAddParameter(model.UserId, model.OrderCode, Ids, ref strSql);SQLStringList.Add(strSql.ToString());Parameters.Add(parame...
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Configuration; using System.Data.SqlClient; namespace 用户激活 { public partial class WebForm3 : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void Button1_Click(object sender, EventArgs e) { ...
#region 调用事务
public static bool UpdateByTran(List sqlList)
{
SqlConnection conn = new SqlConnection(connString);
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
try
{
conn.Open();
//开启事务
cmd.Transaction = conn.BeginTransaction();
//遍历所有sql语句,依次执行
foreach (string item in sqlList)
{
cmd.CommandText = item;
cmd.ExecuteNonQuery();
}
//如果全部执行完毕,提交事务
cmd.Transacti...