c# - The function has a parameter that has a data type 'table type' which is not supported for the target .NET Framework. The function was excluded -
i trying pass table valued parameters through entity framework. know when imported stored procedure in entity framework gave me warning that
"warning 1 error 6005: function has parameter has data type 'table type' not supported target entity framework version. function excluded."
but still stored procedure imported , worked fine. did in vs2013 , entity framework 5.0. trying same in team foundation server in vs2012. shows me similar warning difference like
the function has parameter has data type 'table type' not supported target .net framework version. function excluded.
and time particular stored procedure not imported , not listed. can explain me why happening , how can work around it??
i have not resolved issue in vs2012 worked around using comma separated values instead of table valued parameters stored procedure , created split string function insert values table reference link http://stackoverflow.com/questions/14811316/separate-comma-separated-values-and-store-in-table-in-sql-server
still know how pass table valued parameters vs2012.