Page 1 of 1

Database first EF 4.5 Model missing Boolean and int

Posted: Wed 06 Feb 2013 20:11
by acooper
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

Posted: Thu 07 Feb 2013 21:57
by acooper
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.