SqlInMemory

KO | EN

gitlite — search

#react #ai #llm #go #android #rust #docker #macos #kubernetes #awesome-list #pytorch #security #ios #open-source

(★ 33)

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.

SqlInMemory Latest Version Download

Download Latest Version (.zip)

// 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

SqlInMemory Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

SqlInMemory

SqlInMemory Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

Download README