SQL Parameter on c# context

Question

I'm trying to add a parameter to this sql query to be executed against an Entity Framework context. I'm having trouble figuring out the syntax. Here is what I have so far:

db.Participantes.SqlQuery("SELECT participanteID, nome, email, telefone, unidadeCE, voucherNumero, dataCadastro," +
                          "(SELECT TOP(1) tipo FROM ParticipanteResultado pr WHERE p.participanteID = pr.participanteID ORDER BY quantidadeValidas DESC) AS tipo" +
                          "FROM Participante p WHERE p.unidadeCE = @param", new { param = unidade }).ToList()

Can you elaborate on how your code "doesn't work"? What were you expecting, and what actually happened? If you got an exception, post the line it occurred on and the exception details. — gunr2171
– gunr2171, Commented Dec 11, 2014 at 17:51
What i meant is i don't know how to add the parameter, i know it must be a object but i never used this kind before — Ariel
– Ariel, Commented Dec 11, 2014 at 18:00

dustyhoppe · Accepted Answer · 2014-12-11 18:04:16Z

3

Here is what you are looking for as for as adding parameters to your EF query.

db.SqlQuery<TEntity>("SELECT * FROM Table WHERE Column = @ParamName", 
               new SqlParameter("ParamName", parameterValue)).ToList();

edited Dec 11, 2014 at 18:04

answered Dec 11, 2014 at 17:57

dustyhoppe

1,82317 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ariel Over a year ago

Thanks buddy, that's exactly what i was looking for ! Just don't know why the down votes :/

Collectives™ on Stack Overflow

SQL Parameter on c# context

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related