Do you need to dynamically construct instances of the Entity Framework-generated Model class by supplying the table name as a parameter? (Model generated in DB first approach and using EF 6.0)...like, ...// Input Param
string tableName
// Context always same
DBContext dbContext= new DBContext();
//Need to create object query dynamically by pass...
On SQL Server, I have a table-valued function....CREATE FUNCTION [dbo].[FStatusDepo]
(
@ProvozID int, @ZonaID int NULL, @minutesWarning int
)
RETURNS TABLE
AS
RETURN
(
SELECT
q.[DepoID]
,SUM(CASE WHEN v.Vjezd IS NOT NULL AND datediff(mi, v.Vjezd, GETDATE())>@minutesWarning THEN 1 ELSE 0 END) AS VjezduPoLhute
,SUM(CASE ...
I can make an invoke expression using SQL functions, as shown below....var likeMethod = typeof(DbFunctionsExtensions).GetMethod("Like", new[] { typeof(DbFunctions), typeof(string), typeof(string) });
Expression.Call(null, likeMethod, Expression.Constant(EF.Functions), searchKeyExpression, Expression.Constant($"%{filter.Value}%"));
...The only thin...
