>Hi
>
>I wish to design my .NET app to be portable to multiple databases such as MYSQL, Oracle, MSSQL
>
>May I know which of the following strategies is best in terms of flexibility and ease of delivering maintenance updates to clients:
>
>1. Use Store Procedures
>2. Use Views
>3. Use SQL stored in some user defined tables with following fields
> a. DB_Type
> b. SQL_ID
> c. SQL Command
>
>Your advice much appreciated.
>
>Best Regards
There isn't a consensus on how to go between developers. IMHO I would go with Linq Entity Framework and wouldn't bother much how it is implemented at storage level.
Cetin