using Angular QueryBuilder.getSqlFromRules() in the backend with System.Linq.Dynamic.Core (EF core 3.1)

Question

I tried using the output of angular queryBuilder.getSqlFromRules() on the backend with System.Linq.Dynamic.Core (EF core 3.1) and I got a Syntax error Exception.

Dow you have any guidance to assist me use the client side generated SQL with EF core 3.1 or is this use case not supported.

Madhan Venkateshan · Accepted Answer

Hi EMOVON UWADIA, 
 
Good day to you. 
 
You can use ‘FromSqlRaw’ method from ‘Microsoft.EntityFrameworkCore’ to execute sql query generated using query builder. Please refer the below code snippets and sample link. 
 
WeatherForecastController.cs 




[HttpGet] 
        public IEnumerable<Publisher> Get(string sqlRule) 
        { 
            using (var _context = new BookStoresDBContext()) 
            { 
                if (sqlRule != null) 
                { 
                    return _context.Publishers.FromSqlRaw("SELECT * FROM Publishers WHERE " + sqlRule).ToList(); 
                } else 
                { 
                    return _context.Publishers.ToList(); 
                } 
            } 
             
        } 
 
 
Sample link: https://stackblitz.com/edit/angular-rg6wth?file=app.component.ts 
 
Service link: https://www.syncfusion.com/downloads/support/forum/155095/ze/EFCoreSample1966111367 
 
Regards, 
Madhan V