I am in the process of writing a service application that will (or should depending on how this goes) allow users to perform CRUD operations on an external database.
The database only has two tables, there are no dependencies.
The service application is for populating two pages full of this data on each user's profile page. It will also allow users to maintain entries relating to themselves.
I have run into a problem concerning actually connecting to the new database in a dynamic way.
I could use Fluent NHibernate, as that is what I am most familiar with, but it seems like overkill.
I have considered EF, but from what I have heard, the EF that comes with .NET 3.5 sucks.
Lastly I dont have any experience with BCS, so I am not sure of its viability as an option.
Does anyone here have any experience doing something similar with other technology? Or are there options I havent considered?