How to get a dynamic stored procedure to return data by using LINQ?

Question

0.00/5 (No votes)

See more:

I have a dynamic stored procedure and use then LINQ to SQL then calss

ISingleResult

don't Generated

What I have tried:

this is a Stored Procedure :

alter  PROCEDURE	sp_selectFromTable_New @TableName [nvarchar](50)
				   ,@FieldsName [nvarchar](500)
				   ,@WhereCri [nvarchar](1000)
AS

	DECLARE	@SQL [nvarchar](1000) 
	set @SQL	='Select '+ @FieldsName+' from ' + @TableName	+ ' where @WhereCri_ '

	EXEC sp_executesql @SQL,N'@WhereCri_ nvarchar(50)',@WhereCri_=@WhereCri

and I pass it in DBml File in LINQ to SQL Class..

how can use it ?

Thank you
Best Regards

Posted 14-Sep-17 4:39am

ibrahim maher

Updated 14-Sep-17 7:24am

Add a Solution

Comments

Karthik_Mahalingam 15-Sep-17 0:06am

check this https://stackoverflow.com/a/14200824/1147428

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Prokofiy · Answer 1 · 2017-09-14T07:24:00

Solution 1

alter PROCEDURE sp_selectFromTable_New @TableName [nvarchar](50)
,@FieldsName [nvarchar](500)
,@WhereCri [nvarchar](1000)
AS

DECLARE @SQL [nvarchar](1000)
set @SQL ='Select '+ @FieldsName+' from ' + @TableName + ' where ' + @WhereCri

EXEC sp_executesql @SQL

Posted 14-Sep-17 7:24am

Prokofiy

Comments

ibrahim maher 14-Sep-17 17:14pm

where the Solution u are repeated the Question

How to get a dynamic stored procedure to return data by using LINQ?

1 solution

Solution 1

Add your solution here

Preview 0

How to get a dynamic stored procedure to return data by using LINQ?

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us