public void TestMdsSqLiteConvertFieldResolverForByte() { // Setup var setting = DbSettingMapper.Get <SqliteConnection>(); var resolver = new SqLiteConvertFieldResolver(); var field = new Field("Field", typeof(byte)); // Act var result = resolver.Resolve(field, setting); // Assert Assert.AreEqual("CAST([Field] AS [BLOB])", result); }
public void TestSqLiteConvertFieldResolverForDateTime() { // Setup var setting = DbSettingMapper.Get <SQLiteConnection>(); var resolver = new SqLiteConvertFieldResolver(); var field = new Field("Field", typeof(DateTime)); // Act var result = resolver.Resolve(field, setting); // Assert Assert.AreEqual("CAST([Field] AS [DATETIME])", result); }
public void TestSdsSqLiteConvertFieldResolverForString() { // Setup var setting = DbSettingMapper.Get <SQLiteConnection>(); var resolver = new SqLiteConvertFieldResolver(); var field = new Field("Field", typeof(string)); // Act var result = resolver.Resolve(field, setting); // Assert Assert.AreEqual("CAST([Field] AS [TEXT])", result); }
public void TestSqLiteConvertFieldResolverForDecimal() { // Setup var setting = DbSettingMapper.Get <SqliteConnection>(); var resolver = new SqLiteConvertFieldResolver(); var field = new Field("Field", typeof(decimal)); // Act var result = resolver.Resolve(field, setting); // Assert Assert.AreEqual("CAST([Field] AS [DECIMAL])", result); }