Which RDBMS support you want to see in linq2db?

[MaceWindu]

Please, don't start any discussion in this thread. Only add new RDBMS or vote for existing one.
Important notes:

• we cannot add support for database if it doesn't have ADO.NET, OLE DB or ODBC provider. You still can add it here, but we will not start working on it without provider.
• we cannot add support for database if it is not available for testing (linux-based docker image is prefered). Still it is a good candidate for 3rd-party linq2db extension, like DB2 iSeries
• check list of already supported databases before posting new request

List of requested RDBMS (not yet supported)

RDBMS	Vote	Issue / Pull	Testable	Has Provider	Notes
Amazon Redshift	#1014 (comment)	#886	➖ ?	✔️	not actionable: only limited-time trial version available
Cassandra using DataStax	#1014 (comment)	#552	✔️ view	✔️
Sybase using ODBC	#1014 (comment)	#499	✔️	✔️	benefits not clear comparing to two already supported providers
Sybase SQL Anywhere	#1014 (comment)	#186	✔️ view	✔️
CSV Files	#1014 (comment)		✔️	✔️ view
RQLite	#1014 (comment)		✔️	➖	existing provider doesn't implement ADO.NET API
OSQuery	#1014 (comment)		✔️	no?
SAP/Sybase IQ	#1014 (comment)		no?	✔️
Ingres	#1014 (comment)	#2910	➖	✔️
Snowflake	#1014 (comment)		➖	✔️
CockroachDB	#1014 (comment)		✔️ view	✔️
DB2iSeries	#1014 (comment)	#2473	➖		all iSeries requests should be logged here
Azure Synapse	#1014 (comment)		➖ ?	✔️
OpenSQL	#1014 (comment)		no?	✔️
PostgreSQL using dotConnect	#1014 (comment)		✔️	?	don't see any benefits compared to Npgsql provider
Azure Cosmos DB	#1014 (comment)		?	no?
Windows Search	#1014 (comment)		✔️	✔️
Yandex YDB	#1014 (comment)		✔️ view	no?
Couchbase	#1014 (comment)		✔️ view	no	existing provider doesn't implement ADO.NET API
Kingbase	#1014 (comment)		✔️ view	✔️	provider not hosted on nuget.org
InterBase	#1014 (comment)		✔️ view	✔️ view

[MaceWindu]

Amazon Redshift
Tracked by #886

[MaceWindu]

IMPLEMENTED

Oracle using dotConnect for Oracle provider

[MaceWindu]

IMPLEMENTED

MS Access using ODBC provider

[MaceWindu]

Cassandra using DataStax ADO.NET provider
Tracked by #552

Note that it is a Nosql database and ADO.NET provider doesn't support all Cassandra functionality

[MaceWindu]

Sybase using ODBC
Tracked by #499

[MaceWindu]

Sybase SQL Anywhere
Tracked by #186

[MaceWindu]

IMPLEMENTED

Sybase ASE: DataAction AdoNetCore.AseClient (https://github.com/DataAction/AdoNetCore.AseClient)

[glenn-slayden]

Target a set of simple CSV files, 1 per RDBMS table, accessible in a (given) writeable file system directory (table name == filename), where the directory also contains one additional special text-file containing the DB schema (column names plus strong types for all tables) in a simple line-oriented or CSV text format.

See http://moin.delph-in.net/TsdbTop, for example.

I do realize it’s not SQL, but wouldn’t such a provider possibly also be useful as a simple minimal case for a LinqToDb provider skeleton?

[sdanyliv]

IMPLEMENTED
Connect to MySql via MySqlConnector

[tb-mtg]

The link below can help you setup a free testing environment for DB2 iSeries:

https://www.nicklitten.com/free-ibm-i-system-for-developers

[AlexandrSitdikov]

IMPLEMENTED

ClickHouse

#1796

[sdanyliv]

IMPLEMENTED

New Microsoft’s SqlClient when it become non-preview.
https://github.com/dotnet/SqlClient

#1895

[MaceWindu]

IMPLEMENTED + ODBC provider support improved

SAP HANA .net core provider support https://stackoverflow.com/a/56167626/1641529

Edit: blocked - SAP HANA Express SPS 04 wasn't released yet finally, as of 9/08/2019 they decided to release it

[JTrotta]

RQLITE.
https://github.com/rqlite/rqlite

[filippobottega]

OSQuery

[MaceWindu]

SAP/Sybase IQ #2040

[gamblen]

Ingres

WIP: #2910

[ComaCluster9981]

Snowflake https://www.snowflake.com/ , Cloud Data Platform (and DWH)
Provides a .Net driver
https://github.com/snowflakedb/snowflake-connector-net

Snowflake provides free trials $400/30 days - see "Start for Free" button top right on above home page

[MaceWindu]

@tb-mtg, iSeries driver maintained by 3rd party project, so better luck to ask for ODBC support there.

[sdanyliv]

CockroachDB, looks like it is Postgres compatible.
https://www.cockroachlabs.com/docs/stable/build-a-csharp-app-with-cockroachdb.html

[travbeamo]

Support for DB2iSeries using Odbc and/or OleDb:
See #2473 for details.

[gjvanvuuren]

An Azure Synapse provider for Microsoft Sql Azure

[filippobottega]

Support for OpenSQL
In SAP the access to the database is done using OpenSQL language, an extension of ABAP language used to access the db.
The idea could be to use linq2db to emit the OpenSQL embedded in a Function Module and let the user to create the emitted function module in a SAP package. Then linq2db could execute the query calling the function module through the SAP Connector for Microsoft .NET 3.0 . Linq2db could use the connector to read the table definitions from the ABAP Dictionary allowing the user to use them in the definition of queries written in .NET code.
Any better idea to extract data from SAP using linq2db?

[yallie]

PostgreSQL using a free edition of dotConnect for PostgreSQL data provider (for .NET 4.x support).

[sdanyliv]

@yallie, which benefits it gives over Npgsql?

[yallie]

@sdanyliv,

1. No dependencies, see Nuget
2. Npgsql 5.x has dropped support for the older versions of .NET framework

[pacohams]

any plans for Azure Cosmos DB?

[sdanyliv]

@nomada2, I don't think that Cosmos DB is relative to this library. It is not RDBMS but more like NoSQL database with some SQL support.

[mguinness]

While not strictly a RDBMS, Windows Search service allows for Querying the Index with Windows Search SQL Syntax and supports OleDb with connection string provider=Search.CollatorDSO;EXTENDED PROPERTIES="Application=Windows".

[pmatrosov]

YDB from Yandex (https://ydb.tech/)

[parasparmar]

If possible, @MaceWindu can you kindly look at Couchbase support for Linq2DB.
The documents to connect to it via ADO. NET are linked here.
Couchbase. NET SDK & documentation

[rrrevery]

There are many company and orgnization in China must use the database writen by China,such as Kingbase which is similar to postgresql,can you add support Kingbase to Linq2db

[igor-tkachev]

There are many company and orgnization in China must use the database writen by China,such as Kingbase which is similar to postgresql,can you add support Kingbase to Linq2db

Can you provide a link to relevant documentation?

[rrrevery]

There are many company and orgnization in China must use the database writen by China,such as Kingbase which is similar to postgresql,can you add support Kingbase to Linq2db

Can you provide a link to relevant documentation?

Their english offical site is https://www.kingbase.com.cn/en/
Their document site is https://help.kingbase.com.cn/v8/index.html ,I didn't find english version
I konw another c# orm support Kingbase,maybe you can refer to this repo https://github.com/dotnetcore/FreeSql/tree/master/Providers/FreeSql.Provider.KingbaseES

[GirusVirus]

How do I add InterBase to the list? this db has ADO.NET support. https://www.embarcadero.com/free-tools/ado-net-driver

[to11mtm]

Not necessarily a full-on new RDBMS, but it would be interesting to add TimescaleDb extensions for the Postgres provider.

It would however likely be primarily things like extra function impls and extra create table support rather than a full-on provider however (and may be better done as a separate add-in).