Database Unit Testing with C#

  •        104

Database Unit Testing with C# and NUnit. DatabaseUnitTesting

http://databaseunittesting.codeplex.com/

Tags
Implementation
License
Platform

   




Related Projects

AnyDbTest


AnyDbTest is the first and only automated DB unit testing tool available using XML as test case. AnyDbTest is just designed for DBA/DB developers. It supports all kinds of popular database, such as Oracle, SQL Server, MySQL, and PostgreSQL etc.

T.S.T. the T-SQL Test Tool


TST simplifies the task of writing and running test automation for T-SQL code. Written in T-SQL it provides an API similar to those provided by other Unit Testing frameworks. Can produce test reports in XML format. It provides automatic rollback, dataset comparison support, etc.

SQL Load Test


This tool takes a SQL Profiler trace file and generates a unit test that replays the same sequence of database calls found in the trace file. The unit test is designed for Visual Studio Load Test. The code generated is easily modifiable so that data variation can be included.

QueryUnit


A project that allow the execution of Unit Testing against a database (Relational or Multidimensional). It uses NUnit as unit-testing framework and does not require DBA or BI Developer to know anything about .NET: just write your SQL or MDX queries and test them

Sql 2005 DataBase Helper


This is a helper class to use Sql server 2005. 1. Simplifies connection 2. Reading data, querying the database 3.Updating data to the database 4. Get data in form of Datasets, DataTable, Datareader etc Vs2005 and C# .Net 2.0



Coolstorage - ORM library for .NET


The main strength of Vici CoolStorage is the ease of use. Most ORM tools still require a lot of unneeded code to accomplish basic data persistence tasks, but Vici CoolStorage is designed to relieve the programmer from these tedious and error-prone tasks, making it very intuitive to use.

VisualDB (Database Management using Visual WebGui)


VisualDB is a Database Management created using Visual WebGui and actually support SQL Server 2000-2005 and MySQL 5.

Free SQL Server Database Templates & SQL Code Download


You can download here SQL Server Database Templates an SQL Source codes for various type of projects, Template Downloads for SQL Server

Chinook Database


Chinook is a sample database available for SQL Server, Oracle, MySQL, etc. It can be created by running a single SQL script. Chinook database is an alternative to the Northwind database, being ideal for demos and testing ORM tools targeting single and multiple database servers.

Sqlmap - Automatic SQL injection and database takeover tool


sqlmap is an open source penetration testing tool that automates the process of detecting and exploiting SQL injection flaws and taking over of database servers. It comes with a powerful detection engine, many niche features for the ultimate penetration tester and a broad range of switches lasting from database fingerprinting, over data fetching from the database, to accessing the underlying file system and executing commands on the operating system via out-of-band connections.

ExportSQLScript - Export MS SQL 2008R2/2008/2005/2000 objects to script


Command line driven utility to export MS SQL objects to script files suitable for database creation and revision control. Uses 2008R2 Server Management Objects (SMO) which are compatible with SQL Server 2000, SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2.

dockertest - Write better integration tests! Dockertest helps you boot up ephermal docker images for your Go tests with minimal work


When developing applications, it is often necessary to use services that talk to a database system. Unit Testing these services can be cumbersome because mocking database/DBAL is strenuous. Making slight changes to the schema implies rewriting at least some, if not all of the mocks. The same goes for API changes in the DBAL. To avoid this, it is smarter to test these specific services against a real database that is destroyed after testing. Docker is the perfect system for running unit tests as you can spin up containers in a few seconds and kill them when the test completes. The Dockertest library provides easy to use commands for spinning up Docker containers and using them for your tests.Using Dockertest is straightforward and simple. Check the releases tab for available releases.

DbDiff: Database Diff and Database Scripting


Compare MSSql database structures. (Sql 2005, Sql 2008, Sql 2008R2, Sql Denali ) Features: - compare database structures - scripting without dmo or smo - commandline scripting, commandline compare - standalone dll-s for referencing

MassDataHandler


The MassDataHandler is a framework to assist with Database Unit Testing. The framework makes it very easy to insert test data into a database, which in turn makes it very easy to write database unit tests. The user merely needs to specify their relevant data in a simple XML f...

SqlHarvester Database Scripting Engine


SqlHarvester is a free command-line based scripting engine written in .Net. It enables the import/export of database content across disconnected Sql Server databases.

SQL Service Broker Management Studio


Service Broker is part of the SQL Server 2005 Database Engine, includes infrastructure for asynchronous programming that can be used for applications within a single database or a single instance as well as for distributed applications. The current version of the management st...

ssisUnit


ssisUnit is a unit testing framework for SQL Server Integration Services.

Open DBDiff


Open DBDiff is an open source database schema comparison tool for SQL Server 2005/2008. It reports differences between two database schemas and provides a synchronization script to upgrade a database from one to the other.