Question:
When I use SqlExpress 2005 with LLBLGen Pro, I get long path names in my queries, like C:\mydatabases\myproject\mydatabase.mdf instead of the catalog name. Also, if I use C# as the language of choice, I get compile errors. How to solve this?
**
Solution:**
Until the SqlServer driver for LLBLGen Pro is updated to support SqlExpress .mdf files natively, use the following steps to use SqlExpress databases with LLBLGen Pro:
- create the database using SqlServer management studio,
- add all tables/views/procedures etc. to that database
- specify as server in the connection parameters section of Create New project in LLBLGen Pro '.\SQLEXPRESS' (without the quotes).
- you now should be able to work with the database without problems.