Rick’s post is the best one I found so far to explain the configuration file for LinQtoSql dbml. My experience is:
- Don’t set user’s password in your linqtosql dbml at the very beginning. Figure this configuration magic out first before everything starts.
- The “Settings Property Name” key in Connection section itself can give enough information. You need to add a same name connection string in your app config file, but watch out if you are in N-Tier development mode, which means your DAL lib is in different assembly. In that case, you need to use the full typed name “key” (with the DAL name space as the pre-fix) as the connection string name, as Rick emphasised.