4 ms·
I just started trying out pgsql with entityframework core the other day via http://www.npgsql.org/ http://www.npgsql.org/. Super easy to set up and get working
by bpicolo 9y ago
I just started trying out pgsql with entityframework core the other day via http://www.npgsql.org/ http://www.npgsql.org/.
Super easy to set up and get working with. I've never used EF6 , so I can't really comment there, but I've seen mention that entity framework core is missing features relative to ef6, so that's something to think about.
Dealing with not-builtin types like jsonp/hstore is a bit tricky in EF so far it feels like, but doable? Doesn't seem like you can get a real first class experience with that yet though.
- nikcub 9y ago> not-builtin types like jsonp/hstore is a bit tricky in EF so far it feels like, but doable? and no support for spatial data types. it's why i'm still mostly using SQLAlchemy and Python - i'm a big fan of .NET Core, though.
- bpicolo 9y agoHmm. Npgsql supports polygons in some sense, but you have to add some custom bits on top I suppose? I'm not sure how querying works though. SQLAlchemy is pretty much the only framework I've seen do this pretty well, though I have plenty of other qualms with it. Still probably my favorite ORM overall.
- ahoka 9y agoWe use jsonb with ef core. Just use a string property with Column(TypeName="jsonb") and deserialize with newtonsoft. I think you could use raw queries to do some advanced stuff.
- bpicolo 9y agoYeah, that's what I'm doing atm in a new project :) I just wish I could make it a JToken or whatever and give EF a db serializer. Can do similar with getters / setters I guess?
- philliphaydon 9y agoYou should checkout Marten :)