Alan, If you're going to go with ASP.NET 2.0, then it makes sense to use the SQL Express 2005 that is free and integrates tightly with ASP.NET 2.0 security and login system. It also has very tight integration in the area of smart caching of queries -- where SQL 2005 returns data from cache unless something has actually changed in the table, as opposed to just timeout-based caching in ASP.NET 1.1.
Of course, if your database is going to be very large, you might need a full version of SQL Server and then the equation changes on how you assess technology vs expense. And lastly, if the web hosting is done on-site, you can of course use the OLE-DB VFP driver from ASP.NET to read-write directly to the VFP tables. A good approach is to use a tiered design with objects talking to the backend and those objects accessed via the ObjectDataSource class, which integrates very well with GridView, DetailsView and FormView. With a tiered design, you can write initially to VFP tables and later change just that part of the code to instead access a backend database if you ever move the main app off of VFP tables, or if you move from internal hosting to external. Sounds like a fun project! David Stevenson -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alan Bourke Sent: Tuesday, August 29, 2006 3:54 PM To: [EMAIL PROTECTED] Subject: Re: Advice needed on web interface. Thanks for your input folks. I'd rather not go down the LAMP route as there is just too much learning curve there for me for this project. I can already handle C# and MSSQL and have found designing sites in VS2005 with ASP.NET 2 intuitive to someone coming from a purely fat client background, so that's why I was looking at that avenue. Hmmmm ... need to think about this one LOL. -- Alan Bourke [EMAIL PROTECTED] -- http://www.fastmail.fm - The way an email service should be [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
