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