Data Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Up until now I have been using OR Mapping tools for my database access. I
liked this approach because with one line of code I could bind my form fields
to my objects and then persist them. The SQL code for update and insert was
generated instrinsically.

Now I need to use more 'mainstream' methods of data manipulation but am
becoming a little frustrated. If i wish to insert some data submitted by a
form, I need to append the contents of each form field as a parameter to
execute the stored procedure. Not to mention having to write the insert SQL
for the stored procedure. I find this tedious and the code can be quite long
when there are say 30 form fields that need to be inserted or updated.

My question is, is there are way to perform insert, update or deletes
without have to write any (or at least limited) sql? Or are there any
methods that reduce the amount of code to retrieve form field contents and do
an update? Ideally I would like to use reflection to map beween my form
fields and the correct column in the table. Is this possible? Am I missing
something obvious?
 
Rufus,

It has it limitations (max 100 datafields, the same as with the designer no
joined tables etc etc). For the rest is works mostly fine (when you have
some more extended problems you would have to do it yourself). However from
what I read in your message will it probably fit on at least 80%.

http://msdn.microsoft.com/library/d...temdataoledboledbcommandbuilderclasstopic.asp

It is there as well as SQL, Oracle, ODBCcommandbuilder.

I hope this helps,

Cor
 
Back
Top