At run time how to I verify that the database schema matches my objects?

Question

I have data access object that have been generated by SqlMetal, however the database is created by running a sql script.

Is there an easy way to verify that all table and columns names and type matches the attributes on the classes that SqlMetal created?

Answer 1

I guess the easiest way to do this would be to have some kind of version number hidden in a config table in your schema. Then on runtime check the version number returned.

Much easier than doing a full scan. Set the version number in your SQL script and somewhere in your data access object