Database first EF 4.5 Model missing Boolean and int
Database first EF 4.5 Model missing Boolean and int
Generating a Model from an existing database using ADO in EF 4.5 and Devart dotconnect SQLite 4.4.164.0 generates a an EDMX Context and Model. However the model is missing all the (Boolean) bit types from the Database and all Integers are Longs. I'm sure this type missing and miss match is known... I read the doc: "General Concepts in Database Application Development" But I don't see a step by step for a Database first approach using the dotconnect library? any tutorials or documents would be appreciated.
Re: Database first EF 4.5 Model missing Boolean and int
After creating a database using code first and devart SQLite I was able to create a model using database first and devart SQLite. Both models matched perfectly with Booleans and integers. The problem I was having was from a SQLite database created with command line tools.