C# (CSharp) System.Data.IDbCommand.Select Examples

Example #1

        private void Can_insert_and_select_from_ModelWithFieldsOfDifferentAndNullableTypes_table_impl(System.Data.IDbCommand dbConn)
        {
            {
                dbConn.CreateTable <ModelWithFieldsOfDifferentAndNullableTypes>(true);

                var row = ModelWithFieldsOfDifferentAndNullableTypes.Create(1);

                Console.WriteLine(OrmLiteConfig.DialectProvider.ToInsertRowStatement(row, null));
                dbConn.Insert(row);

                var rows = dbConn.Select <ModelWithFieldsOfDifferentAndNullableTypes>();

                Assert.That(rows, Has.Count.EqualTo(1));

                ModelWithFieldsOfDifferentAndNullableTypes.AssertIsEqual(rows[0], row);
            }
        }