What’s this ‘Scaffolding a CRUD’ all about? Build a Website from your SQL Database

So you have a SQL Server database, and you want a web site for your tables? Come see how to develop and deploy a simple .NET website against any SQL Server database. See firsthand how to use Microsoft’s Entity Framework, ASP.Net MVC and other tricks to develop a website by writing very little code. Take home the ability to create and deploy a simple website to your own database once this demonstration is seen.

Transcript

1. What’s  this  ‘Scaffolding  a   CRUD’  all  about? Build  a  Website  from  your  SQL  Database
2. Please  allow  me  to  introduce  myself… -­ Rolling  Stone,  Sympathy  For  The  Devil § Gabriel  Villa § Solutions  Architect § MCPD,  ASP.Net Developer § MCTS,  SQL  Server  Database  Development @extofer www.extofer.com
3. Objectives § Answer  the  questions:  what  is  scaffolding  and   what  is  a  CRUD? § What  is  ASP.Net MVC? § Set  you  on  your  way  to  develop  to  your  own   database § And  Write  less  code
4. What  is  scaffolding?
5. What  is  scaffolding § Quickly  generating  a  basic  structure  for  your   website § With  only  the  defined  data  model,  scaffolding   will  create  all  the  components  for  managing   the  data  objects § MVC  application  based  on  the  CRUD   application  pattern
6. What’s  CRUD? § Create § Read § Update § Delete
7. Microsoft’s  Web  Evolution
8. Microsoft’s  Web  Evolution § DHTML § Active  Server  Pages § ASP.Net Web  Forms § ASP.Net MVC
9. What  is  ASP.Net MVC? Model  View  Controller  Pattern ASP.Net Model Controller View Business   Layer Coordinates   User  inputs   and  outputs User  Interface
10. Razor  – The  ASP.NET  view  engine § ASP.Net syntax  to  create  dynamic  web  pages § Razor  using  a  @  character.    Unlike  <%  %>
11. Programming  code…  moi? § HTML  5 § CSS3 § Scripts § Razor § C#/VB.Net § Any  other  .Net CLR View Model Controller
12. What  is  needed? § .Net Framework  4.x § Microsoft  Visual  Studio § Visual  Web  Developer § Entity  Framework § Db Context  Generator  (for  versions  2010  or  2008) § SQL  Server  Database § Version  Control
14. Open  Source  Community § Distributed  Revision  Control § Fork  a  project § Pull  request  and  participate § Rapid  Application  development
15. Open  Source  Hosting   § Code  Plex – Git,  Mercurial,  SVN,  TFS § http://www.codeplex.com/ § Google  Code  – service  will  close  Jan.  2016 § http://code.google.com § GitHub § https://github.com/
16. Obligatory  Image  of  Bacon
17. ASP.Net MVC  Directory  Structure § App_Data – physical  data  store § Content – CSS,  images § Controller – class  files  for  each  controller,  each  named  in   the  same  convention,  i.e “HomeController” § Models – business  logic  classes § Scripts – client  side  scripts  to  support  application,  such  as   Jquery and  AJAX § Views – location  of  the  view  files
18. Looking  Good!! § ASP.Net MVC  Boiler  Plate § http://bit.ly/VSBoilerPlate § https://github.com/RehanSaeed/ASP.NET-­MVC-­ Boilerplate § Code  for  Coffee  Boiler  Plate § http://bit.ly/Code4CofeeBoilerPlate § http://bit.ly/Code4CofeeGit § Initializr § http://www.initializr.com/
19. Resources § .Net Framework  4.x § Download:  Microsoft  .NET  Framework  4  (Web  Installer)  -­ Microsoft   Download  Center  -­ Download  Details  http://bit.ly/J1pJ5s § Visual  Web  Developer  Express § Free  Developer  Tools  -­ Visual  Studio  2012  Express  |  Microsoft  Visual   Studio  http://bit.ly/J1pUh2 § Nuget or  Extension  Manager § Entity  Framework § Db Context  Generator   § BootStrap
20. Was  it  good  for  you? § We  answered  what  ASP.Net MVC  is § Set  you  on  your  way  to  develop  to  your  own   database § We  wrote  less  code § Open  Source  Community
22. Thank  you! § Contact  Info § Email  &  Google+:  extofer@gmail.om § Twitter:  @extofer § Linkedin:  www.linkedin.com/in/gabevilla § Website:  www.extofer.com