zy02-2011 ADO.NET-02-字符串加密.pptx

ADO.NET-02-字符串加密;多种方式;编码加密;使用工具加密;自行加密;public static void SetConfigValue(string AppKey, string AppValue) { XmlDocument xDoc = new XmlDocument(); //获取可执行文件的路径和名称 string path = System.Windows.Forms.Application.ExecutablePath + .config; xDoc.Load(path); XmlNode xNode; XmlElement xElem1; XmlElement xElem2; xNode = xDoc.SelectSingleNode(//connectionStrings); xElem1 = (XmlElement)xNode.SelectSingleNode(//add [@name= + AppKey + ]); if (xElem1 != null) xElem1.SetAttribute(connectionString, AppValue); xDoc.Save(System.Windows.Forms.Application.ExecutablePath + .config); };SQL身份验证;连接池 ;连接池（续） ;连接池（续） ;连接池;异常处理;异常处理;为什么需要事务;什么是事务;事务的特性;MultipleActiveResultSets=true;(第三课中的MARS) theTransaction = theConnection.BeginTransaction(myFirstTransaction); theCommand.CommandText = UPDATE product SET listprice = 59.99 WHERE productid = 2020; theCommand.Transaction = theTransaction; theCommand.ExecuteNonQuery(); theSecondCommand.CommandText = INSERT INTO product (ProductName, ProductDescription, ListPrice, ProductTypeID, ReleaseDate, ListPriceCurrency) + VALUES (Super Fight 2, The sequel to the #1 XBox 360 game that never was, 59.99, 1, 2008-11-01, USD); theSecondCommand.Transaction = theTransaction; theSecondCommand.ExecuteNonQuery(); theTransaction.Commit(); Console.WriteLine(Transaction committed.);;单元测试P38;第二课 数据提供程序与较复杂连接场景Using Data Providers and More Complex Connection Scenarios;DbProviderFactory theFactory = DbProviderFactories.GetFactory (System.Data.SqlClient); DbConnection theConnection = theFactory.CreateConnection(); theConnection.ConnectionString