Ejemplo n.º 1
0
        public void OfType()
        {
            CheckQuery(
                Cooks.OfType <Chef> (),
                "SELECT [t0].[ID],[t0].[FirstName],[t0].[Name],[t0].[IsStarredCook],[t0].[IsFullTimeCook],[t0].[SubstitutedID],[t0].[KitchenID],"
                + "[t0].[KnifeID],[t0].[KnifeClassID] "
                + "FROM [CookTable] AS [t0] WHERE ([t0].[IsStarredCook] = 1)",
                row => (object)(Chef)row.GetEntity <Cook> (
                    new ColumnID("ID", 0),
                    new ColumnID("FirstName", 1),
                    new ColumnID("Name", 2),
                    new ColumnID("IsStarredCook", 3),
                    new ColumnID("IsFullTimeCook", 4),
                    new ColumnID("SubstitutedID", 5),
                    new ColumnID("KitchenID", 6),
                    new ColumnID("KnifeID", 7),
                    new ColumnID("KnifeClassID", 8))
                );

            CheckQuery(
                Chefs.OfType <Chef>(),
                "SELECT [t0].[ID],[t0].[FirstName],[t0].[Name],[t0].[IsStarredCook],[t0].[IsFullTimeCook],[t0].[SubstitutedID]," +
                "[t0].[KitchenID],[t0].[KnifeID],[t0].[KnifeClassID],[t0].[LetterOfRecommendation] FROM [dbo].[ChefTable] AS [t0] WHERE (@1 = 1)",
// ReSharper disable RedundantCast
                row => (object)(Chef)row.GetEntity <Chef> (
// ReSharper restore RedundantCast
                    new ColumnID("ID", 0),
                    new ColumnID("FirstName", 1),
                    new ColumnID("Name", 2),
                    new ColumnID("IsStarredCook", 3),
                    new ColumnID("IsFullTimeCook", 4),
                    new ColumnID("SubstitutedID", 5),
                    new ColumnID("KitchenID", 6),
                    new ColumnID("KnifeID", 7),
                    new ColumnID("KnifeClassID", 8),
                    new ColumnID("LetterOfRecommendation", 9)),
                new CommandParameter("@1", 1));

            CheckQuery(
                Chefs.OfType <Cook> (),
                "SELECT [t0].[ID],[t0].[FirstName],[t0].[Name],[t0].[IsStarredCook],[t0].[IsFullTimeCook],[t0].[SubstitutedID]," +
                "[t0].[KitchenID],[t0].[KnifeID],[t0].[KnifeClassID],[t0].[LetterOfRecommendation] FROM [dbo].[ChefTable] AS [t0] WHERE (@1 = 1)",
                row => (object)(Cook)row.GetEntity <Chef> (
                    new ColumnID("ID", 0),
                    new ColumnID("FirstName", 1),
                    new ColumnID("Name", 2),
                    new ColumnID("IsStarredCook", 3),
                    new ColumnID("IsFullTimeCook", 4),
                    new ColumnID("SubstitutedID", 5),
                    new ColumnID("KitchenID", 6),
                    new ColumnID("KnifeID", 7),
                    new ColumnID("KnifeClassID", 8),
                    new ColumnID("LetterOfRecommendation", 9)),
                new CommandParameter("@1", 1));
        }