Home
Help
Register
Log in

Search

 
   Active Threads  

You are here: Home > LLBLGen Pro > Designer> cannot connect to MySql Server from the designer
 

Pages: 1
Designer
cannot connect to MySql Server from the designer
Page:1/1 

  Print all messages in this thread  
Poster Message
ionut
User



Location:

Joined on:
28-May-2019 01:16:23
Posted:
13 posts
# Posted on: 09-May-2020 23:30:29.  
Hello all,

I want to connect to MySQL Database and I noticed that is a potential issue with the driver that is provided by DevArt:

- In the documentation of LLBL it is specified: "MySql driver using DevArt's MySqlDirect client (the express version is OK)"
source:
1) https://www.llblgen.com/Documentation/5.6/Designer/Concepts/DatabaseDrivers.htm
2) https://www.llblgen.com/Documentation/5.6/Designer/Databases/mysql.htm

- in the documentation of the DevArt the express edition does not support .net core, but only for .net Full framework support.

source:
1)https://www.devart.com/dotconnect/mysql/editions.html
2)https://www.devart.com/dotconnect/mysql/docs/LicensingStandard.html

According to the test that was done it is possible to use LLBLGen Pro Designer with MySQL Server. However, after the project is generated and then running and compiling an application in .net core I had this exception:

"Devart.Common.LicenseException: 'Feature is not supported. This error is thrown by Devart .NET Standard assemblies if license key validation fails. Possible reasons: 1. License key is not found, refer to the "Licensing .NET Standard (.NET Core) Projects" article in the product documentation. 2. Your product edition (the key was generated for) doesn't support the feature you are trying to use, refer to the editions matrix. 3. Your key is outdated for using the current product version, renew the license key in the Customer Portal.':

The code that throwed the exception was compiled with this code:

SD.LLBLGen.Pro.ORMSupportClasses.RuntimeConfiguration.ConfigureDQE<SD.LLBLGen.Pro.DQE.MySql.MySqlDQEConfiguration>(
                c => c.AddDbProviderFactory(typeof(Devart.Data.MySql.MySqlProviderFactory)));

            var connstring = "User Id=****;Password=***;Host=***;Port=3306;Database=***;";
            var da = new test2.DatabaseSpecific.DataAccessAdapter(connstring);
            //da.CatalogNameUsageSetting = SD.LLBLGen.Pro.ORMSupportClasses.CatalogNameUsage.Clear;

            var orders = new test2.HelperClasses.EntityCollection<test2.EntityClasses.CountryEntity>();
            da.FetchEntityCollection(orders, null);

Considering the above, it looks like the documentation from LLBL Gen Pro where it is specified that "the express version is OK" works only for .Net Full Framework. In .net core you need the standard edition.

Please let me know if the observation is correct and if you consider that it is required the standard license instead of the express(free) from DevArt.

Thank you,
Ionut
Ionut Afloarei
http://bobyclock.com
 
Top
Otis
LLBLGen Pro Team



Location:
The Hague, The Netherlands
Joined on:
17-Aug-2003 18:00:36
Posted:
38090 posts
# Posted on: 10-May-2020 10:35:13.  
The express one is sufficient for using the designer, when using the generated code on .net core you need to have the standard version at least indeed. We didn't state that as the devart documentation/site info is explicitly stating that already. We stated that the express version is sufficient for the designer because it might be the people using the designer aren't the people using the generated code and they then would buy too many licenses for the mysql connector.

We could add a line to the docs stating the mysql generated code requires a standard license from devart if the code is ran on netcore.


Frans Bouma
LLBLGen Pro / ORM Profiler Lead Developer | Blog | Twitter
 
Top
ionut
User



Location:

Joined on:
28-May-2019 01:16:23
Posted:
13 posts
# Posted on: 11-May-2020 14:34:01.  
Thank you very much for the confirmation. We will buy the license from DevArt.
Ionut Afloarei
http://bobyclock.com
 
Top
Pages: 1  


Powered by HnD ©2002-2007 Solutions Design
HnD uses LLBLGen Pro

Version: 2.1.12172008 Final.