Dashing is a simple to use mini ORM built on top of [Dapper](https://github.com/StackExchange/dapper-dot-net).
It aims to be a strongly typed data access layer that is built with productivity and performance in mind.
📘 **Documentation** for v2 is available to [view here](http://polylytics.github.io/dashing/).
# Features
* Convention over Configuration with code-first minimal configuration
* SQL-like strongly typed query syntax
* Paging support
* Eager loading of relationships
* Change tracking
* CRUD operations
* Default transactional behaviour
* Schema generation/migrations
* Dynamic method generation and caching
* Builds on top of Dapper
* Multiple database support (SQL Server/MySql right now)
* In-memory engine for testing
# Examples
Get Entity
```cs
var post = await session.GetAsync(123);
var post = await session.Query().SingleAsync(p => p.PostId == 123);
```
Insert
```cs
var post = new Post { Title = "Hello World" };
await session.InsertAsync(post);
Console.WriteLine(post.PostId); // 123
```
Update changed properties only
```cs
var post = await session.GetAsync(123);
post.Title = "New Title";
await session.SaveAsync(post); // update [Posts] set [Title] = @P1 where [PostId] = @P2
```
Delete
```cs
await session.DeleteAsync(post);
```
Eager fetching of related entities
```cs
var posts = await session.Query()
.Fetch(p => p.Author)
.Fetch(p => p.Tags)
.FetchMany(p => p.Comments).ThenFetch(c => c.Author)
.Where(p => p.Category == ".Net ORM")
.OrderByDescending(p => p.CreatedDate)
.ToListAsync();
```
Paging
```cs
var firstPage = await session.Query().AsPagedAsync(0, 10);
```
Count/Any
```cs
var numberPosts = await session.Query().CountAsync(p => p.Author.UserId == userId);
var hasAuthored = await session.Query().AnyAsync(p => p.Author.UserId == userId);
```
Bulk update entity
```cs
await session.UpdateAsync(p => p.IsArchived = true, p => p.Author.UserId == 3);
// update [Posts] set [IsArchived] = @P1 where [AuthorId] = @P2
```
Bulk delete
```cs
await session.DeleteAsync(p => p.IsArchived);
```
Drop to Dapper
```cs
await session.Dapper.QueryAsync("select 1 from Foo");
```
Inspect changes
```cs
post.Title = "New";
session.Inspect(post).IsPropertyDirty(p => p.Title);
var oldTitle = session.Inspect(post).GetOldValue(p => p.Title); // Old
```
Migrate database to match latest code
./dash migrate -a "" -t "" -c ""
# Who uses Dashing?
Dashing has been developed over the last 4 years at [Abstract Leap](https://www.abstractleap.com) and is in use at nearly all of our clients. It's used to execute millions of queries every week.
Feature requests (and voting for them) available at [Feathub](http://feathub.com/Polylytics/dashing)
[](https://gitter.im/Polylytics/dashing?utm_source=badge&utm_medium=badge&utm_campaign=pr-badge&utm_content=badge)