Exemple #1
0
        public async Task Save_MultipleRows()
        {
            var depts = new Departments(ProviderName);

            object[] toSave = new object[]
            {
                new { DNAME = "Massive Dep", LOC = "Beach" }.ToExpando(),
                new { DNAME = "Massive Dep", LOC = "DownTown" }.ToExpando()
            };
            var result = await depts.SaveAsync(toSave);

            Assert.AreEqual(2, result);
            foreach (dynamic o in toSave)
            {
                Assert.IsTrue(o.DEPTNO > 0);
            }

            // read them back, update them, save them again,
            var savedDeps = await(await depts.AllAsync(where : "WHERE DEPTNO=:0 OR DEPTNO=:1", args: new object[] { ((dynamic)toSave[0]).DEPTNO, ((dynamic)toSave[1]).DEPTNO })).ToListAsync();

            Assert.AreEqual(2, savedDeps.Count);
            savedDeps[0].LOC += "C";
            savedDeps[1].LOC += "C";
            result            = await depts.SaveAsync(toSave);

            Assert.AreEqual(2, result);
            Assert.AreEqual(1, await depts.DeleteAsync(savedDeps[0].DEPTNO));
            Assert.AreEqual(1, await depts.DeleteAsync(savedDeps[1].DEPTNO));
        }
Exemple #2
0
        public async Task Insert_SingleRow()
        {
            var depts    = new Departments(ProviderName);
            var inserted = await depts.InsertAsync(new { DNAME = "Massive Dep", LOC = "Beach" });

            Assert.IsTrue(inserted.DEPTNO > 0);
            Assert.AreEqual(1, await depts.DeleteAsync(inserted.DEPTNO));
        }
Exemple #3
0
        public async Task Save_SingleRow()
        {
            var     depts = new Departments(ProviderName);
            dynamic toSave = new { DNAME = "Massive Dep", LOC = "Beach" }.ToExpando();
            var     result = await depts.SaveAsync(toSave);

            Assert.AreEqual(1, result);
            Assert.IsTrue(toSave.DEPTNO > 0);
            Assert.AreEqual(1, await depts.DeleteAsync(toSave.DEPTNO));
        }
Exemple #4
0
        public async Task UpdateUsing_SingleRow()
        {
            var     depts = new Departments(ProviderName);
            dynamic toSave = new { DNAME = "Massive Dep", LOC = "Beach" }.ToExpando();
            var     saveResult = await depts.SaveAsync(toSave);

            Assert.AreEqual(1, saveResult);
            Assert.IsTrue(toSave.DEPTNO > 0);
            var mightyDep = new { DNAME = "Mighty Dep" };

            Assert.AreEqual(0, (await(await depts.AllAsync(mightyDep)).ToListAsync()).Count);
            Assert.AreEqual(1, await depts.UpdateUsingAsync(mightyDep, toSave.DEPTNO));
            Assert.AreEqual(1, (await(await depts.AllAsync(mightyDep)).ToListAsync()).Count);
            Assert.AreEqual(1, await depts.DeleteAsync(toSave.DEPTNO));
            Assert.AreEqual(0, (await(await depts.AllAsync(mightyDep)).ToListAsync()).Count);
        }
Exemple #5
0
        public async Task Insert_SingleRow(Boolean explicitConnection)
        {
            var          depts      = new Departments(ProviderName, explicitConnection);
            DbConnection connection = null;

            if (explicitConnection)
            {
                MightyTests.ConnectionStringUtils.CheckConnectionStringRequiredForOpenConnectionAsync(depts);
                connection = await depts.OpenConnectionAsync(MightyTests.ConnectionStringUtils.GetConnectionString(TestConstants.ReadWriteTestConnection, ProviderName));
            }
            using (connection)
            {
                var inserted = await depts.InsertAsync(new { DNAME = "Massive Dep", LOC = "Beach" }, connection : connection);

                Assert.IsTrue(inserted.DEPTNO > 0);
                Assert.AreEqual(1, await depts.DeleteAsync(connection, inserted.DEPTNO));
            }
        }
Exemple #6
0
 public async Task CleanUp()
 {
     // delete all rows with department name 'Massive Dep'.
     var depts = new Departments(ProviderName);
     await depts.DeleteAsync("DNAME=:0", "Massive Dep");
 }