String interpolation inside a formattable string in C#
I am in the process of replacing Dapper with EF Core in a project. Specifically using the new Database.SqlQuery and Database.ExecuteSql functionality with EF Core. I like how they use FormattableString to handle SQL parameters.
Can using “AsQueryable()” in EF Core consume more RAM than pure SQL query?
I’m using DevExpress DataGrid in my web app. This DataGrid has sorting and filtering enabled. When the user tries to sort and filter columns, some parameters are send to the Web API. Suppose the table of the database contains 15 million records.
Can using “AsQuerable()” in EF Core consume more RAM than pure SQL query?
I’m using DevExpress DataGrid in my web app. This DataGrid has sorting and filtering enabled. When the user tries to sort and filter columns, some parameters are send to the WEB API. Suppose the table of the database contains 15 million records.
There are two options for API calculations: