var beers = new Beer[]
{
new Beer {
Name = "Stiegl Radler",
Brewery = “Stieglbrauerei zu Salzburg”,
StyleId = 1,
ABVId = 1,
AvailId = 1,
ImgUrl = “”,
},
new Beer {
Name = "Schöfferhofer Grapefruit Weizen-Mix",
Brewery = “Binding Brauerei”,
StyleId = 1,
ABVId = 1,
AvailId = 1,
ImgUrl = “”,
},
new Beer {
Name = "Divergent",
Brewery = “Rivertown Brewing Co.”,
StyleId = 4,
ABVId = 1,
AvailId = 1,
ImgUrl = “”,
},
new Beer {
Name = "Mango Even Keel",
Brewery = “Ballast Point”,
StyleId = 3,
ABVId = 1,
AvailId = 1,
ImgUrl = “”,
},
new Beer {
Name = "Jibe Session IPA",
Brewery = “Green Flash”,
StyleId = 3,
ABVId = 1,
AvailId = 1,
ImgUrl = “”,
},
new Beer {
Name = "Nomader Weisse",
Brewery = “Evil Twin Brewing”,
StyleId = 4,
ABVId = 1,
AvailId = 3,
ImgUrl = “”,
},
new Beer {
Name = "Shindig Shandy",
Brewery = “Blackstone”,
StyleId = 1,
ABVId = 1,
AvailId = 3,
ImgUrl = “”,
},
new Beer {
Name = "Oarsman",
Brewery = “Bell’s”,
StyleId = 4,
ABVId = 1,
AvailId = 1,
ImgUrl = “”,
},
new Beer {
Name = "Suspicion",
Brewery = “Bearded Iris”,
StyleId = 2,
ABVId = 1,
AvailId = 1,
ImgUrl = “”,
},
new Beer {
Name = "Piety",
Brewery = “NOLA”,
StyleId = 4,
ABVId = 1,
AvailId = 2,
ImgUrl = “”,
},
new Beer {
Name = "London Pride",
Brewery = “Fuller, Smith & Turner”,
StyleId = 2,
ABVId = 2,
AvailId = 1,
ImgUrl = “”,
},
new Beer {
Name = "Anchor Porter",
Brewery = “Anchor Brewing Co.”,
StyleId = 5,
ABVId = 2,
AvailId = 1,
ImgUrl = “”,
},
new Beer {
Name = "312 Urban Wheat Ale",
Brewery = “Goose Island”,
StyleId = 2,
ABVId = 2,
AvailId = 1,
ImgUrl = “”,
},
new Beer {
Name = "Gotta Get Up To Get Down",
Brewery = “Wiseacre”,
StyleId = 5,
ABVId = 2,
AvailId = 1,
ImgUrl = “”,
},
new Beer {
Name = "Narragansett Summer Ale",
Brewery = “Narragansett”,
StyleId = 2,
ABVId = 2,
AvailId = 3,
ImgUrl = “”,
},
new Beer {
Name = "Cranberry Ginger Shandy",
Brewery = “Jacob Leinenkugel Brewing Co.”,
StyleId = 1,
ABVId = 2,
AvailId = 5,
ImgUrl = “”,
},
new Beer {
Name = "Raspberry Jam",
Brewery = “Tallgrass Brewing Co.”,
StyleId = 4,
ABVId = 2,
AvailId = 2,
ImgUrl = “”,
},
new Beer {
Name = "Cranberry Pumpkinfest",
Brewery = “Terrapin”,
StyleId = 2,
ABVId = 2,
AvailId = 4,
ImgUrl = “”,
},
new Beer {
Name = "Buffalo Sweat Oatmeal Cream Stout",
Brewery = “Tallgrass Brewing Co.”,
StyleId = 5,
ABVId = 2,
AvailId = 1,
ImgUrl = “”,
},
new Beer {
Name = "Grunion Pale Ale",
Brewery = “Ballast Point”,
StyleId = 3,
ABVId = 2,
AvailId = 1,
ImgUrl = “”,
},
new Beer {
Name = "Milk Stout Nitro",
Brewery = “Left Hand”,
StyleId = 5,
ABVId = 3,
AvailId = 1,
ImgUrl = “”,
},
new Beer {
Name = "Grand Cru",
Brewery = “Rodenbach”,
StyleId = 4,
ABVId = 3,
AvailId = 1,
ImgUrl = “”,
},
new Beer {
Name = "Bed of Nails Brown",
Brewery = “Hi-Wire”,
StyleId = 2,
ABVId = 3,
AvailId = 1,
ImgUrl = “”,
},
new Beer {
Name = "Porter",
Brewery = “Founders”,
StyleId = 5,
ABVId = 3,
AvailId = 1,
ImgUrl = “”,
},
new Beer {
Name = "Duchess de Bourgogne",
Brewery = “Brouwerij Verhaeghe”,
StyleId = 4,
ABVId = 3,
AvailId = 1,
ImgUrl = “”,
},
new Beer {
Name = "Two Hearted Ale",
Brewery = “Bell’s”,
StyleId = 3,
ABVId = 3,
AvailId = 1,
ImgUrl = “”,
},
new Beer {
Name = "60 Minute IPA",
Brewery = “Dogfish Head”,
StyleId = 3,
ABVId = 3,
AvailId = 1,
ImgUrl = “”,
},
new Beer {
Name = "Evil Octopus",
Brewery = “Mayday Brewing”,
StyleId = 2,
ABVId = 3,
AvailId = 1,
ImgUrl = “”,
},
new Beer {
Name = "Old Sour Cherry Porter",
Brewery = “Rivertown”,
StyleId = 4,
ABVId = 3,
AvailId = 3,
ImgUrl = “”,
},
new Beer {
Name = "Hipster Repellant IPA",
Brewery = “Falls City Brewing Co.”,
StyleId = 3,
ABVId = 3,
AvailId = 1,
ImgUrl = “”,
},
new Beer {
Name = "Kasteel Rouge",
Brewery = “Brouwerij Van Honsebrouck”,
StyleId = 1,
ABVId = 4,
AvailId = 1,
ImgUrl = “”,
},
new Beer {
Name = "Lolita",
Brewery = “Goose Island”,
StyleId = 4,
ABVId = 4,
AvailId = 5,
ImgUrl = “”,
},
new Beer {
Name = "Pumking",
Brewery = “Southern Tier”,
StyleId = 2,
ABVId = 4,
AvailId = 4,
ImgUrl = “”,
},
new Beer {
Name = "Sumatra Mountain Brown",
Brewery = “Founders Brewing Co.”,
StyleId = 2,
ABVId = 4,
AvailId = 3,
ImgUrl = “”,
},
new Beer {
Name = "reDANKulous",
Brewery = “Founders Brewing Co.”,
StyleId = 3,
ABVId = 4,
AvailId = 3,
ImgUrl = “”,
},
new Beer {
Name = "Curmudgeon Old Ale",
Brewery = “Falls City Brewing Co.”,
StyleId = 2,
ABVId = 4,
AvailId = 2,
ImgUrl = “”,
},
new Beer {
Name = "Imperial Stout",
Brewery = “Lagunitas”,
StyleId = 5,
ABVId = 4,
AvailId = 3,
ImgUrl = “”,
},
new Beer {
Name = "Petrus Aged Red",
Brewery = “De Brabandere”,
StyleId = 4,
ABVId = 4,
AvailId = 1,
ImgUrl = “”,
},
new Beer {
Name = "Wake-n-Bake Coffee Oatmeal Stout",
Brewery = “Terrapin Brewing Co.”,
StyleId = 5,
ABVId = 4,
AvailId = 5,
ImgUrl = “”,
},
new Beer {
Name = "Kentucky Old Fashioned Barrel Ale",
Brewery = “Alltech's Lexington Brewing and Distilling Co.”,
StyleId = 2,
ABVId = 4,
AvailId = 1,
ImgUrl = “”,
},
new Beer {
Name = "Backwoods Bastard",
Brewery = “Founders Brewing Co.”,
StyleId = 2,
ABVId = 5,
AvailId = 4,
ImgUrl = “”,
},
new Beer {
Name = "Wake Up Dead Nitro",
Brewery = “Left Hand”,
StyleId = 5,
ABVId = 5,
AvailId = 5,
ImgUrl = “”,
}, new Beer {
Name = "Dragon’s Milk",
Brewery = “New Holland Brewing Co.”,
StyleId = 5,
ABVId = 5,
AvailId = 1,
ImgUrl = “”,
}, new Beer {
Name = "Kentucky Breakfast Stout",
Brewery = “Founders Brewing Co.”,
StyleId = 5,
ABVId = 5,
AvailId = 2,
ImgUrl = “”,
}, new Beer {
Name = "Unobtanium",
Brewery = “Straight to Ale”,
StyleId = 2,
ABVId = 5,
AvailId = 5,
ImgUrl = “”,
}, new Beer {
Name = "Imperial Biscotti Break",
Brewery = “Evil Twin Brewing”,
StyleId = 5,
ABVId = 5,
AvailId = 1,
ImgUrl = “”,
}, new Beer {
Name = "Ten FIDY",
Brewery = “Oskar Blues”,
StyleId = 5,
ABVId = 5,
AvailId = 4,
ImgUrl = “”,
}, new Beer {
Name = "RuinTen Triple IPA",
Brewery = “Stone Brewing Co.”,
StyleId = 3,
ABVId = 5,
AvailId = 3,
ImgUrl = “”,
}, new Beer {
Name = "Christmas BOMB!",
Brewery = “Prairie Artisan Ales”,
StyleId = 5,
ABVId = 5,
AvailId = 5,
ImgUrl = “”,
}, new Beer {
Name = "Bourbon County Brand Stout",
Brewery = “Goose Island”,
StyleId = 5,
ABVId = 5,
AvailId = 4,
ImgUrl = “”,
},
};
foreach (Beer i in beers)
{
context.Beer.Add(i);
}
context.SaveChanges();
Need to seed the database with the following at the minimum:
50 beers
5 season types (Year-round, Spring, Summer, Fall, Winter)
5 styles (Fruit beers, Ales, IPAs, Sours, Stout/Porter)
5 feelings (Light, Normal, Bitter, Funky, Dark)
5 types of days (Easy, Normal, Not Great, Terrible, Nuclear Winter)
5 levels of ABV (Less than 4%, 4% to 6%, 6% to 8%, 10%, More than 10%)
And the beer seeding is below: