public void MuseReturnNameWhenUsingWrongHebrewName()
        {
            SQLiteConnector con = new SQLiteConnector();

            using (var context = con.GetContext())
            {
                var r2 = con.GetRecord("ניסים");
                Assert.IsNull(r2.Result);
            }
        }
        public void MuseReturnNameWhenUsingWrongId()
        {
            SQLiteConnector con = new SQLiteConnector();

            using (var context = con.GetContext())
            {
                var r3 = con.GetRecord(4);
                Assert.IsNull(r3);
            }
        }
        public void MuseReturnNameWhenUsingHebrewName()
        {
            SQLiteConnector con = new SQLiteConnector();

            using (var context = con.GetContext())
            {
                var r1 = con.GetRecord(1);
                Assert.IsNotNull(r1);
                Assert.AreEqual(r1.Hebrew, "משה");
                Assert.AreEqual(r1.English, "Moshe");
            }
        }
        public void MuseReturnNameWhenUsingId()
        {
            SQLiteConnector con = new SQLiteConnector();

            using (var context = con.GetContext())
            {
                var r1 = con.GetRecord(1);
                Assert.IsNotNull(r1);
                File.WriteAllText(@"c:\log\output.txt", r1.English);

                Assert.AreEqual(r1.Hebrew, "משה");
                Assert.AreEqual(r1.English, "Moshe");
            }
        }
        public void DbContextMustNotBeNull()
        {
            SQLiteConnector con = new SQLiteConnector();

            using (var context = con.GetContext())
            {
                Assert.IsNotNull(context);

                var r2 = con.GetRecord("דוד");
                Assert.IsNotNull(r2);
                Assert.AreEqual(r2.Result.Hebrew, "דוד");
                Assert.AreEqual(r2.Result.English, "David");
            }
        }