public async Task Can_read_from_inner_join_with_schema()
        {
            if ((Dialect & Dialect.AnyMySql) == Dialect) //ERROR table name too long
            {
                return;
            }

            db.DropAndCreateTable <ModelWithSchemaAndRowVersionForInnerJoin>();
            var rowVersionModel = new ModelWithRowVersion {
                Text = "test"
            };
            var modelId = await db.InsertAsync(rowVersionModel, selectIdentity : true).ConfigureAwait(false);

            var innerJoinTable = new ModelWithSchemaAndRowVersionForInnerJoin {
                ModelWithRowVersionId = modelId,
                Text = "inner join table"
            };
            var joinId = await db.InsertAsync(innerJoinTable, selectIdentity : true).ConfigureAwait(false);

            var query = db
                        .From <ModelWithRowVersion, ModelWithSchemaAndRowVersionForInnerJoin>((x, y) => x.Id == y.ModelWithRowVersionId)
                        .Where <ModelWithSchemaAndRowVersionForInnerJoin>(model => model.Id == joinId);

            var result = await db.SingleAsync(query).ConfigureAwait(false);

            Assert.NotNull(result);
        }
Beispiel #2
0
        public void Can_Save_new_row_and_retrieve_rowversion()
        {
            var row = new ModelWithRowVersion {
                Text = "First"
            };

            bool wasInserted = db.Save(row);

            Assert.That(wasInserted, Is.True);
            var actualRow = db.SingleById <ModelWithRowVersion>(row.Id);

            Assert.That(row.RowVersion, Is.EqualTo(actualRow.RowVersion));
        }
        public async Task Can_Save_new_row_and_retrieve_rowversion_Async()
        {
            var row = new ModelWithRowVersion {
                Text = "First"
            };

            bool wasInserted = await db.SaveAsync(row);

            Assert.That(wasInserted, Is.True);
            var actualRow = await db.SingleByIdAsync <ModelWithRowVersion>(row.Id);

            Assert.That(row.RowVersion, Is.EqualTo(actualRow.RowVersion));
        }
        public void Can_Save_new_row_and_retrieve_rowversion()
        {
            var row = new ModelWithRowVersion { Text = "First" };

            bool wasInserted = db.Save(row);

            Assert.That(wasInserted, Is.True);
            var actualRow = db.SingleById<ModelWithRowVersion>(row.Id);
            Assert.That(row.RowVersion, Is.EqualTo(actualRow.RowVersion));
        }