Gustav Brock
gustav at cactus.dk
Sun Sep 11 06:01:11 CDT 2011
Hi Shamil I did consider that but funding will never be fat. The organisation counts only a few hundred members, and as the backends are only 150 MB I will face no scaling issue. It is exactly what LS is targeted for, so for this reason alone I will do the test. It may, of course, prove unsatisfactory in some way and if so I will for sure choose the WinForms route which works very well for me. We have one client where I have used the click-once deployment method and it works very well. Even the smallest modification, which I can code in minutes, gets deployed at once as it just requires a few default clicks and a password to the clients local FTP server and it has been published. It can't be easier and it just works. /gustav >>> shamil at smsconsulting.spb.ru 11-09-2011 10:49 >>> Hi Gustav -- <<< However, the app contains nothing fancy - it's really a typical Line Of Business app taking care of everything a small organization needs - exactly what LightSwitch is for. >>> Why then not make it (3/n-tiered) WinForms application, and when it will be really needed and so there will be funding for that UI work then make a "fancy" - SilverLight, - MS LightSwitch, - Windows Phone 7, - WPF, - ASP.NET, - "whatever else will be hot that time" ... user interface? IMO/in my experience developing WinForms apps with MS SQL 2008 FE is several times/a matter of magnitude RAD-der than developing MS Access apps - and I mean solid professional application development not "power-users toys". And stability/flexibility/"multi-threadability"/scalability/... of 3/n-tiered .NET applications is practically unlimited... And you can develop 32-bit (WinForms) .NET apps and run them on 64 bit systems with MS Access or MS SQL backend - just use corflags.exe (http://msdn.microsoft.com/en-us/library/ms164699(v=vs.80).aspx) Thank you. -- Shamil -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Gustav Brock Sent: 11 ???????? 2011 ?. 11:54 To: dba-vb at databaseadvisors.com Subject: Re: [dba-VB] Rapid Application Development: LightSwitch 2011 (no beta) Hi John Not currently, but we do have a client with a heavily customized Access 97 application which we delivered summer 1999 and have expanded in steps through the years. This is for an organisation of dealers of agricultural machinery (combined harvesters, etc.) and as you can imagine, age is showing. It's not a question of reliability as the app has ran with zero errors or breakdowns. But new desktops we run with Windows 7 32-bit to avoid trouble with A97 and 64-bit OS, web interface is missing, etc. The office is only five people so budget is if not tight then limited and, as the app (three frontends actually with two backends for data and pictures) runs the full business, a replacement must be efficient and predictable to develop. However, the app contains nothing fancy - it's really a typical Line Of Business app taking care of everything a small organisation needs - exactly what LightSwitch is for. So my plan is to model an introductory LS app to demonstrate how a single task could be performed and see if the client likes it. Then move on with a SQL Server 2008 backend (already running on their SBS). If you should ask, we have no intention to move the app to Access 2010. I regard Access as a dead end for developers and the lack of a web interface other than SharePoint is a show-stopper. /gustav >>> jwcolby at colbyconsulting.com 11-09-2011 01:30 >>> Are you using this in production or even heading there? John W. Colby www.ColbyConsulting.com On 9/10/2011 4:36 PM, Gustav Brock wrote: > Hi John > > I don't know but I guess it has improved. > > /gustav > > >>>> jwcolby at colbyconsulting.com 10-09-2011 21:26>>> > How is lightswitch doing in the area of efficiency? The last time I looked at it the trips to sql server bordered on ludicrous. > > John W. Colby > www.ColbyConsulting.com