What's the most simple way to retrieve all data from a table and save it back in .NET 3.5?
- by zoman
I have a number of tables containing some basic (business related) mapping data.
What's the most simple way to load the data from those tables, then save the modified values back. (all data should be replaced in the tables)
An ORM is out of question as I would like to avoid creating domain objects for each table.
The actual editing of the data is not an issue. (it is exported into Excel where the data is edited, then the file is uploaded with the modified data)
The technology is .NET 3.5 (ASP.NET MVC) and SQL Server 2005.
Thanks.