public void ExecuteInsertException () { SqlPoker sql = new SqlPoker (); sql.ConnectionString = "Data Source=fake\\SQLEXPRESS;Initial Catalog=Northwind;User ID=sa"; sql.ProviderName = "System.Data.SqlClient"; CustomSqlDataSourceView view = new CustomSqlDataSourceView (sql, "TestView", null); view.SelectCommandType = SqlDataSourceCommandType.Text; view.SelectCommand = "SELECT * FROM products WHERE ProductID = @ProductID;"; view.Insert (null); }
public void ExecuteInsertWithCollection () { SqlPoker sql = new SqlPoker (); sql.ConnectionString = "Data Source=fake\\SQLEXPRESS;Initial Catalog=Northwind;User ID=sa"; sql.ProviderName = "System.Data.SqlClient"; CustomSqlDataSourceView view = new CustomSqlDataSourceView (sql, "TestView", null); view.SelectCommandType = SqlDataSourceCommandType.Text; view.SelectCommand = "SELECT * FROM products WHERE ProductID = @ProductID;"; view.InsertCommandType = SqlDataSourceCommandType.Text; view.InsertCommand = "INSERT INTO products (UserId, UserName) VALUES ({0},{1})"; view.InsertParameters.Add (new Parameter ("UserId", TypeCode.Int32, "15")); view.InsertParameters.Add (new Parameter ("UserName", TypeCode.String, "newuser")); view.OldValuesParameterFormatString = "origin_{0}"; view.Inserting += new SqlDataSourceCommandEventHandler (view_Inserting); Hashtable value = new Hashtable (); value.Add ("Description", "TestDescription"); view.Insert (value); Assert.IsNotNull (CustomEventParameterCollection, "Insert event not fired"); Assert.AreEqual (3, CustomEventParameterCollection.Count, "Parameter count"); Assert.AreEqual ("@UserId", CustomEventParameterCollection[0].ParameterName, "Parameter name#1"); Assert.AreEqual (15, CustomEventParameterCollection[0].Value, "Parameter value#1"); Assert.AreEqual ("@UserName", CustomEventParameterCollection[1].ParameterName, "Parameter name#2"); Assert.AreEqual ("newuser", CustomEventParameterCollection[1].Value, "Parameter value#2"); Assert.AreEqual ("@Description", CustomEventParameterCollection[2].ParameterName, "Parameter name#3"); Assert.AreEqual ("TestDescription", CustomEventParameterCollection[2].Value, "Parameter value#3"); }