Table-Valued Parameters support
TVP support for stored procedures
To perform Bulk save operations using the stored procedures that accept SQL table types as the parameter in SQL08. The EDMX has to support the custom table types to have the function import operation for executing these stored procedures.
This is the must feature for EF..
Sam C commented
I couldn't wait for "official" support, so I put together an extension that makes this kinda sorta easy to use: http://misterunconditional.com/tvpextensions/.
Let me know if this is useful and/or if I can improve it in any way.
I can’t imagine why it is so hard to implement such simple future? This future is available for about 10 years in SQL Server and it is the only way that can help to improve performance in many situations. I understand that MS thinks that everyone only uses table mappings but it appears that stored procedures are still in good shape.
Al Cole commented
Please please implement this feature
Eric Vaughan commented
please implement this feature
If EF can support TVP, we will be able to take advantage of this cool feature in sql server.
Feature needed. Please reconsider your priorities.. its pushing people away from EF and over to nHibernate
Greg Kwiatkowski commented
It would give a great benefit to we developer users and can be used to help speed up queries. Our old homebuilt model had support for them and it made our system fast. Please add support for them, lest we be relegated to doing some queries in a foreach.
Mohiyuddin Kanakkayil commented
plz add this feature
Please do it! commented
EF is a great tool until it comes to stored procs using TVPs. How is this not in the pipeline for the next version of EF?
I need that featere asap! Thank you!
Tim Shaffer commented
This feature is URGENTLY NEEDED for our MVC4 EF5 - Provider Portal.
I am developing a portal system for the medical community which needs to be completed in the second quarter of 2014.
Please help by supporting table-valued parameters in entity framework for SQL 2012.
Phil Taffet commented
EF is a non-starter for me until it does support TVPs.
Chuck Bevitt commented
Have to have this feature before I can let go of SqlClient.
Eric Butler commented
Support for Table Value Parameters is a must-have!
Seyyed Hossein Razzaghi commented
please support for Load data from UDF in User Define type.
Oscar Garcia commented
Please evaluate the support for User defined table types on Entity Framework.
C'mon guys, nearly 3 years and still no support?
Daniel Kress commented
This would be nice and useful if supported in L2E queries. We got some places where we process potentially big lists in multiple steps and in the end do some result select for the collected Guids.
Guid bigIDList = ...; // Usually around 50 but sometimes more than 100,000 IDs
return ctx.Addresses.Where(x => bigIDList.Contains(x.ID)).ToList();
I need that! release it as quick as possible