Hi,
We are now using Adapter for .net6 with 5.10, and a few simple custom templates. We previously used adapter for netstandard2.1 with +5.7
We extended our DataAccessAdapter using a partial class (so not strictly a custom templates problem), and have used this override to date to add query hints certain queries:
protected override IRetrievalQuery CreateSelectDQ(QueryParameters parameters)
{
var result = base.CreateSelectDQ(parameters);
switch (AddQueryOption)
{
case QueryOption.OptimizeForUnknown:
result.Command.CommandText += @" OPTION (OPTIMIZE FOR UNKNOWN)";
break;
case QueryOption.Recompile:
result.Command.CommandText += @" OPTION (RECOMPILE)";
break;
}
return result;
}
After updating to 5.10, this is broken, as the CreateSelectDQ method no longer exists to override. Please advise how to update our code to continue to use this additional functionality.
Thanks
Simon
