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");
}
