public void BuildInsertTest() { var ed = new EntityDescription(typeof(POCOMultiTypeObject)); var provider = new SQLite.SQLiteProviderFactory(); var data = new POCOMultiTypeObject(); var commandBuilder = ed.CommandBuilder; using (var command = commandBuilder.BuildInsertCommand(provider, data, null, Core.SQL.OnConflictOption.Default)) { _output.WriteLine(command.CommandText); Assert.NotNull(command); AssertEx.NotNullOrWhitespace(command.CommandText); Assert.DoesNotContain("ID", command.CommandText); VerifyCommandSyntex(provider, command); } using (var command = commandBuilder.BuildInsertCommand(provider, data, 1, Core.SQL.OnConflictOption.Default)) { _output.WriteLine(command.CommandText); Assert.NotNull(command); AssertEx.NotNullOrWhitespace(command.CommandText); Assert.Contains("ID", command.CommandText); VerifyCommandSyntex(provider, command); } }
public static POCOMultiTypeObject CreateWithNullID(bool nullableSetNull = false) { var poco = new POCOMultiTypeObject() { BoolField = _randomizer.Bool(), DateTimeField = DateTime.Now, NDateTimeField = (nullableSetNull) ? (DateTime?)null : DateTime.Now, StrDateTime = (nullableSetNull) ? (string)null : DateTime.Now.ToShortTimeString(), DoubleField = _randomizer.Double(), FloatField = _randomizer.Float(), GuidField = _randomizer.Guid(), NGuidField = (nullableSetNull) ? (Guid?)null : _randomizer.Guid(), IntField = _randomizer.Int(), LongField = _randomizer.Long(), NBoolField = (nullableSetNull) ? (bool?)null : _randomizer.Bool(), NDoubleField = (nullableSetNull) ? (double?)null : _randomizer.Double(), NFloatField = (nullableSetNull) ? (float?)null : _randomizer.Float(), NIntField = (nullableSetNull) ? (int?)null : _randomizer.Int(), NLongField = (nullableSetNull) ? (long?)null : _randomizer.Long(), //RowID = randomizer.Int(), StringField = _randomizer.String2(16), }; return(poco); }
public void ReadPrimaryKeyTest() { var poco = new POCOMultiTypeObject() { ID = 1 }; var reader = new TestSupport.ObjectDataReader<POCOMultiTypeObject>(new POCOMultiTypeObject[] { poco }); Assert.True(reader.Read()); var ed = new EntityDescription(typeof(POCOMultiTypeObject)); ed.Inflator.CheckOrdinals(reader); var id = ed.Inflator.ReadPrimaryKey(reader); Assert.Equal(id, 1); }
public void BuildDeleteTest() { var ed = new EntityDescription(typeof(POCOMultiTypeObject)); var provider = new SQLite.SQLiteProviderFactory(); var data = new POCOMultiTypeObject(); var commandBuilder = ed.CommandBuilder; using (var command = commandBuilder.BuildSQLDeleteCommand(provider, data)) { _output.WriteLine(command.CommandText); Assert.NotNull(command); AssertEx.NotNullOrWhitespace(command.CommandText); VerifyCommandSyntex(provider, command); } }
public void ReadDataTest() { var poco = new POCOMultiTypeObject() { ID = 1, StringField = "1", IntField = 1 }; var reader = new TestSupport.ObjectDataReader<POCOMultiTypeObject>(new POCOMultiTypeObject[] { poco }); Assert.True(reader.Read()); var ed = new EntityDescription(typeof(POCOMultiTypeObject)); var data = new POCOMultiTypeObject(); ed.Inflator.CheckOrdinals(reader); ed.Inflator.ReadData(reader, data); Assert.Equal(data.StringField, "1"); Assert.Equal(data.ID, 1); }