I am trying to figure out how to enable direct SQL queries when using the Web API Middle Tier server. I have seen This KB article, but it doesn't appear to have been updated to account for the Web API.
Thank you
WebAPI Middle Tier Direct SQL
Show previous comments
(0)
Comments
(0)
Sign in to comment on this post
Answers approved by DevExpress Support
Hello Eldon,
You can use the MiddleTierSerializableObjectLayer constructor to specify the AllowICommandChannelDoWithSecurityContext option value. Find the following code in the WebApo.Startup.cs file:
C#services.AddScoped<IMiddleTierSerializableObjectLayer>(sp => {
var dataLayerAccessor = sp.GetRequiredService<MiddleTierDataLayerAccessor>();
var dataServerSecurity = sp.GetRequiredService<IDataServerSecurity>();
ISelectDataSecurity selectDataSecurity = dataServerSecurity.CreateSelectDataSecurity();
Session session = new UnitOfWork(dataLayerAccessor.GetDataLayer(sp));
return new MiddleTierSerializableObjectLayer(session, () => selectDataSecurity, false);
});
and change it as shown below:
C#services.AddScoped<IMiddleTierSerializableObjectLayer>(sp => {
var dataLayerAccessor = sp.GetRequiredService<MiddleTierDataLayerAccessor>();
var dataServerSecurity = sp.GetRequiredService<IDataServerSecurity>();
ISelectDataSecurity selectDataSecurity = dataServerSecurity.CreateSelectDataSecurity();
Session session = new UnitOfWork(dataLayerAccessor.GetDataLayer(sp));
return new MiddleTierSerializableObjectLayer(session, () => selectDataSecurity, true);
});
Other Answers
Hello,
In new versions of XAF v22.1, you can use an option in DataServerSecurity settings to enable direct SQL queries.
Check this help topic: Enable Direct SQL Queries in the Middle-Tier Server (ASP.NET Core Web API, .NET 6+).