JetEntityFrameworkProvider Single and Double-Datatype not supported (?!)

Single and Double-Datatype not supported (?!)

Open goodn8 opened this issue 6 years ago • 5 comments

When running a DbFirst on an existing .accdb, I got the message

<Single>|<Double> datatype currently not supported for the targeted entity-framework version. Column [colname] in table [tablename] was excluded.

Is this just an issue with DbFirst or will JetEntityFramework not work at all with those datatypes?

Oct 09 '18 21:10 goodn8

I have the same problem. Is there any solution? In the "JetDataTypeAliasCollection.cs" file is single and double included.

Sep 17 '20 12:09 WaterFlight80

DbFirst has some issues on JetEntityFrameworkProvider. Have you tried .Net Core provider?

Sep 17 '20 12:09 bubibubi

No, I didn’t try the .Net Core provider.

So maybe I can choose a walk around if I take decimals instead of doubles.

Sep 17 '20 14:09 WaterFlight80

Decimal type has an issue with Jet. If I remember it works only with US-EN culture (otherwise it misses the decimal point).

Sep 17 '20 14:09 bubibubi

Using .Net Core provider throw out an error (Method creat is not implemented in assembly).

With JetEntityFrameworkProvider I tried with byte, there is the same problem. Is there no way to use double columns with DbFirst?

Sep 17 '20 22:09 WaterFlight80