Skip to content
👽 A .NET database populator for testing purposes
C# PowerShell
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
src
test/StrangerData.UnitTests
.gitignore
.travis.yml
AUTHORS
Build.ps1
Contributing.md
LICENSE
README.md
StrangerData.sln
appveyor.yml

README.md

StrangerData - A .NET database populator for testing purposes

Travis

Project Description

StrangerData is a tool designed to automatically fills your database with random data to make your unit/integration tests faster.
The generator will auto maps all foreign keys and generates records to related tables.

Getting Started

  1. Install StrangerData with NuGet Package Manager:

Install-Package StrangerData

  1. Install your database dialect, example:

Install-Package StrangerData.SqlServer

  1. Configure the required connection strings.

To start generating your test data, create a new DataFactory object:

using StrangerData;
using StrangerData.SqlServer;
...
var dataFactory = new DataFactory<SqlServerDialect>("MyConnectionString");

Usage

Consider the example schema:

Person Table

Column Data Type PK FK
Id INT True False
Name VARCHAR(20) False False
Email VARCHAR(50) False False
Age INT False False
TeamId INT False Team(Id)

Team Table

Column Data Type PK FK
Id INT True False
Name VARCHAR(20) False False

1. Creates a single record:

...
IDicionary<string, object> record = dataFactory.CreateOne("dbo.Person");

The method will creates an record in the group table, and associates it to the created user. The dictionary will contains:

{
  "Id": "Generated User's Id",
  "Name": "Random string",
  "Email": "Random string",
  "Age": "Random integer number",
  "TeamId": "Id from generated group record"
}

So you can specify your custom values. Do following:

User user = dataFactory.CreateOne("dbo.Person", t => {
    t.WithValue("Name", "Will Byers");
});

The dictionary will contains:

{
  "Id": "Generated User's Id",
  "Name": "Will Byers",
  "Email": "Random string",
  "Age": "Random integer number",
  "TeamId": "Id from generated group record"
}

2. Delete generated records:

To delete all generated records, just run:

...
dataFactory.TearDown();
...

We suggest to use the TearDown() method inside yor Finally scope. This way it will run even if you code crashes on running, avoiding to have dirty data on your database.

You can’t perform that action at this time.