public void InsertOrUpdate(Word entity)
{
if (entity.WordId.Equals(0))
{
// New entity
_context.Words.Add(entity);
}
else
{
// Existing entity
_context.Entry(entity).State = System.Data.Entity.EntityState.Modified;
}
_context.SaveChanges();
}
public static void InitializeIdentityForEF(SpellCheckerContext context)
{
CreateUsersAndRoles(context);
//SpellingBeeTest 1
var spellingBeeTest = new SpellingBeeTest()
{
Name = "First IESH Spelling Bee 4th grade 2016",
Tags = new List <SearchTag> {
new SearchTag {
Text = "weekdays"
}, new SearchTag {
Text = "months"
}
},
Words = new List <SpellChecker.Dal.DomainObjects.Word> {
#region start words
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "cheese", SwedishText = "ost"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "cauliflower", SwedishText = "blomkål"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "mushrooms", SwedishText = "champinjon"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "meat", SwedishText = "kött"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "cucumber", SwedishText = "gurka"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "garlic", SwedishText = "vitlök"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "pineapple", SwedishText = "ananas"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "peas", SwedishText = "ärtor"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "cabbage", SwedishText = "kål"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "potatoes", SwedishText = "potatis"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "grapes", SwedishText = "vindruvor"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "beans", SwedishText = "bönor"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "orange", SwedishText = "apelsin"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "chicken", SwedishText = "kyckling"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "peach", SwedishText = "persika"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "bread", SwedishText = "bröd"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "fish", SwedishText = "fisk"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "eggs", SwedishText = "ägg"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "pumpkin", SwedishText = "pumpa"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "butter", SwedishText = "smör"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "fresh", SwedishText = "färsk"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "raw", SwedishText = "rå"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "ripe", SwedishText = "mogen"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "rotten", SwedishText = "rutten"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "creamy", SwedishText = "krämig"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "crunchy", SwedishText = "knaprig"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "salty", SwedishText = "salt"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "savoury", SwedishText = "välsmakande"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "sour", SwedishText = "sur"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "spicy", SwedishText = "kryddad"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "sweet", SwedishText = "söt"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "monday", SwedishText = "måndag"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "tuesday", SwedishText = "tisdag"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "wednesday", SwedishText = "onsdag"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "thursday", SwedishText = "torsdag"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "friday", SwedishText = "fredag"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "saturday", SwedishText = "lördag"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "sunday", SwedishText = "söndag"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "be", SwedishText = "vara"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "have", SwedishText = "ha"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "do", SwedishText = "göra"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "say", SwedishText = "säga"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "go", SwedishText = "gå"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "get", SwedishText = "få"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "make", SwedishText = "gör"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "know", SwedishText = "veta"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "think", SwedishText = "tror"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "take", SwedishText = "ta"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "see", SwedishText = "se"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "come", SwedishText = "komma"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "want", SwedishText = "vill"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "use", SwedishText = "använda"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "find", SwedishText = "hitta"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "give", SwedishText = "ge"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "tell", SwedishText = "berätta"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "work", SwedishText = "arbete"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "call", SwedishText = "ringa upp"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "try", SwedishText = "försöka"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "ask", SwedishText = "fråga"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "need", SwedishText = "behöva"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "feel", SwedishText = "känna"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "become", SwedishText = "bli"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "leave", SwedishText = "lämna"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "mean", SwedishText = "betyda"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "keep", SwedishText = "behålla"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "let", SwedishText = "låta"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "begin", SwedishText = "börja"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "seem", SwedishText = "verka"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "help", SwedishText = "hjälp"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "show", SwedishText = "visa"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "hear", SwedishText = "höra"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "play", SwedishText = "spela"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "run", SwedishText = "springa"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "move", SwedishText = "flytta"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "live", SwedishText = "bo"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "believe", SwedishText = "tro"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "bring", SwedishText = "hämta"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "happen", SwedishText = "hända"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "write", SwedishText = "skriva"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "sit", SwedishText = "sitta"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "stand", SwedishText = "stå"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "lose", SwedishText = "förlora"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "pay", SwedishText = "betala"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "meet", SwedishText = "träffa"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "include", SwedishText = "innehålla"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "continue", SwedishText = "fortsätta"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "set", SwedishText = "ställa"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "learn", SwedishText = "lära"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "january", SwedishText = "januari"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "february", SwedishText = "februari"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "march", SwedishText = "mars"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "april", SwedishText = "april"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "may", SwedishText = "maj"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "june", SwedishText = "juni"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "july", SwedishText = "juli"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "august", SwedishText = "augusti"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "september", SwedishText = "september"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "october", SwedishText = "oktober"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "november", SwedishText = "november"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "december", SwedishText = "december"
},
#endregion
}
};
context.SpellingBeeTests.AddOrUpdate(s => s.Name, spellingBeeTest);
context.SaveChanges();
//SpellingBeeTest Weekdays
var spellingBeeTestWeekDays = new SpellingBeeTest()
{
Name = "Weekdays",
Tags = new List <SearchTag> {
new SearchTag {
Text = "weekdays"
}
},
Words = new List <SpellChecker.Dal.DomainObjects.Word>
{
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "monday", SwedishText = "måndag"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "tuesday", SwedishText = "tisdag"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "wednesday", SwedishText = "onsdag"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "thursday", SwedishText = "torsdag"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "friday", SwedishText = "fredag"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "saturday", SwedishText = "lördag"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "sunday", SwedishText = "söndag"
}
}
};
context.SpellingBeeTests.AddOrUpdate(s => s.Name, spellingBeeTestWeekDays);
context.SaveChanges();
//SpellingBeeTest Months
var spellingBeeTestMonths = new SpellingBeeTest()
{
Name = "Months",
Tags = new List <SearchTag> {
new SearchTag {
Text = "months"
}
},
Words = new List <SpellChecker.Dal.DomainObjects.Word>
{
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "january", SwedishText = "januari"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "february", SwedishText = "februari"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "march", SwedishText = "mars"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "april", SwedishText = "april"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "may", SwedishText = "maj"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "june", SwedishText = "juni"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "july", SwedishText = "juli"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "august", SwedishText = "augusti"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "september", SwedishText = "september"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "october", SwedishText = "oktober"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "november", SwedishText = "november"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "december", SwedishText = "december"
}
}
};
context.SpellingBeeTests.AddOrUpdate(s => s.Name, spellingBeeTestMonths);
context.SaveChanges();
//SpellingBeeTest Months
var spellingBeeTestWeeklyWordsWeek6 = new SpellingBeeTest()
{
Name = "Veckans ord v6 2016",
Tags = new List <SearchTag> {
new SearchTag {
Text = "week6"
}
},
Words = new List <SpellChecker.Dal.DomainObjects.Word>
{
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "glömde", SwedishText = "glömde"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "rymde", SwedishText = "rymde"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "tömt", SwedishText = "tömt"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "skrämt", SwedishText = "skrämt"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "svamla", SwedishText = "svamla"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "fastklämt", SwedishText = "fastklämt"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "husnumret", SwedishText = "husnumret"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "välkomna", SwedishText = "välkomna"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "hamrar", SwedishText = "hamrar"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "slumrar", SwedishText = "slumrar"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "bestämt", SwedishText = "bestämt"
},
new SpellChecker.Dal.DomainObjects.Word {
EnglishText = "berömd", SwedishText = "berömd"
},
}
};
context.SpellingBeeTests.AddOrUpdate(s => s.Name, spellingBeeTestWeeklyWordsWeek6);
context.SaveChanges();
}