Mapping .NET boolean datatype to oracle number(1,0) in .edmx file throws following error.
Error 2019: Member Mapping specified is not valid. The type
'Edm.Boolean[Nullable=False,DefaultValue=]' of member 'COLUMN123' in
type 'DBModel.TABLE123' is not compatible with
'OracleEFProvider.number[Nullable=False,DefaultValue=,Precision=1,Scale=0]'
of member 'CHECK_INSTALLATION' in type 'DBModel.Store.TABLE123'.
Can a Boolean datatype be mapped to oracle's number(1,0) using entity framework?
Best Answer
Adding a oracle.dataaccess.client section wasn't sufficient for me. The following (taken from Deploying and Configuring ODP.NET to work without installation with Entity Framework) did work: