search

zzzprojects / EntityFramework-Classic

Entity Framework Classic is a supported version of the latest EF6 codebase. It supports .NET Framework and .NET Core and overcomes some EF limitations by adding tons of must-haves built-in features.
https://entityframework-classic.net
Other
103 stars 27 forks source link

Type not supported yet (LazyType): sdo_geometry #51

Closed jack-gaojz-zz closed 4 years ago

jack-gaojz-zz commented 4 years ago

Call the "DeleteFromQuery", the database contains the spatial data type will throw the error: Type not supported yet (LazyType): sdo_geometry.

Database: Oracle 11g. .Net Framework 4.7 EntityFramework 6.4. Provider: Devart.Data.Oracle

I just want to use the "DeleteFromQuery" for the entity and the entity doesn't have the geometry column, and the other data table contains. Since the entity which just wants to delete doesn't contain the geometry column, why throw the error message? It blocks me.

Anyone can give some suggestions? Thanks so much.

JonathanMagnan commented 4 years ago

Hello @jack-gaojz ,

Is this for EF Extensions or EF Classic? As you use EF 6.4, it looks more like a bug for the EF Extensions library.

This error probably happens when we read your model. Do you think you could provide your EDMX model? https://entityframework-extensions.net/edmx

You can send in private here: info@zzzprojects.com

We will make sure that all your types are supported.

jack-gaojz-zz commented 4 years ago

@JonathanMagnan I used the "Z.EntityFramework.Extensions" 4.0.57. Ok, I will send the EDMX file. Thanks so much.

JonathanMagnan commented 4 years ago

Awesome @jack-gaojz

we will be looking forward to hearing from you ;)

Jon

JonathanMagnan commented 4 years ago

Hello @jack-gaojz ,

The v4.0.59 has been finally released.

Could you try it and let us know if everything is working as expected.

We didn't updated yet the fix for EF Classic, so if you were really using EF Classic, let us know and we will release it as well. (If there is no v4.0.59 available that mean you are using the classic package probably)

jack-gaojz-zz commented 4 years ago

Ok, thanks so much. I will try it ASAP. :)

jack-gaojz-zz commented 4 years ago

Hello @jack-gaojz ,

The v4.0.59 has been finally released.

Could you try it and let us know if everything is working as expected.

We didn't updated yet the fix for EF Classic, so if you were really using EF Classic, let us know and we will release it as well. (If there is no v4.0.59 available that mean you are using the classic package probably)

I have tried it, but failed. image

Maybe caused by the provider(Devart.Data.Oracle) not support the bulk operations.

JonathanMagnan commented 4 years ago

We will look at it,

It should be supported but perhaps we are missing something for DeleteFromQuery method

jack-gaojz-zz commented 4 years ago

Thanks so much. :)

JonathanMagnan commented 4 years ago

Hello @jack-gaojz ,

Sorry for the delay, I just found out that it seem we didn't answer you.

My developer and I tried to reproduce it, but none of us succeed. It seem that everything work with Devart.Data.Oracle so we are probably missing something.

Do you think you could provide us a project?

You can send it to: info@zzzprojects.com if you need to keep the source private

Best Regards,

Jon

jack-gaojz-zz commented 4 years ago

Hello @jack-gaojz ,

Sorry for the delay, I just found out that it seem we didn't answer you.

My developer and I tried to reproduce it, but none of us succeed. It seem that everything work with Devart.Data.Oracle so we are probably missing something.

Do you think you could provide us a project?

You can send it to: info@zzzprojects.com if you need to keep the source private

Best Regards,

Jon

I think the issue has been fixed with the latest version. Thanks so much. :)

JonathanMagnan commented 4 years ago

Awesome!

we are glad everything is working out for you :)

Don't hesitate to contact us for questions, issues or feedback!

Have a good one,

Jon