Yes, if you can call GetEntities<Customer>() and get results back, then you're able to connect to the database--Though I don't quite understand how you did that before a successful login.

 

Are you using the latest version IdeaBlade Tutorial database?  Does the database contain the SecurityUser table and the other tables beginning with "Security"?

 

Bill J.

 

EntityList<Customer> customers = pManager.GetEntities<Customer>();

 

and it retrieved 92 rows.  So I know that my connection string is correct and I am able to contact as a user in my database.  the problem is with the GetUserByCredential() in SecurityUser.  The program crashes on the GetEntity<SecurityUser>(q) line of code.  The error being received is "Incorrect syntax near the keyword 'from'".  Examining further, I see the following, EntityType.DeclaringMethod threw an exception of type System.InvalidOperatingException.  I am stumped.  Using the CAB wizard I created a new app and pointed it toward another database and everything works fine, no problem at this point.  In the Cabana app, I am passing a valid user name and password as a parameter to the GetEntity method.  If I bypass the call to login, the app starts fine.