how to access output values of Select instance in LINQ in a C# program

Question

I am new to writing Stored Procedure. So I wrote below procedure and want to access the output values in my program, hot to do it.

My Stored Procedure:

Create Procedure [dbo].[STP_ExecCarInDriver_SelectByCarCode]
@CarCode nchar(10)
As
Begin

SELECT DISTINCT
[MachineName]
,[FirstName]
,[LastName]
FROM [RoadTrs].[dbo].[ViewExecCarInDriver]
WHERE [CarCode]=@CarCode

End

and try with below code to instance to MachineName,FirstName and Last Name parameters:

var Results = rt.STP_ExecCarInDriver_SelectByCarCode(txtCarCode.Text);
string MachineName= Results(0).

but it doesn't work !

[This](http://stackoverflow.com/questions/1260952/how-to-execute-a-stored-procedure-from-c-sharp-program) may help. — Brian, Mar 08 '13 at 15:22
What is your `rt` object? Are you using LINQ to SQL? or what? How does C# know about your stored procedure? — Michael Dunlap, Mar 08 '13 at 15:23
Farzad M have you looked at this link perhaps this may help [How to Execute Stored Procedure from C#](http://stackoverflow.com/questions/1260952/how-to-execute-a-stored-procedure-from-c-sharp-program) — MethodMan, Mar 08 '13 at 15:27
No Brian I actually think that it's easier to format a link opposed to putting try `this` for example the OP may not know it's an actual link.. LOL — MethodMan, Mar 08 '13 at 15:30

score 1 · Answer 1 · answered Mar 08 '13 at 15:35

if you are using LinqtoSql i would advise against using the stored proceedure at all (they become a pain in the arse to manage imho)

instead use the data context to get the item

int carcode = 0; //input your code here

var ctx = new RoadTrsDataContext();
var item - ctx.ViewExecCarInDriver.Where(x=>x.CarCode == carcode).FirstOrDefault();
ctx.Dispose();

if(item!= null)
{
var name = item.FirstName;
}

score 0 · Answer 2 · answered Mar 08 '13 at 15:28

0

Use following:

        var Results = rt.STP_ExecCarInDriver_SelectByCarCode(txtCarCode.Text).FirstOrDefault();//Use .List() if query return more than one result.
        string MachineName = Results.MachineName;
        string FirstName = Results.FirstName;
        string LastName = Results.LastName;

answered Mar 08 '13 at 15:28

KS Tech

194
4

it is not work because don't have any .FirstOrDefault() function – Farzad M Mar 08 '13 at 16:30

how to access output values of Select instance in LINQ in a C# program

2 Answers2