Terry,
>I am also considering using VistaDB. I will use VistaDB to store proprietary data for use in lookup tables and SQL Server to store user entered data. I know you consider stored precedures a "best practice." Why is it better than dynamic SQL?
It becomes more of an issue when you want to crate an application that accesses multiple back ends. Although many queries and CRUD statements can be the same for different back ends, the more complex SQL statements can be different. Using stored procedures puts this database-specific code in the database. In addition, it's much easier to use a database tool such as SQL Server Enterprise Manager to create SQL statements rather than concatenating strings in your C# or VB .NET code--these strings are evaluated at run time, whereas stored procedures are evaluated by a database tool at design time.
Best Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com