GraphQL API for SQL DB C# graphql-to-sql engine

Graphql-to-SQL engine uses open-source NReco.Data (MIT license) for SQL queries generation; this library can be used with existing ADO.NET providers:

• MS SQL Server, Azure SQL
• MySql, MariaDB and other mysql protocol compatible databases
• PostgreSql, Amazon Redshift
• Oracle, IBM DB2, Sqlite and many others (any SQL DB that has ADO.NET provider)

In fact it is possible to use a database even if it has no ADO.NET provider with help of ODBC data provider (which is already available for .NET Core apps).

In addition to SQL generation NReco.Data supports:

• application-level data views: you can define templates with complex SELECTs to load Graphql objects
• hooks for modifying database queries for data access control: extra WHERE conditions may be added depening on the security context
• access log: all queries may be logged
• data caching: in case of heavy graphql API load it is possible to cache SQL query result in respect to parameters and security context

The following code snippet illustrates how to configure a database adapter (SQL Server):

private NReco.Data.DbDataAdapter ConfigureDataSource() {
	var connStr = "Server=localhost;Database=northwind;";
	// configure ADO.NET and NReco.Data components
	var dbFactory = new NReco.Data.DbFactory(System.Data.SqlClient.SqlClientFactory.Instance) {
		LastInsertIdSelectText = "SELECT @@IDENTITY"
	};
	var dbConnection = dbFactory.CreateConnection();
	dbConnection.ConnectionString = connStr;
	var dbCmdBuilder = new NReco.Data.DbCommandBuilder(dbFactory);
	return new NReco.Data.DbDataAdapter(dbConnection, dbCmdBuilder);
}

NReco.Graphql library has 2 types of license:

• Standard: applicable for all project types except SaaS apps. Its price takes into account project's development team size (all tech people who works on the project). This license allows component DLL redistribution as part of your product - say, if this is on-premise software that has multiple installations. It is possible to purchase enterprise license of this type which allows unlimited number of developers.
• SaaS: applicable only for cloud SaaS apps. Takes into account max number of servers (VMs, docker containers) used by SaaS app in production. It is possible to purchase enterprise license of this type which allows unlimited number of SaaS-app servers.

Sometimes the product uses mixed sales model - available both as cloud SaaS service and on-premise installations. In this case both kind of licenses are needed.

Commercial license itself is perpetual and your license key will not expire. However, free upgrades are limited by 1 year - this means that your key will work for all new releases published in a year after purchase date. After this period you can use the latest version that accepts your key, or purchase a new license key to upgrade.