Typed SqlParameter's in Entity Framework

Question

I want to change the following use of SqlParameter into a more typed version

private static void Update(int id, string lname)
{
  new RememberEntities().ExecuteStoreCommand(
    @"    UPDATE Users
          SET lname = @lname 
          WHERE Id = @id",
    new SqlParameter("lname", lname), new SqlParameter("id", id));
}

For example, I want to be able to write something a long the lines of:

private static void Update(int id, string lname)
{
  new RememberEntities().ExecuteStoreCommand(
    @"    UPDATE Users
          SET lname = @lname 
          WHERE Id = @id",
    new SqlParameterString("lname", lname), new SqlParameterInt("id", id));
}

Where the second parameter to SqlParameterString() would take a string and an int in the case of SqlParameterInt(). I've tried creating my own by subclassing SqlParameter, alas, it is sealed so no luck there.

I was wondering what is the recommended EF apprach?

oryol · Accepted Answer · 2011-03-13 20:28:46Z

2

You can create typed factory methods and use only them, but you really can't avoid using SqlParameter constructor directly (you'll have this problem even if SqlParameter would be not sealed, you can only create your own wrapper method in such case).

answered Mar 13, 2011 at 20:28

oryol

5,2582 gold badges25 silver badges18 bronze badges

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

1 Comment

Carlo V. Dango Over a year ago

Yes you are correct, factory methods could do the trick. I was hoping for a better alternative :)

Jeremy · Accepted Answer · 2011-03-13 20:41:07Z

1

You could use a stored procedure (that returns a scalar value) then using EF 4.0 you can add a 'Function Import' and then you can execute the stored procedure like any C# function.

answered Mar 13, 2011 at 20:41

Jeremy

3,9614 gold badges37 silver badges42 bronze badges

1 Comment

Carlo V. Dango Over a year ago

Good idea, although I loathe stored procedures :-)

Collectives™ on Stack Overflow

Typed SqlParameter's in Entity Framework

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related