What is the best way to switch from the default System.Data.SqlClient to Microsoft.Data.SqlClient?

For both framework and core, v5.11.

I got it working by overriding the SqlServerSpecificCreator like below but its a bit more involved than I expected so I'm wondering if there is something I'm missing:

using System.Data;
using System.Data.Common;
using System.IO;
using AQD.Helpers;
using Microsoft.Data.SqlClient;
using SD.LLBLGen.Pro.DQE.SqlServer;

namespace AQD.Model.SqlServer
{
  class AqdSqlServerSpecificCreator : SqlServerSpecificCreator
  {
    /// <inheritdoc />
    public override DbProviderFactory FactoryToUse => SqlClientFactory.Instance ?? base.FactoryToUse;

    /// <inheritdoc />
    protected override void SetParameterType(DbParameter parameter, string parameterType)
    {
      var sqlDbType = GeneralHelper.TryStringToEnum<SqlDbType>(parameterType);
      if (sqlDbType == null)
        base.SetParameterType(parameter, parameterType);
      else
        ((SqlParameter)parameter).SqlDbType = sqlDbType.Value;
    }
  }
}

Specify the factory in the RuntimeConfiguration object. You can also use that on .net framework, see https://www.llblgen.com/Documentation/5.11/LLBLGen%20Pro%20RTF/Using%20the%20generated%20code/gencode_runtimeconfiguration.htm#dbproviderfactory

The factory you specify there is overwriting the factory obtained from the config file/machine.config.

Thanks for that. I had originally hoped it would be as easy as setting the providerName in the config connection string. I will next look at how I can do that.

As an aside Is there any easy way to search the documentation for a word or phrase? Best I could do to find that link was googling site: https://www.llblgen.com/Documentation "Microsoft.Data.SqlClient"

TomDog wrote:

Thanks for that. I had originally hoped it would be as easy as setting the providerName in the config connection string. I will next look at how I can do that.

As an aside Is there any easy way to search the documentation for a word or phrase? Best I could do to find that link was googling site: https://www.llblgen.com/Documentation "Microsoft.Data.SqlClient"

The documentation has a search functionality which should work but I see anything with a '.' doesn't work... Searching for Microsoft SqlCient does work tho...

Otis wrote:

The documentation has a search functionality which should work but I see anything with a '.' doesn't work... Searching for Microsoft SqlCient does work tho...

You mean Microsoft SqlClient

mmmaaayyyybee