Insert/Update into Table with many fields.

[C# Programming]

Hello,

I have a question about the best way to Insert/Update a table that has around 117 fields.

I can create my own Insert/Update commands or use the CommandBuilder. Both of those need Parameters setup, but that's a lot of fields to setup.

Maybe I am missing something and there is a solution that I am not seeing.

Would it be easier to have a foreach loop and create the Insert/Update commands along with the parameters?

Any thoughts?

Thanks,
Chuck