views:

27

answers:

1

I allow users to specify the data source and connection details. When this is complete, I set the Entity connection string. How do I validate the database they have chosen against the entity model right away? I don't want to get further in the program to have it fail.

A: 

Check for the existence of a known table and/or use a version table to store the schema version.

Mitch Wheat
I was hoping for something a little more advanced. I guess I would have to code it myself. The problem with versioning is that most of the time I do not change the schema so I don't want to store the app version #. So I have to remember to manually update the database version # everytime the schema changes.
esac