Hi!

Im looking for the easiest and quickest way possible to add Create Read Update Delete functionality to a SQL Server Express 2005 database through a winforms or webforms gui.

Right now we have 3 tables,

Person

Role

Department


And we need a quick and good way to admin these three tables. We are working in .NET 2.0. The problem is that the tables are joined, and for example, the code should handle constraint errors like if I try and delete a department which has persons attached to it.

I know the Designer is pretty good at generating code because writing CRUD procedures is extremly tedious and boring.

Is this something .net developer studio is capable of, or should we look else where?

I have worked a bit with dev studio in this matter, and it works great if there is only one table involved. As soon as I add constraints, then it doesn't work anymore.

kind regards
Henrik