Using table valued params with Entity Framework

Asked Jan 24 '22 at 15:16

Active Jan 24 '22 at 15:24

Viewed 43 times

Is there a way to use SQL Server table-valued parameters in Entity Framework in a way that doesn't require you to use a stored procedure or string-based queries like context.Database.ExecuteSqlCommandAsync("") ?

Something similar to Dapper where I can pass a DataTable and specify the user-defined type name to use. Probably must be some sort of overload of IEnumerable<>.Contains() or .Join() so that I can build a join in a generated query.

The goal is to stay with expression trees and don't mess with strings.

edited Jan 24 '22 at 15:24

marc_s

732,580
175
1,330
1,459

asked Jan 24 '22 at 15:16

UserControl

14,766
20
100
187

Not as far as I am aware, although you may be able to write some sort of extension to EF to do this – Charlieface Jan 24 '22 at 15:32
1

You can use Dapper and EF together. – David Browne - Microsoft Jan 25 '22 at 02:20

Using table valued params with Entity Framework

0 Answers0