search

bubibubi / JetEntityFrameworkProvider

Microsoft Access (Jet) Entity Framework provider
89 stars 26 forks source link

Single and Double-Datatype not supported (?!) #36

Open goodn8 opened 6 years ago

goodn8 commented 6 years ago

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

| 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?

WaterFlight80 commented 4 years ago

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

bubibubi commented 4 years ago

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

WaterFlight80 commented 4 years ago

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

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

bubibubi commented 4 years ago

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

WaterFlight80 commented 4 years ago

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?