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 ExecuteList_Paged() { OrderBusinessContext businessContext = new OrderBusinessContext(UserId, CityId, connStr); using (IEntityContext entityContext = businessContext.CreateEntityContext()) { List<Order> orders = entityContext.ExecuteList<Order>("OrderID,Title,CustomerName,TS", "CustomerName=@p0 or CustomerName=@p1", "CustomerName desc", 2, 5, new object[] { CustomerA, CustomerB }); Assert.IsTrue(orders.Count >= 0 && orders.Count <= 5); Dictionary<string, object> parameters = new Dictionary<string, object>(); parameters["CustomerName1"] = CustomerA; parameters["CustomerName2"] = CustomerB; orders = entityContext.ExecutePagedList<Order>("OrderID,Title,CustomerName,TS", "CustomerName=@CustomerName1 or CustomerName=@CustomerName2", "CustomerName desc", 2, 5, parameters); Assert.IsTrue(orders.Count >= 0 && orders.Count <= 5); } }
public void QueryableDataSource() { OrderBusinessContext businessContext = new OrderBusinessContext(UserId, CityId, connStr); using (IEntityContext entityContext = businessContext.CreateEntityContext()) { IQueryable<Order> queryable = entityContext.GetQueryableDataSource<Order>(); List<Order> orders1 = queryable .OrderByDescending(order => order.CustomerName) .ThenBy(order => order.OrderID) .Where(order => order.CustomerName == CustomerA || order.CustomerName == CustomerB ) .Skip(10).Take(5).ToList(); Assert.IsTrue(orders1.Count >= 0 && orders1.Count <= 5); List<Order> orders2 = (from order in queryable where order.CustomerName == CustomerA || order.Title == CustomerB orderby order.CustomerName descending, order.OrderID ascending select order ) .Skip(10).Take(5).ToList(); Assert.IsTrue(orders2.Count >= 0 && orders2.Count <= 5); } }
public void FindByProperty() { OrderBusinessContext businessContext = new OrderBusinessContext(UserId, CityId, connStr); using (IEntityContext entityContext = businessContext.CreateEntityContext()) { List<Order> orders = entityContext.FindByProperty<Order>("CustomerName", CustomerA); Assert.IsTrue(orders.Count > 0); } }
public void FindByAny() { OrderBusinessContext businessContext = new OrderBusinessContext(UserId, CityId, connStr); List<KeyValuePair<string, object>> propertyValues = new List<KeyValuePair<string, object>>(); propertyValues.Add(new KeyValuePair<string, object>("CustomerName", CustomerA)); propertyValues.Add(new KeyValuePair<string, object>("CustomerName", CustomerB)); using (IEntityContext entityContext = businessContext.CreateEntityContext()) { List<Order> orders = entityContext.FindByAny<Order>(propertyValues); Assert.IsTrue(orders.Count >= 0); } }
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 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 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 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 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 ExecuteList() { OrderBusinessContext businessContext = new OrderBusinessContext(UserId, CityId, connStr); using (IEntityContext entityContext = businessContext.CreateEntityContext()) { List<int> list = entityContext.ExecuteList<int>("select OrderID from [" + entityContext.GetMappingToTable(typeof(Order)) + "] where CustomerName = @p0", CustomerA); Assert.IsTrue(list.Count >= 0); Dictionary<string, object> parameters = new Dictionary<string, object>(); parameters["CustomerName"] = CustomerA; list = entityContext.ExecuteList<int>("select OrderID from [" + entityContext.GetMappingToTable(typeof(Order)) + "] where CustomerName = @CustomerName", parameters); Assert.IsTrue(list.Count >= 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); } }