Ejemplos de SQLite.Net2.Tests TestDb.InsertOrReplace en C# (CSharp)

Ejemplo n.º 1

        public void InsertOrReplace()
        {
            _db.TraceListener = DebugTraceListener.Instance;
            _db.InsertAll(from i in Enumerable.Range(1, 20)
                          select new TestObj
            {
                Text = "#" + i
            });

            Assert.AreEqual(20, _db.Table <TestObj>().Count());

            var t = new TestObj
            {
                Id   = 5,
                Text = "Foo",
            };

            _db.InsertOrReplace(t);

            List <TestObj> r = (from x in _db.Table <TestObj>() orderby x.Id select x).ToList();

            Assert.AreEqual(20, r.Count);
            Assert.AreEqual("Foo", r[4].Text);
        }