Hi there,

I'm working on using my Sybase 16 LLBLGen project on .NET Core/Standard 2.1.

I've encountered an issue where the ORMSupportClasses attempts to find the DbProviderFactory for the Sybase client driver and fails as Core doesn't use the machine.config to setup the DbProviderFactories.

ORMConfigurationException: No DbProviderFactory has been configured for this DQE. You have to use the DQE configuration system to register at least one DbProviderFactory.

SD.LLBLGen.Pro.ORMSupportClasses.DbProviderFactoryInfo.get_FactoryToUse()
SD.LLBLGen.Pro.ORMSupportClasses.DbProviderFactoryInfo.get_FactoryForReflection()
SD.LLBLGen.Pro.ORMSupportClasses.DbProviderFactoryInfo.InitializeSpecificDbTypeCache()
SD.LLBLGen.Pro.ORMSupportClasses.DbProviderFactoryInfo.SetDbProviderFactoryParameterData(List<ValuePair<string, string>> dbProviderFactoryInvariantNamesWithEnumTypeNames, string dbProviderSpecificEnumTypePropertyName)
SD.LLBLGen.Pro.ORMSupportClasses.DbProviderFactoryInfo.SetDbProviderFactoryParameterData(string dbProviderFactoryInvariantName, string dbProviderSpecificEnumTypeName, string dbProviderSpecificEnumTypePropertyName)
SD.LLBLGen.Pro.DQE.SybaseAse.SybaseAseSpecificCreator.SetDbProviderFactoryParameterData(string dbProviderFactoryInvariantName, string dbProviderSpecificEnumTypeName, string dbProviderSpecificEnumTypePropertyName) in SybaseAseSpecificCreator.cs
94. _dbProviderFactoryInfo.SetDbProviderFactoryParameterData(dbProviderFactoryInvariantName, dbProviderSpecificEnumTypeName, dbProviderSpecificEnumTypePropertyName);
SD.LLBLGen.Pro.DQE.SybaseAse.DynamicQueryEngine..cctor() in DynamicQueryEngine.cs
76. SybaseAseSpecificCreator.SetDbProviderFactoryParameterData("Sybase.Data.AseClient", "Sybase.Data.AseClient.AseDbType", "AseDbType");

I've tried setting the DbProviderFactory in Program.cs with no luck. Also given there's no DQEConfiguration for Sybase, I can't use RuntimeConfiguration.ConfigureDQE. Is there any workaround for this?

DbProviderFactories.RegisterFactory("Sybase.Data.AseClient", Sybase.Data.AseClient.AseClientFactory.Instance);

Thanks, Dean

Sybase isn't supported anymore, we open sourced the DQE on github and have no plans to update it/keep it updated as well. See https://github.com/SolutionsDesign/LLBLGenProSybaseASE

If you're working with a .net framework ADO.NET provider, you can add the factory to the machine.config file of your PC (it's in the C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config folder), or in the .config file of your application (app.config or web.config. See the llblgen pro designer's .config file for an example how to do that (it's commented out there ).

Thanks for your response. Just posting to update that I've managed to get this working in .NET8 with Sybase.

Dean wrote:

Thanks for your response. Just posting to update that I've managed to get this working in .NET8 with Sybase.

Great!