passsing large number of parameters

[=?Utf-8?B?Vmlua2k=?=]

Hello Everyone,

What will be the best way of passing large number of paramers from one
method to another so that I can insert them in the Database.

Thanks.

[=?Utf-8?B?U2VyZ2V5IFBvYmVyZXpvdnNraXk=?=]

Not sure how much is "large", but when I need to pass to a stored proc all
IDs user selected in a list, I usually construct a comma separated string and
pass it into a stored proc, and then split them inside the proc.

If you can provide more info, I will try to be more specific

"Vinki" wrote:

Hello Everyone,

What will be the best way of passing large number of paramers from one
method to another so that I can insert them in the Database.

Thanks.

[Jon Skeet [C# MVP]]

Vinki <Vi***@discussions.microsoft.comwrote:

What will be the best way of passing large number of paramers from one
method to another so that I can insert them in the Database.

Encapsulate the parameters into a separate type - then there's just one
object to pass around, and it's a lot easier to understand parameters
when they're accessed by name via properties than positionally.

--
Jon Skeet - <sk***@pobox.com>
http://www.pobox.com/~skeet Blog: http://www.msmvps.com/jon.skeet
If replying to the group, please do not mail me too

[Marc Gravell]

If you mean inside of .Net (rather than .Net -SQL) I'd probably
define the data in an entity class... the meaning of everything is
clear and you only need pass one object (or an array of like-typed
objects) around.

Marc

[=?Utf-8?B?Vmlua2k=?=]

Can you give me any example of encapsulating the parameters into a seperate
type.

Thanks.

"Jon Skeet [C# MVP]" wrote:

Vinki <Vi***@discussions.microsoft.comwrote:

What will be the best way of passing large number of paramers from one
method to another so that I can insert them in the Database.

Encapsulate the parameters into a separate type - then there's just one
object to pass around, and it's a lot easier to understand parameters
when they're accessed by name via properties than positionally.

--
Jon Skeet - <sk***@pobox.com>
http://www.pobox.com/~skeet Blog: http://www.msmvps.com/jon.skeet
If replying to the group, please do not mail me too

[Jon Skeet [C# MVP]]

Vinki <Vi***@discussions.microsoft.comwrote:

Can you give me any example of encapsulating the parameters into a seperate
type.

See http://pobox.com/~skeet/csharp/miscu...ermanager.html
for an example from my own library.

--
Jon Skeet - <sk***@pobox.com>
http://www.pobox.com/~skeet Blog: http://www.msmvps.com/jon.skeet
If replying to the group, please do not mail me too