public void FindByPrimaryKey() { OrderBusinessContext businessContext = new OrderBusinessContext(UserId, CityId, connStr); Order o = new Order(); o.Title = CustomerA + "'s Order"; o.CustomerName = CustomerA; using (IEntityContext entityContext = businessContext.CreateEntityContext()) { entityContext.Add<Order>(o); Assert.IsTrue(o.OrderID > 0); } using (IEntityContext entityContext = businessContext.CreateEntityContext()) { Order order = entityContext.FindByPrimaryKey<Order>(o.OrderID); Assert.IsNotNull(order); } }
public void ExecuteNonQuery() { OrderBusinessContext businessContext = new OrderBusinessContext(UserId, CityId, connStr); Order o = new Order(); o.Title = CustomerA + "'s Order"; o.CustomerName = CustomerA; using (IEntityContext entityContext = businessContext.CreateEntityContext()) { entityContext.Add<Order>(o); Assert.IsTrue(o.OrderID > 0); } using (IEntityContext entityContext = businessContext.CreateEntityContext()) { entityContext.ExecuteNonQuery("delete from [" + entityContext.GetMappingToTable(typeof(Order)) + "] where OrderID = @p0", o.OrderID); Order order = entityContext.FindByPrimaryKey<Order>(o.OrderID); Assert.IsNull(order); Dictionary<string, object> parameters = new Dictionary<string, object>(); parameters["OrderID"] = o.OrderID; Assert.IsTrue(0 == entityContext.ExecuteNonQuery("delete from [" + entityContext.GetMappingToTable(typeof(Order)) + "] where OrderID = @OrderID", parameters)); } }
public void Update() { OrderBusinessContext businessContext = new OrderBusinessContext(UserId, CityId, connStr); Order o = new Order(); o.Title = CustomerA + "'s Order"; o.CustomerName = CustomerA; using (IEntityContext entityContext = businessContext.CreateEntityContext()) { entityContext.BeginTransaction(); try { entityContext.Add<Order>(o); Assert.IsTrue(o.OrderID > 0); o.CustomerName = CustomerB; entityContext.Update(o); entityContext.Commit(); } catch { entityContext.Rollback(); } } using (IEntityContext entityContext = businessContext.CreateEntityContext()) { Order order = entityContext.FindByPrimaryKey<Order>(o.OrderID); Assert.IsNotNull(order); Assert.AreEqual(order.CustomerName, CustomerB); } }
public void Update2() { OrderBusinessContext businessContext = new OrderBusinessContext(UserId, CityId, connStr); Order o = new Order(); o.Title = CustomerA + "'s Order"; o.CustomerName = CustomerA; using (IEntityContext entityContext = businessContext.CreateEntityContext()) { entityContext.Add<Order>(o); Assert.IsTrue(o.OrderID > 0); Order o2 = new Order(); o2.CustomerName = CustomerB; o2.OrderID = o.OrderID; o2.Title = o.Title; entityContext.Update(o2); } using (IEntityContext entityContext = businessContext.CreateEntityContext()) { Order order = entityContext.FindByPrimaryKey<Order>(o.OrderID); Assert.IsNotNull(order); Assert.AreEqual(order.CustomerName, CustomerB); } }
public void Transaction3() { OrderBusinessContext businessContext = new OrderBusinessContext(UserId, CityId, connStr); Order o2 = new Order(); o2.Title = CustomerA + "'s Order"; o2.CustomerName = CustomerA; using (IEntityContext entityContext = businessContext.CreateEntityContext()) { Order o1 = entityContext.FindByPrimaryKey<Order>(4); entityContext.Delete<Order>(o1); entityContext.BeginTransaction(); try { o1.CustomerName = "test delete"; entityContext.Update<Order>(o1); entityContext.Add<Order>(o2); entityContext.Commit(); } catch (Exception err) { entityContext.Rollback(); throw err; } Assert.IsTrue(o2.OrderID > 0); } }
public void Transaction() { OrderBusinessContext businessContext = new OrderBusinessContext(UserId, CityId, connStr); Order o1 = new Order(); o1.Title = CustomerA + "'s Order"; o1.CustomerName = CustomerA; Order o2 = new Order(); o2.Title = "Test"; o2.CustomerName = CustomerB; using (IEntityContext entityContext = businessContext.CreateEntityContext()) { o1 = entityContext.FindByPrimaryKey<Order>(88); entityContext.BeginTransaction(); try { //o1.CustomerName = "test11"; //entityContext.Update<Order>(o1); entityContext.Add<Order>(o2); entityContext.Commit(); } catch (Exception err) { entityContext.Rollback(); throw err; } } using (IEntityContext entityContext = businessContext.CreateEntityContext()) { Order order = entityContext.FindByPrimaryKey<Order>(o2.OrderID); } }
public void DataTabaleAdapterTest() { OrderBusinessContext businessContext = new OrderBusinessContext(UserId, CityId, connStr); Order o1 = new Order(); o1.Title = CustomerA + "'s Order"; o1.CustomerName = CustomerA; Order o2 = new Order(); o2.Title = CustomerA + "'s Order"; o2.CustomerName = CustomerA; using (IEntityContext entityContext = businessContext.CreateEntityContext()) { o1 = entityContext.FindByPrimaryKey<Order>(3); entityContext.BeginTransaction(); try { //entityContext.Add<Order>(o1); entityContext.Add<Order>(o2); DataTable table = null; XMS.Core.Data.DataTableAdapter adapter = entityContext.CreateDataTableAdapter(); table = new DataTable(entityContext.GetPartitionTableName("Order")); adapter.SetSelectCommand("select * from " + entityContext.GetPartitionTableName("Order")).Fill(table); for (int i = 0; i < table.Rows.Count; i++) { if (table.Rows[i]["OrderId"].ToString() != "3") { table.Rows[i]["Title"] = table.Rows[i]["Title"].ToString() + i.ToString(); } } adapter.BuildCommands().Update(table); if (table != null) { XMS.Core.Data.DataTableAdapter adapter2 = entityContext.CreateDataTableAdapter(); for (int i = 0; i < table.Rows.Count; i++) { if (table.Rows[i]["OrderId"].ToString() != "3") { table.Rows[i]["CustomerName"] = table.Rows[i]["CustomerName"].ToString() + i.ToString(); } //if ((int)table.Rows[i]["OrderId"] > 10) //{ // table.Rows[i].Delete(); //} } //adapter2.SetUpdateCommand("update " + entityContext.GetPartitionTableName("Order") + " set Title=@Title,CustomerName=@CustomerName,A=@A where OrderId=@OrderId", //"Title", "CustomerName", "OrderId", "TS", "A", "I" //); //adapter2.SetDeleteCommand("delete from " + entityContext.GetPartitionTableName("Order") + " where OrderId=@OrderId", "OrderId"); adapter2.SetUpdateCommand("update " + entityContext.GetPartitionTableName("Order") + " set Title=@Title,CustomerName=@CustomerName,A=@A where OrderId=@OrderId", new System.Data.Common.DbParameter[]{ adapter2.CreateParameter("Title", DbType.String, 100), adapter2.CreateParameter("@CustomerName", DbType.String, 200), adapter2.CreateParameter("@A", DbType.String, 1000), adapter2.CreateParameter("OrderId", DbType.Int32) }); adapter2.SetDeleteCommand("delete from " + entityContext.GetPartitionTableName("Order") + " where OrderId=@OrderId", new System.Data.Common.DbParameter[]{ adapter2.CreateParameter("OrderId", DbType.Int32) }); Dictionary<string, object> parameters = new Dictionary<string, object>(); parameters["Title"] = null; parameters["CustomerName"] = null; parameters["OrderId"] = null; parameters["TS"] = null; parameters["A"] = null; //adapter2.SetUpdateCommand("update " + entityContext.GetPartitionTableName("Order") + " set Title=@Title,CustomerName=@CustomerName where OrderId=@OrderId", // new System.Data.Common.DbParameter[]{ // XMS.Core.Data.DataTableAdapter.CreateParameter("@Title", SqlDbType.NVarChar, 32), // XMS.Core.Data.DataTableAdapter.CreateParameter("@CustomerName", SqlDbType.NVarChar, 64), // XMS.Core.Data.DataTableAdapter.CreateParameter("@OrderId", SqlDbType.Int), // XMS.Core.Data.DataTableAdapter.CreateParameter("@TS", SqlDbType.Binary) // } // ); //XMS.Core.Data.DataTableAdapter.AssignParameterValues(adapter2.UpdateCommand.Parameters, table.Rows[0]); adapter2.Update(table); } o1.CustomerName = "test"; entityContext.Update<Order>(o1); //o1.CustomerName = CustomerB; //entityContext.Update(o1); entityContext.Commit(); } catch (Exception err) { entityContext.Rollback(); throw err; } Order order = entityContext.FindByPrimaryKey<Order>(o1.OrderID); //Assert.IsNotNull(order); //Assert.AreEqual(order.CustomerName, CustomerB); } using (IEntityContext entityContext = businessContext.CreateEntityContext()) { Order order = entityContext.FindByPrimaryKey<Order>(o1.OrderID); Assert.IsNotNull(order); Assert.AreEqual(order.CustomerName, CustomerB); } }
public void Add() { bool exists = false; OrderBusinessContext businessContext = new OrderBusinessContext(UserId, CityId, connStr); using (IEntityContext entityContext = businessContext.CreateEntityContext()) { exists = entityContext.IsTableExists(typeof(Order)); exists = entityContext.IsDatabaseExists(); Order o = new Order(); o.Title = CustomerA + "'s Order"; o.CustomerName = CustomerA; entityContext.Add<Order>(o); List<OrderEx> orders = entityContext.ExecuteList<OrderEx>("select * from " + entityContext.GetMappingToTable(typeof(Order))); Assert.IsTrue(orders.Count > 0); Assert.IsTrue(o.OrderID > 0); } using (IEntityContext entityContext = businessContext.CreateEntityContext()) { GroupMessage message = new GroupMessage(); message.Title = "test"; message.Content = "testtest"; message.From = UserId; message.To = "all"; message.SendTime = DateTime.Now; message.ValidPeriodFrom = DateTime.Now; message.ValidPeriodTo = DateTime.Now.AddYears(1); message.IsDeleted = false; entityContext.Add<GroupMessage>(message); Assert.IsTrue(message.ID > 0); } }
public void ExecuteScalar() { OrderBusinessContext businessContext = new OrderBusinessContext(UserId, CityId, connStr); Order o = new Order(); o.Title = CustomerA + "'s Order"; o.CustomerName = CustomerA; using (IEntityContext entityContext = businessContext.CreateEntityContext()) { entityContext.Add<Order>(o); Assert.IsTrue(o.OrderID > 0); } using (IEntityContext entityContext = businessContext.CreateEntityContext()) { Dictionary<string, object> parameters = new Dictionary<string, object>(); parameters["CustomerName"] = "not exist customer"; int orderId = entityContext.ExecuteScalar<int>("select OrderId from [" + entityContext.GetMappingToTable(typeof(Order)) + "] where CustomerName=@CustomerName", parameters); Assert.IsTrue(orderId == 0); string customerName = entityContext.ExecuteScalar<string>("select CustomerName from [" + entityContext.GetMappingToTable(typeof(Order)) + "] where OrderID = @p0", o.OrderID); Assert.AreEqual(customerName, CustomerA); parameters.Clear(); parameters["OrderID"] = o.OrderID; Assert.AreEqual(entityContext.ExecuteScalar<string>("select CustomerName from [" + entityContext.GetMappingToTable(typeof(Order)) + "] where OrderID = @OrderID", parameters), CustomerA); } }