public void OrdersInsertBad() { var storage = new SqlServerStorage(typeof(OrdersVerticalBar)); storage.ServerName = "NEON-64"; storage.DatabaseName = "Northwind"; storage.InsertSqlCallback = new InsertSqlHandler(GetInsertSqlOrder); var res = (OrdersVerticalBar[]) CommonEngine.ReadFile(typeof(OrdersVerticalBar), TestCommon.GetPath("Good", "OrdersVerticalBar.txt")); var res2 = new OrdersVerticalBar[1]; res2[0] = res[0]; //storage.ExecuteInBatchSize //res2[0].OrderDate = new DateTime(1750, 10, 10); try { storage.InsertRecords(res2); } catch (SqlException ex) { if (ex.Number == 208) { Assert.Ignore("You dont have this tables in your SqlServer"); } if (ex.Number == 6) { Assert.Ignore("SqlServer not found, skipping this test."); } Assert.Ignore(ex.ToString()); } }
protected string GetInsertSqlOrder(object record) { OrdersVerticalBar obj = (OrdersVerticalBar)record; return(String.Format("INSERT INTO OrdersTemp (CustomerId, OrderDate) " + " VALUES ('{0}' , '{1}'); ", obj.CustomerID, obj.OrderDate.ToShortDateString() )); }
protected void FillRecordOrder(object rec, object[] fields) { OrdersVerticalBar record = (OrdersVerticalBar)rec; record.OrderID = (int)fields[0]; record.CustomerID = (string)fields[1]; record.EmployeeID = (int)fields[2]; record.OrderDate = (DateTime)fields[3]; record.RequiredDate = (DateTime)fields[4]; if (fields[5] != DBNull.Value) { record.ShippedDate = (DateTime)fields[5]; } else { record.ShippedDate = DateTime.MinValue; } record.ShipVia = (int)fields[6]; record.Freight = (decimal)fields[7]; }
public void OrdersInsertBad() { SqlServerStorage storage = new SqlServerStorage(typeof(OrdersVerticalBar)); storage.ServerName = "NEON-64"; storage.DatabaseName = "Northwind"; storage.InsertSqlCallback = new InsertSqlHandler(GetInsertSqlOrder); OrdersVerticalBar[] res = (OrdersVerticalBar[]) CommonEngine.ReadFile(typeof(OrdersVerticalBar), Common.TestPath(@"Good\OrdersVerticalBar.txt")); OrdersVerticalBar[] res2 = new OrdersVerticalBar[1]; res2[0] = res[0]; //storage.ExecuteInBatchSize //res2[0].OrderDate = new DateTime(1750, 10, 10); try { storage.InsertRecords(res2); } catch(SqlException ex) { if (ex.Number == 208) Assert.Ignore("You dont have this tables in your SqlServer"); if (ex.Number == 6) Assert.Ignore("SqlServer not found, skipping this test."); Assert.Ignore(ex.ToString()); } }