.NET Data Provider under .NET Core 3.1

[isential]

Does SQLBase support .NET Data Provider under .Net Core 3.1?

I have created a test project for Framework 4.8 where I connect to SQLBase via .NET Data Provider. For this I have included Gupta.SQLBase.Data.dll as a reference.

I have created the same program for .Net Core 3.1. The program can be compiled, but I get the following exception when connecting:

{"Could not load file or assembly 'System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'. The system can't find the specified file.":"System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"} System.Exception {System.IO.FileNotFoundException}

Here is the sample code:

Code: Select all

using Gupta.SQLBase.Data;
using System;

namespace Bsp_05_ConnectSQLBaseDotNetCoreAdoDotNet
{
	class Program
	{
		static void Main(string[] args)
		{
			try
			{
				string cs = "Database=TST; USERNAME=sysadm; PASSWORD=xyz; TRANSPORT=TCP; HOSTNAME=192.168.70.202; PORT=2155";
				var conn = new SQLBaseConnection(cs);
				conn.Open(); // The exception is triggered here.
				conn.Close();
			}
			catch (Exception e)
			{
				Console.WriteLine(e.ToString());
			}
		}
	}
}

I use here Gupta.SQLBase.Data.dll from the newest version 12.2 of SQLBase.

ODBC and OLEDB work, but I want to use the .Net Data Provider for different reasons, but I don't succeed under .Net Core 3.1.

What is the problem and how can it be solved?

Thanks in advance!

René

[isential]

While searching the SQLBase directories I came across the DLL "Gupta.SQLBase.Data.Standard.dll". Now I've inserted it as a reference and it seems to work.

However, I could not find anything about it in the SQLBase documentation. Where can I read more about it?

[Steve Leighton]

.
SQLBase manuals here: [url]https://samples.tdcommunity.net/index.p ... ase_Books/[/url]
and then try Chapter 7 - .Net data provider in 'SQLBase Connecting to SQLBase.pdf' from v11.7 onwards

[isential]

OK, thanks a lot! As I read, the support came only with the latest version 12.2. In the manual "SQLBase Connecting to SQLBase.pdf" there is indeed on page 66 the section ".NET Core/Standard Implementation" which explains this.

Now we hope that the implementation is running stable and that EF will be released soon and above all without any major bugs.

Best regards

René

[skate17]

mira ese link ahi viene como conectarte con C# .net 8

(look at that link there it comes how to connect with C# .net 8)

[isential]

¡Pero si el problema se solucionó hace años! Además der que SQLBase todavía no soporta EF así que se descalifica para nuevos proyectos.