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)); }
public void SetOperation_WithDifferentColumnLists() { CheckQuery( () => Cooks.Union(Chefs.Select(c => c)), "SELECT [t0].[ID],[t0].[FirstName],[t0].[Name],[t0].[IsStarredCook],[t0].[IsFullTimeCook],[t0].[SubstitutedID],[t0].[KitchenID]," + "[t0].[KnifeID],[t0].[KnifeClassID] " + "FROM [CookTable] AS [t0] " + "UNION (SELECT [t1].[ID],[t1].[FirstName],[t1].[Name],[t1].[IsStarredCook],[t1].[IsFullTimeCook],[t1].[SubstitutedID],[t1].[KitchenID]," + "[t1].[KnifeID],[t1].[KnifeClassID],[t1].[LetterOfRecommendation] " + "FROM [dbo].[ChefTable] AS [t1])"); }
private void LoadChefs() { using (var rd = new StreamReader("chefs.txt")) { int n = Convert.ToInt32(rd.ReadLine()); Chefs.Clear(); for (int i = 0; i < n; ++i) { Chefs.Add(new Chef(rd.ReadLine(), rd.ReadLine())); } } }
public void Is() { CheckQuery( Cooks.Where(c => c is 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)" ); CheckQuery( #pragma warning disable 183 Cooks.Where(c => c is Cook), #pragma warning restore 183 "SELECT [t0].[ID],[t0].[FirstName],[t0].[Name],[t0].[IsStarredCook],[t0].[IsFullTimeCook],[t0].[SubstitutedID],[t0].[KitchenID]," + "[t0].[KnifeID],[t0].[KnifeClassID] " + "FROM [CookTable] AS [t0] WHERE (@1 = 1)", new CommandParameter("@1", 1) ); CheckQuery( #pragma warning disable 183 Chefs.Where(c => c is Cook), #pragma warning restore 183 "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)", new CommandParameter("@1", 1)); CheckQuery( #pragma warning disable 183 Chefs.Where(c => c is Chef), #pragma warning restore 183 "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)", new CommandParameter("@1", 1)); }
public void SetOperation_WithDifferentTypes() { CheckQuery( () => Cooks.Where(c => c.FirstName == "Hugo").Select(c => c.ID).Union(Chefs.Where(c => c.Name == "Boss").Select(c => c.ID)), "SELECT [t0].[ID] AS [value] FROM [CookTable] AS [t0] WHERE ([t0].[FirstName] = @1) " + "UNION (SELECT [t1].[ID] AS [value] FROM [dbo].[ChefTable] AS [t1] WHERE ([t1].[Name] = @2))", row => (object)row.GetValue <int> (new ColumnID("value", 0)), new CommandParameter("@1", "Hugo"), new CommandParameter("@2", "Boss")); CheckQuery( () => Cooks.Where(c => c.FirstName == "Hugo").Select(c => c.ID).Union(Kitchens.Where(c => c.Name == "Nino's Kitchen").Select(c => c.ID)), "SELECT [t0].[ID] AS [value] FROM [CookTable] AS [t0] WHERE ([t0].[FirstName] = @1) " + "UNION (SELECT [t1].[ID] AS [value] FROM [KitchenTable] AS [t1] WHERE ([t1].[Name] = @2))", row => (object)row.GetValue <int> (new ColumnID("value", 0)), new CommandParameter("@1", "Hugo"), new CommandParameter("@2", "Nino's Kitchen")); }
public IActionResult Creating(Chefs NewChef) { db.Chefs.Add(NewChef); db.SaveChanges(); return(RedirectToAction("ChefsHome")); }