On Wed, 30 Aug 2006 10:18:28 -0400, "David Stevenson" <[EMAIL PROTECTED]> said: > 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 sure does - I like the way you can have a fully functional security system, with password changing, forgotten password emailing and all that stuff literally within 10 minutes and using drag-and-drop controls. > 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. That's one big consideration ... I need to get some metrics on how well this might perform using SQL Server Express on the customers own server, using their 4Mbps ADSL. > > 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. It definitely makes things a lot simpler to do it on-site, my only concern would be performance. > 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. I like the ObjectDataSource, I wish VFP could bind to objects in fact! -- Alan Bourke [EMAIL PROTECTED] -- http://www.fastmail.fm - mmm... Fastmail... _______________________________________________ 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.
