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