View Single Post
  #106   Report Post  
Posted to uk.d-i-y
Andy Burns[_7_] Andy Burns[_7_] is offline
external usenet poster
 
Posts: 2,688
Default DIY ideas for Raspberry Pi?

Bernard Peek wrote:

On 05/03/12 19:31, dennis@home wrote:

VisualStudio and M$ SQL server, both free.


I did say without writing a line of code. If you look at the Express
editions of VS you will find out that they are designed to make database
programming difficult.


I wouldn't put it that strongly, ok so the VSE webdev can't create
databases, but you can just do that in SQL studio, then import the
database as the model of your MVC (model/view/controller) it
automagically creates generates the controller code for each table, and
web pages per view for CRUD (create/update/delete) functions for each
controller, following whatever relations you made within the database.

No, I wouldn't recommend it to a newbie (but I'm a bit snobbish and
would hesitate to recommend MS access either) but it's the first time in
about 15 years I've been impressed by the amount that VS(E) does for you
.... of course when you start tinkering you still wish it'd do more for
you, but I wouldn't knock it, it *does* get you a basic functional
web-based app without writing a line of code.