my name is Laurentz Tonniau a new LightSwitch blogger in town! I’m a LOB developer at the firm Firmware :). I normaly speak and write Dutch so don’t mind my English spelling mistakes. When I started there almost 3 years ago, they developed all there applications in MS Access with SQL Server as back-end. Most of our applications we develop are ERP , CRM or BI custom made for SMEs in Belgium.
In my first year of work I learned a lot about business processes and how to translate business requirements into a working program. So I used the MS Access tool every day. But I didn’t like the IDE because it feels a bit “aged”, I could compare it to Visual Studio because that was THE tool we used at school. So I started a quest to find the perfect tool to create business applications. I started looking at WPF and tried it for a wile but the development time was way to high and finding the best technology for every layer frustrated me! So we are now in the summer of 2011 and look what I found: LightSwitch 2011! I tried it and fell in love…
In the time that passed since then I already created 3 ERP systems with it. My first application, where I went all in on LightSwitch was a project management application with time registrations and a invoice module. Some weeks ago I update the program to LightSwitch 2012 and used the HTML 5 client for time registrations, how cool is that!
My second one is a ERP program for a outlet store, they need a way to easily input new articles and sell them. I heard the word “easily” so LightSwitch came to the rescue!
My last one was the biggest, I had to create a business application for a manufacturer of dessert cups with all the modules of a mature ERP system from order to delivery. There is also a link to 4 weighing scales in the production where people can enter a recipe number and the scales tells them what to weigh and how much very cool stuff! When I need some calculation power I call my Stored procedures and the job gets done within a second, this is handy to finish a production where there are a lot of ProductStockMovements to create. Tracing is an other important requirement for a food company, here it’s possible to find all pallets (with cups on them) that are produced with a certain product. All you have to do is fill in the supplier reference of that product and you are good to go. So now that the application has been live for over a year I can proudly say that I (1 developer) created this custom application from the ground up in 8 months adding modules as i went working on it for 2 days a week! And to answer the question “if LightSwitch can handle a lot of data” the answer is YES! With my system they create almost 700 invoices a month with the simple press of a button ;)
So this was me in short story and my experiences with LightSwitch! Will be continued…