Working on learning Entity Framework to make things a little cleaner when it comes to mapping the code to the database. Here is a screenshot of the schema so far.
InitialSchema.jpg
EF seems like a nice tool: you can access the parts of your schema like they are objects and then just call "SaveChanges" on a context associated with the schema to get the updates, inserts and deletes to all happen. Should be nice with things like forms where users are entering in new tests and such.
Problem with entity framework that I notice (using 4.1 on VS 2010 Ultimate Win 7 64 Ultimate): building database from model seems to crash VS. It does create the DDL file needed for sql server so I just open that in SQL Management Studio and run it and everything is fine but not as clean a process as I would hope. Seems like others have problems getting EF working in the first place. I did too. Didn't show the templates had to manually install it again from my VS installation disk then upgrade to 4.1. Not clean but still better than coding models by hand.