Learn C#: Make a Databased App with Entity Framework
In this course you will learn how to create a simple C# application using Microsoft Visual Studio that creates and connects to an SQL Database with the Entity Framework*, with no database development required!
We will use Code First development principals to define all database tables and columns using only C# code.
All database tables and columns will be generated automatically from the C# code without the need to edit the database directly. As such we will be doing no database development (except for a section on calling SQL statements directly if you need to).
All source code is included as a Microsoft Visual Studio 2013 project so you can get up and running straight away.
Thank you for choosing this course and we look forward to viewing your positive reviews and feedback.
MPire Solutions Pty Ltd
* Note: The Entity Framework is Microsofts' newest data access technology, and Code First allows us to create database driven applications using only C# code, with no database development required!
Course introduction and contents.
Define a specification for the simple example sales application.
Download the "Entity Framework Cheat Sheet" and Source Code to the sample application.
You'll need to have Microsoft Visual Studio to do this course. If you don't already have it installed, this quick video will show you how to get the free Express Edition.
Create the example C# Windows Forms application in Microsoft Visual Studio and reference Entity Framework using NuGet.
Create the bare-bones models (entities) as C# classes.
Create a base model which all other models can inherit from. Code reuse reduces the amount of code we need to write!
Create an interface that flags a model as being active or inactive.
Connect models together in one-to-one relationships.
Connect models together in one-to-many relationships.
Create a very simple Data Context to connect to the database.
Add more advanced functionality to the Data Context, such as soft deletion and simple auditing.
After creating the Models and Data Context, we can now generate an SQL Database automatically from the code.
Learn how to change your Models and update your database accordingly with Migrations.
Insert core data into the database automatically using Seeding.
Learn how to Read lists of items and single items from the database.
Learn how to Create a new Sale and save it to the database.
Learn how to Update an existing Sale and save it to the database.
Learn how to Delete a Sale from the database.
How to use Enumerations in your Models.
Customize the Table and Column names that Entity Framework will use to generate the database.
Upgrading to Entity Framework 6.1 and a brief introduction to the Index attribute to quickly create database indexes on tables.
Thanks for watching! Please leave a comment and rating.