Open Source C# Frameworks

Fluent Migrator is a migration framework for .NET much like Ruby on Rails Migrations. Migrations are a structured way to alter your database schema and are an alternative to creating lots of sql scripts that have to be run manually by every developer involved. Migrations solve the problem of evolving a database schema for multiple databases (for example, the developer's local database, the test database and the production database). Database schema changes are described in classes written in C# that can be checked into a version control system. FluentMigrator is a .NET library that helps to version database schema using incremental migrations which are described in C#. The basic idea of the FAKE helper is to run FluentMigrator over the existing database using compiled assembly with migrations.

Npgsql.EntityFrameworkCore.PostgreSQL is the open source EF Core provider for PostgreSQL. It allows you to interact with PostgreSQL via the most widely-used .NET O/RM from Microsoft, and use familiar LINQ syntax to express queries. It's built on top of Npgsql. The provider looks and feels just like any other Entity Framework Core provider. Aside from providing general EF Core support for PostgreSQL, the provider also exposes some PostgreSQL-specific capabilities, allowing you to query JSON, array or range columns, as well as many other advanced features. For more information, see the the Npgsql site.

.NET port of the excellent Java Hibernate which provides Object/Relational mapping to persist objects in a relational database.

Entity Framework 6 (EF6) is a proven object-relational (O/RM) mapper for .NET with many years of feature development and stabilization. Like O/RM, EF6 reduces the impedance mismatch between the relational and object-oriented worlds, allowing developers to write applications that interact with data stored in relational databases with strongly typed .NET objects that represent the domain of the database. application, and eliminate the need for much of the data access "mechanical" code that you would normally write. Mapping POCO entity classes that do not depend on any EF type. Models can be generated from existing databases and then manually edited, or they can be created from scratch and then used to generate new databases. Integration with .NET Framework application models, including ASP.NET, and through data binding, with WPF and WinForms. Database connectivity based on ADO.NET and various providers available to connect to SQL Server, Oracle, MySQL, SQLite, PostgreSQL, DB2, etc.

This goal of this ORM (Object Relational Mapping) system is to accelerate the development of database-centric applications that dictate the structure of their own databases. (I.e. do not generally access tables and other database objects owned by other software) Sub-goals include automating certain menial functions such as upgrading of tables, persisting desired structure of tables to the database (such as during product installation), and easing the management of table-structure related source-code. This ORM is fairly mature, in that it has been used in several of my projects over the last 5 years. The open-source release of this ORM precedes, and will pave the way for, the open-source release of several of the above-mentioned projects.

The AdFactum Object Mapper is a relational object mapper for Microsoft .NET. It has special features like an internal localization functionality, support of data paging and a comprehensive query API. The mapper supports Oracle, SQL Server, Access and

Simplified ADODB interface library for MySQL on Mono/.NET. The library can be used to port MS ADODB project to an Mono environment.

CLAM (Common Language Automation Machine) attempts to eliminate the rote mapping of data to objects that is prevalent in most modern development languages by breaking the bonds of relational data and providing a generic mechanism for retrieving data.

A core framework based on .net technology to provide extended functionalities upon the standard .net framework. - Generic ORM engine (based on Emit) - High performance Cache impl - Lite Reflection.Emit framework - Collection Framework (proposed)

SubProjects: 1 - Universal .NET data connector; 2 - Universal Data Table; 3 - Universal Dynamic Data Table; 4 - EvoORM;

Cooperator is on the one hand, a base class library for Object Relational Mapping, ORM, and by another one, a tool of code generation for for the MS.Net 2.0/3.0, using Business Objects and Stored Procedures. DAL, ORM, UOW, FACADE, MAPPER, MODELING ...

Use this to easily add database connection management to a .Net client application. Provides an interactive GUI to set and test database connection parameters. Manages storage and retrieval of connection strings with minimal configuration.

GDBC mimics Java's JDBC for the .NET platform.

The JProgress project provides tools for connectivity with Java clients and the Progress database. JProgress provides an n-tier software architecture for database access for executing remote requests over WANs and the Internet.

LINQ to DB is the fastest LINQ database access library offering a simple, light, fast, and type-safe layer between your POCO objects and your database. Architecturally it is one step above micro-ORMs like Dapper, Massive, or PetaPoco, in that you work with LINQ expressions, not with magic strings, while maintaining a thin abstraction layer between your code and the database. Your queries are checked by the C# compiler and allow for easy refactoring. However, it's not as heavy as LINQ to SQL or Entity Framework. There is no change-tracking, so you have to manage that yourself, but on the positive side you get more control and faster access to your data. In other words LINQ to DB is type-safe SQL. Alternatively, you can implement custom settings provider with ILinqToDBSettings interface. You can generate POCO classes from your database using T4 templates.

Monet Objects is an easy-to-use .NET object-relational mapping library. It allows .NET developers to create applications dealing with persistent objects (relying on a relational database as MySql) without writing a single SQL query.

Open Dataset eXtensions is a quite tiny but extremely powerful ORM framework. It utilizes all the power of ADO.NET and adds the natural ease of OOP. ODX delivers on-the-fly proxy generation, relations, polymorphy, remoting, offline, save points, etc.

Persist.NET is a persistence framework written in C#.

Proetus is a .NET persistence framework. Once saved objects can be queried, retrieved, updated, and deleted. Adapters exist, both local and over a web service, to save objects to Microsoft® SQL Server, SQLite, MSMQ, and XML.

Replication framework for offline data syncronization. Requires minimal schema additions (particularly only the timestamp column for each super table). Built with maximum flexibility and performance in mind. Check coming project overview for more details

A collection of useful tools for developers in .Net, including mocking framework, utility library, extention to Castle's Windsor, etc.

The framework, for Microsoft Sql Server, is designed to manage users, groups, and permissions for objects defined within the scope of an application. It also consists of a .NET API for integrating the framework into Web or Form Applications.

Library that handles persisting plain .NET objects to and from an underlying relational database. Using attributes in your source code, you define validation and other behaviour. Supports hineritance, aggregation and persistant events.

The Foundry is an end-to-end data solution from modelling to programming.

Valkyrie is a Plug-In Application Hosting Framework for .Net Desktop Applications.