Microsoft SQL Server. Simplified.

Close the gap between native SQL and application code.

var rockstar = db.SelectOne(
        (dbo.Employee.Name + " " + dbo.Employee.LastName).As("Rockstar"),
		db.fx.Count(dbo.PrimaryEngineerId.Id).As("KnockedItOutOfThePark")
    )
    .From(dbo.Employee)
	.InnerJoin(dbo.Project).On(dbo.Employee.Id == dbo.Project.PrimaryEngineerId)
    .Where(dbo.Project.PeerReviewScore == PeerReviewScore.ExceededExpectations)
	.GroupBy(dbo.Project.PrimaryEngineerId)
	.OrderBy(db.fx.Count(dbo.PrimaryEngineerId.Id).Desc());
	
var you = await rockstar.ExecuteAsync();

Painless synchronization

dbExpression keeps your code in-sync with your database schema with one simple command. Easy peasy.

Refactor with confidence

dbExpression doesn't use strings to write queries, it uses compiled and type-safe code. Refactoring is a breeze when you let the compiler do the work.

Reduce runtime exceptions

Avoid runtime exceptions from a typo. That's right, that gnarly string some call a SQL statement will be a thing of the past.

Easy for teams

With an easy-to-follow development workflow, your team is free to focus on the fun stuff.

Source control just got better

dbExpression ensures a clear view of database changes in source control, showing precisely what changed and when.

It just works

dbExpression manages an intuitive API of your database, backed by a solid framework. You get to work on other things and not worry about your .NET ORM.

Fluent SQL

Author strongly-typed SQL queries in code using a guided and fluent syntax.

Intellisense

See database names, data types, indexes, and many more in intellisense - no need to switch to another view.

Seamless workflow

Make database changes, regenerate code, and immediately see the impact from the compiler.

Extensible

Extensible by design, configurable to your needs.

Microsoft SQL Server. Simplified.

Works with Microsoft SQL Server 2005+

dbExpression was created to simplify applications using Microsoft SQL Server.

Created for Microsoft .NET

dbExpression works with any project targeting .NET Standard 2.0 or higher. dbExpression works with .NET Framework and .NET Core.

Available from NuGet

dbExpression is quick and easy to get up and running using a couple of packages and a dotnet tool - all available on NuGet.

Source on GitHub

dbExpression is open source under the Apache 2.0 license.