SqlInMemory

KO | EN

gitlite — search

#android #ruby #java #php #python #dotfiles #aws #sms #react-native #reactjs #javascript #social-media

★ 33 Open GitHub ↗

SqlInMemory is a library for creating SqlServer database on Memory instead of hard disk, at last Drops and Disposes database when you're done with it. This is useful for Integration Testing.

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

[![NuGet](https://img.shields.io/nuget/v/SqlInMemory.svg)](https://www.nuget.org/packages/SqlInMemory/)
[![License: MIT](https://img.shields.io/badge/License-MIT-brightgreen.svg)](https://opensource.org/licenses/MIT)
[![Build Status](https://github.com/mjebrahimi/SqlInMemory/workflows/.NET%20Core/badge.svg)](https://github.com/mjebrahimi/SqlInMemory)

# SqlInMemory

**SqlInMemory** is a library for creating SqlServer database on **Memory** instead of hard disk, at last **Drops and Disposes** database when you're done with it. This is useful for **Integration Testing**.

**Note : This library uses [RamDisk](https://github.com/mjebrahimi/RamDisk) which also uses [ImDisk](http://www.ltr-data.se/opencode.html/#ImDisk) in the backend for creating virtual disk drive. Therefore you have to install imdisk first. ([Download link of current stable version 2.0.10](http://www.ltr-data.se/files/imdiskinst.exe))**

## Get Started

### 1. Install Package

```
PM> Install-Package SqlInMemory
```

### 2. Use it

Pass your connection string and it will create (mount) a virtual disk drive 'Z' and create database there finaly when disposed, drop database and unmount drive.

```csharp
var connectionString = "Data Source=.;Initial Catalog=TestDb;Integrated Security=true";
using (SqlInMemoryDb.Create(connectionString))
{
    //Use database using ADO.NET or ORM

//For example using EF Core
    services.AddDbContext<AppDbContext>(opt => opt.UseSqlServer(connectionString));
    var serviceProvider = services.BuildServiceProvider();
    var appDbContext = serviceProvider.GetService<AppDbContext>();
    appDbContext.Database.Migrate();
    //...
}
```

## Contributing

Create an [issue](https://github.com/mjebrahimi/SqlInMemory/issues/new) if you find a BUG or have a Suggestion or Question. If you want to develop this project, Fork on GitHub and Develop it and send Pull Request.

A **HUGE THANKS** for your help.

## License

SqlInMemory

Explore Similar Repositories

Was this content helpful?

Recent Feedback

Download README