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