Npgsql / EF 6 - json column
<p>I'm trying to create a migration with a JSON column. Here's what I tried:</p>

<pre><code>    [Column(TypeName = "Jsonb")]
    public string Data { get; set; }

    [Column(TypeName = "Json")]
    public string Data { get; set; }

    modelBuilder.Entity&lt;Member&gt;().Property(p =&gt; p.Data).HasColumnType("Json");

    modelBuilder.Entity&lt;Member&gt;().Property(p =&gt; p.Data).HasColumnType("Jsonb");
</code></pre>

<p>Nothing works at all, here's the exception:</p>

<blockquote>
  <p>System.InvalidOperationException: Sequence contains no matching element
     at System.Linq.Enumerable.Single[TSource](IEnumerable<code>1 source, Func</code>2 predicate)
     at System.Data.Entity.Utilities.DbProviderManifestExtensions.GetStoreTypeFromName(DbProviderManifest providerManifest, String name)
     at System.Data.Entity.ModelConfiguration.Configuration.Properties.Primitive.PrimitivePropertyConfiguration.ConfigureColumn(EdmProperty column, EntityType table, DbProviderManifest providerManifest)
     at System.Data.Entity.ModelConfiguration.Configuration.Properties.Primitive.PrimitivePropertyConfiguration.Configure(EdmProperty column, EntityType table, DbProviderManifest providerManifest, Boolean allowOverride, Boolean fillFromExistingConfiguration)
     at System.Data.Entity.ModelConfiguration.Configuration.Properties.Primitive.PrimitivePropertyConfiguration.&lt;>c__DisplayClass4.b__3(Tuple<code>2 pm)
     at System.Data.Entity.Utilities.IEnumerableExtensions.Each[T](IEnumerable</code>1 ts, Action<code>1 action)
     at System.Data.Entity.ModelConfiguration.Configuration.Properties.Primitive.PrimitivePropertyConfiguration.Configure(IEnumerable</code>1 propertyMappings, DbProviderManifest providerManifest, Boolean allowOverride, Boolean fillFromExistingConfiguration)
     at System.Data.Entity.ModelConfiguration.Configuration.Types.StructuralTypeConfiguration.ConfigurePropertyMappings(IList<code>1 propertyMappings, DbProviderManifest providerManifest, Boolean allowOverride)
     at System.Data.Entity.ModelConfiguration.Configuration.Types.EntityTypeConfiguration.ConfigurePropertyMappings(DbDatabaseMapping databaseMapping, EntityType entityType, DbProviderManifest providerManifest, Boolean allowOverride)
     at System.Data.Entity.ModelConfiguration.Configuration.Types.EntityTypeConfiguration.Configure(EntityType entityType, DbDatabaseMapping databaseMapping, DbProviderManifest providerManifest)
     at System.Data.Entity.ModelConfiguration.Configuration.ModelConfiguration.ConfigureEntityTypes(DbDatabaseMapping databaseMapping, ICollection</code>1 entitySets, DbProviderManifest providerManifest)
     at System.Data.Entity.ModelConfiguration.Configuration.ModelConfiguration.Configure(DbDatabaseMapping databaseMapping, DbProviderManifest providerManifest)
     at System.Data.Entity.DbModelBuilder.Build(DbProviderManifest providerManifest, DbProviderInfo providerInfo)
     at System.Data.Entity.DbModelBuilder.Build(DbConnection providerConnection)
     at System.Data.Entity.Internal.LazyInternalContext.CreateModel(LazyInternalContext internalContext)
     at System.Data.Entity.Internal.RetryLazy<code>2.GetValue(TInput input)
     at System.Data.Entity.Internal.LazyInternalContext.InitializeContext()
     at System.Data.Entity.Internal.InternalContext.GetEntitySetAndBaseTypeForType(Type entityType)
     at System.Data.Entity.Internal.Linq.InternalSet</code>1.Initialize()
     at System.Data.Entity.Internal.Linq.InternalSet<code>1.get_InternalContext()
     at System.Data.Entity.Internal.Linq.InternalSet</code>1.get_Local()
     at System.Data.Entity.DbSet`1.get_Local()
     at System.Data.Entity.DbModelBuilderExtensions.RegisterUserAccountChildTablesForDelete[TKey,TAccount,TUserClaim,TLinkedAccount,TLinkedAccountClaim,TPasswordResetSecret,TTwoFactorAuthToken,TUserCertificate](DbContext ctx) in c:\ballen\github\brockallen\BrockAllen.MembershipReboot\src\BrockAllen.MembershipReboot.Ef\DbModelBuilderExtensions.cs:line 26</p>
</blockquote>

<p>Here's my config:</p>

<pre><code>&lt;package id="EntityFramework" version="6.1.1" targetFramework="net452" /&gt;
&lt;package id="EntityFramework6.Npgsql" version="3.1.1" targetFramework="net452" /&gt;
&lt;package id="Npgsql" version="3.1.6" targetFramework="net452" /&gt;
</code></pre>