Data layer testing

Question

Trying to wrap my head around test driven development. Unit testing is already in place and works fine from business layer up to and including web UI. Now I’m trying to solve question how to test data layer and underlined database. In the past, data layer had more code than in business layer and UI, and keeping the layer untested really hurts quality.

Are there any frameworks to set up database and data layer testing? To be specific, I'm looking solutions for .NET Framework and SQL Server, but I also interested for other platforms and databases.

ChrisLively · Accepted Answer · 2009-03-17 19:10:20Z

2

If you are using Visual Studio Team Edition, then you can use the Database Developer part to create unit tests against your datamodel.

Other than that, just use regular unit tests to call your DAL or stored procedures directly.

Of course, Database testing usually has an additional set up task for getting the data in a state for testing. And another one for cleaning up after all of the processing has occurred.

answered Mar 17, 2009 at 19:10

ChrisLively

88.3k27 gold badges174 silver badges249 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Data layer testing

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related