search

oracle / dotnet-db-samples

.NET code samples for Oracle database developers #OracleDotNet
http://otn.oracle.com/dotnet
MIT License
408 stars 190 forks source link

Supporting JSON-column in EF Core #259

Closed elmanav closed 7 months ago

elmanav commented 1 year ago

Are the new .NET EF Core 7 JSON-column supported? Сurrently still it RC, but with the release we would like to be able to manipulate json-data in table columns (https://devblogs.microsoft.com/dotnet/announcing-ef7-release-candidate-2/).

alexkeh commented 1 year ago

Not in the initial release, but it's something we're taking a look at. Is your team using Oracle DB JSON columns?

elmanav commented 1 year ago

Not in the initial release, but it's something we're taking a look at. Is your team using Oracle DB JSON columns?

Yes, we use json-docs to store some data in tables. Get a hybrid.

alexkeh commented 1 year ago

I've filed ER 34700870 to track this feature request. If there are others that would like to see this feature, please upvote the original request.

SavoInfostream commented 1 year ago

Here's a link with the complete feature list: Entity Framework Core 7 (EF7) is available today. This probably won't get a lot of upvotes at the start, but I think these features for .NET developers are much more convenient than than JSON syntax in SQL 😵😵😵

Benefits:

So, please implement them.

P.S. "ORA-50612: Mapping .NET Aggregate types to JSON column is currently not supported" I got this today, so don't forget the lists.

alexkeh commented 1 year ago

Our expectation is for EF Core JSON support to be available with the 21.10 version of ODP.NET EF Core.

alexkeh commented 1 year ago

Unfortunately, we weren't able to get this update into 21.10. We're still working on this feature update and fixing associated bugs.

biplovkc commented 1 year ago

@alexkeh Is there any ETA on EF Core Json support? We have been using oracle json column and this feature would make things so much easier

alexkeh commented 1 year ago

@biplovkc Not yet. I'll try to get one soon.

Wx19880221 commented 1 year ago

@alexkeh now ef core 7.21 add the feature? I found still report ORA-50612: Mapping .NET Aggregate types to JSON column is currently not supported.

alexkeh commented 1 year ago

@Wx19880221 Oracle continues to work on adding EF Core JSON column support. It's hard to provide an ETA since resolving some of the significant bugs requires fixes in EF Core itself. When we encounter EF Core issues, we report them to MS.

alexkeh commented 7 months ago

JSON columns supported starting with Oracle EF Core 8.