[jira] [Created] (IGNITE-7636) .NET: SQL Client

["Pavel Tupitsyn (JIRA)" <ji...@apache.org>]

Pavel Tupitsyn created IGNITE-7636:
--------------------------------------

             Summary: .NET: SQL Client
                 Key: IGNITE-7636
                 URL: https://issues.apache.org/jira/browse/IGNITE-7636
             Project: Ignite
          Issue Type: Improvement
          Components: platforms
            Reporter: Pavel Tupitsyn


Implement Ignite SQL Client library (use Ignite as SQL database).

* Should be based on Thin Client SQL API
* Inherit classes like {{System.Data.Common.DbConnection}}, {{DbCommand}}, etc. See SQL clients for MySQL, Postgres, etc: https://blogs.msdn.microsoft.com/dotnet/2016/11/09/net-core-data-access/
* Separate Assembly (targeting .NET Standard 2.0), separate NuGet package

Usage example:
{code}
using (var conn = new IgniteSqlConnection("Host=myserver;Port=10800"))
{
    conn.Open();
    using (var cmd = new IgniteSqlCommand())
    {
        cmd.Connection = conn;

        cmd.CommandText = "SELECT name FROM artists";
        using (var reader = cmd.ExecuteReader())
        {
            while (reader.Read())
            {
                Console.WriteLine(reader.GetString(0));
            }
        }
    }
}
{code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)