protected override void Seed(VocabularyModel _ctx)
{
string path = Path.GetTempPath();
#region
CredentialExtn cred1 = new CredentialExtn
{
Email = "*****@*****.**",
Password = "******"
};
_ctx.Credentials.Add(cred1);
DictionaryExtn dict1 = new DictionaryExtn
{
Name = "Animal",
Credential = cred1
};
_ctx.Dictionaries.Add(dict1);
Word[] words = new Word[]
{
new Word
{
WordEng = "cat",
Transcription = "|kæt|",
Translation = "кіт",
Dictionary = dict1,
Image = File.ReadAllBytes($@"{path}\Image\cat.jpg"),
Sound = File.ReadAllBytes($@"{path}\Sound\cat.mp3"),
IsWordLearned = false
},
new Word
{
WordEng = "dog",
Transcription = "|dɔːɡ|",
Translation = "пес",
Dictionary = dict1,
Image = File.ReadAllBytes($@"{path}\Image\dog.jpg"),
Sound = File.ReadAllBytes($@"{path}\Sound\dog.mp3"),
IsWordLearned = false
},
new Word
{
WordEng = "bear",
Transcription = "|ber|",
Translation = "ведмідь",
Dictionary = dict1,
Image = File.ReadAllBytes($@"{path}\Image\bear.jpeg"),
Sound = File.ReadAllBytes($@"{path}\Sound\bear.mp3"),
IsWordLearned = false
},
new Word
{
WordEng = "penguin",
Transcription = "|ˈpeŋɡwɪn|",
Translation = "пінгвін",
Dictionary = dict1,
Image = File.ReadAllBytes($@"{path}\Image\penguin.png"),
Sound = File.ReadAllBytes($@"{path}\Sound\penguin.mp3"),
IsWordLearned = false
},
new Word
{
WordEng = "parrot",
Transcription = "|ˈpærət|",
Translation = "папуга",
Dictionary = dict1,
Image = File.ReadAllBytes($@"{path}\Image\parrot.png"),
Sound = File.ReadAllBytes($@"{path}\Sound\parrot.mp3"),
IsWordLearned = false
},
new Word
{
WordEng = "donkey",
Transcription = "|ˈdɔːŋki|",
Translation = "осел",
Dictionary = dict1,
Image = File.ReadAllBytes($@"{path}\Image\donkey.jpg"),
Sound = File.ReadAllBytes($@"{path}\Sound\donkey.mp3"),
IsWordLearned = false
},
new Word
{
WordEng = "rat",
Transcription = "|ræt|",
Translation = "пацюк",
Dictionary = dict1,
Image = File.ReadAllBytes($@"{path}\Image\rat.png"),
Sound = File.ReadAllBytes($@"{path}\Sound\rat.mp3"),
IsWordLearned = false
},
new Word
{
WordEng = "mosquito",
Transcription = "|məˈskiːtoʊ|",
Translation = "комар",
Dictionary = dict1,
Image = File.ReadAllBytes($@"{path}\Image\mosquito.jpg"),
Sound = File.ReadAllBytes($@"{path}\Sound\mosquito.mp3"),
IsWordLearned = false
},
new Word
{
WordEng = "fox",
Transcription = "|fɑːks|",
Translation = "лисиця",
Dictionary = dict1,
Image = File.ReadAllBytes($@"{path}\Image\fox.png"),
Sound = File.ReadAllBytes($@"{path}\Sound\fox.mp3"),
IsWordLearned = false
},
new Word
{
WordEng = "ratel",
Transcription = "|ˈreɪt(ə)l|",
Translation = "медоїд",
Dictionary = dict1,
Image = File.ReadAllBytes($@"{path}\Image\ratel.jpg"),
Sound = File.ReadAllBytes($@"{path}\Sound\ratel.mp3"),
IsWordLearned = false
}
};
var serializer = new DataContractSerializer(typeof(Word[]),
null,
0x7FFF,
false,
true,
null);
using (FileStream fs = new FileStream($@"{path}\words.xml", FileMode.OpenOrCreate))
{
serializer.WriteObject(fs, words);
}
#endregion
//Word[] words = null;
//var serializer = new DataContractSerializer(typeof(Word[]), null,
// 0x7FFF,
// false,
// true,
// null);
//using (FileStream fs = new FileStream($@"{path}\words.xml", FileMode.OpenOrCreate))
//{
// XmlDictionaryReader reader = XmlDictionaryReader.CreateTextReader(fs, new XmlDictionaryReaderQuotas()
// {
// MaxArrayLength = 2147483647
// });
// words = (Word[])serializer.ReadObject(reader);
// reader.Close();
//}
_ctx.Words.AddRange(words);
_ctx.SaveChanges();
}
public void Add(Word word)
{
db.CreateTable <Word>();
db.Insert(word);
}