public void Can_save_complex_types_as_JSON() { using (var db = OpenDbConnection()) { db.DropAndCreateTable<ModelWithJsonType>(); db.GetLastSql().Print(); var row = new ModelWithJsonType { Id = 1, ComplexTypeJson = new ComplexType { Id = 2, SubType = new SubType { Name = "SubType2" } }, //ComplexTypeJsonb = new ComplexType //{ // Id = 3, SubType = new SubType { Name = "SubType3" } //}, }; db.Insert(row); var result = db.Select<ModelWithJsonType>( "complex_type_json->'sub_type'->>'name' = 'SubType2'"); Assert.That(result.Count, Is.EqualTo(1)); Assert.That(result[0].Id, Is.EqualTo(2)); Assert.That(result[0].ComplexTypeJson.SubType, Is.EqualTo("SubType2")); } }
public void Can_save_complex_types_as_JSON() { using (var db = OpenDbConnection()) { db.DropAndCreateTable <ModelWithJsonType>(); db.GetLastSql().Print(); var row = new ModelWithJsonType { Id = 1, ComplexTypeJson = new ComplexType { Id = 2, SubType = new SubType { Name = "SubType2" } }, //ComplexTypeJsonb = new ComplexType //{ // Id = 3, SubType = new SubType { Name = "SubType3" } //}, }; db.Insert(row); var result = db.Select <ModelWithJsonType>( "complex_type_json->'sub_type'->>'name' = 'SubType2'"); Assert.That(result.Count, Is.EqualTo(1)); Assert.That(result[0].Id, Is.EqualTo(2)); Assert.That(result[0].ComplexTypeJson.SubType, Is.EqualTo("SubType2")); } }