static void TestExpression1()
{
EntitySchemaManager.LoadEntity <SceneObject>();
var view = EntitySchemaManager.GetSchema <SceneObject>(true);
var dbProvider = new Framework.Data.MsSql.MsSqlConnectionProvider(1, "");
var commandStruct = dbProvider.CreateCommand <SceneObject>(view.Name, DbCommandMode.Select);
var fields = new List <long>()
{
};
var guid = Guid.NewGuid();
commandStruct.Where(p => (p.ID == 0 || fields.Contains(p.ID)) && !p.Deleted);
commandStruct.OrderBy(p => p.Guid, true);
//commandStruct.Where(p => fields.Contains(p.ID) && !p.Deleted);
var commandText = commandStruct.CommandText;
}
static void TestExpression2()
{
EntitySchemaManager.LoadEntity <SceneObject>();
var view = EntitySchemaManager.GetSchema <SceneObject>(true);
var dbProvider = new Framework.Data.MsSql.MsSqlConnectionProvider(1, "");
var commandStruct = dbProvider.CreateCommand <SceneObject>(view.Name, DbCommandMode.Select);
commandStruct.Columns.Add(SqlExpression.As(SqlExpression.Function("count", SqlExpression.Symbol("*")), "Count"));
var fields = new List <long>()
{
4, 3
};
commandStruct.Where(p => (p.Function == null || fields.Contains(p.ID)) && !p.Deleted);
commandStruct.OrderBy(p => p.ID);
var commandText = commandStruct.CommandText;
}
static void TestExpression3()
{
var sb = new System.Data.SqlClient.SqlConnectionStringBuilder();
sb.DataSource = "115.159.55.137,1999";
sb.UserID = "chenguangxu";
sb.Password = "******";
sb.InitialCatalog = "BlingAccount";
EntitySchemaManager.LoadEntity <SceneObject>();
var view = EntitySchemaManager.GetSchema <SceneObject>(true);
var dbProvider = new Framework.Data.MsSql.MsSqlConnectionProvider(1, sb.ConnectionString);
var commandStruct = dbProvider.CreateCommand <SceneObject>(view.Name, DbCommandMode.Select);
var keys = new List <long>()
{
1, 5, 7, 9
};
commandStruct.Where(p => p.Name != null && keys.Contains(p.ID));
commandStruct.OrderBy(p => p.ID);
var a = dbProvider.Select(commandStruct);
}
