1 00:00:00,000 --> 00:00:04,887 [MUSIC] 2 00:00:04,887 --> 00:00:07,280 Hi, my name is James. 3 00:00:07,280 --> 00:00:08,450 Entity framework or 4 00:00:08,450 --> 00:00:15,110 simply EF is a type of framework known as an object relational mapper or ORM. 5 00:00:15,110 --> 00:00:19,870 Using EF for your applications data access allows you to interact with your data using 6 00:00:19,870 --> 00:00:23,240 the set of entities and a database context clause. 7 00:00:23,240 --> 00:00:25,680 This keeps you from having to write SQL queries 8 00:00:25,680 --> 00:00:28,960 in order to interact directly with the database. 9 00:00:28,960 --> 00:00:32,330 In an earlier treehouse course we learned about the basics of EF, 10 00:00:32,330 --> 00:00:36,710 but we did that within the confines of console application. 11 00:00:36,710 --> 00:00:38,658 While that allowed us to keep the focus on EF, 12 00:00:38,658 --> 00:00:43,030 it didn't give us a realistic common use case. 13 00:00:43,030 --> 00:00:46,140 This course is designed to do just that. 14 00:00:46,140 --> 00:00:50,625 Show you how to use EF within a web application developed using Microsoft's 15 00:00:50,625 --> 00:00:53,740 asp.net MVC web framework. 16 00:00:53,740 --> 00:00:57,210 We'll start this course by seeing how to put our EF entities and 17 00:00:57,210 --> 00:01:01,550 database context classes into its own class library project. 18 00:01:01,550 --> 00:01:05,470 Then we will add an ASP.NET MVC project to our solution and 19 00:01:05,470 --> 00:01:08,890 update to use EF code in the class library. 20 00:01:08,890 --> 00:01:11,955 After updating our web app to retrieve and persist data. 21 00:01:11,955 --> 00:01:16,290 We'll look at some options for organizing our data access code. 22 00:01:16,290 --> 00:01:20,910 By the end of this course you will be able to use EF with ASP.NET MVC to 23 00:01:20,910 --> 00:01:24,550 create powerful data-driven web applications. 24 00:01:24,550 --> 00:01:27,250 Let's talk about how to get the most out of this course. 25 00:01:28,250 --> 00:01:32,832 I'm going to assume that you're already familiar with the basics of ASP.Net MVC, 26 00:01:32,832 --> 00:01:36,460 entity framework, and Visual Studio. 27 00:01:36,460 --> 00:01:41,550 If you're unfamiliar with any of those topics or maybe you need a refresher, 28 00:01:41,550 --> 00:01:45,360 check the teacher's notes for a list of Treehouse resources that can help. 29 00:01:45,360 --> 00:01:48,812 This course is designed to be highly interactive. 30 00:01:48,812 --> 00:01:51,520 Throughout, I'll be asking you questions and 31 00:01:51,520 --> 00:01:54,610 giving you hands-on coding exercises to complete on your own. 32 00:01:54,610 --> 00:01:57,860 But don't worry, you won't be left hanging. 33 00:01:57,860 --> 00:02:02,080 After you've had time to think about the question or complete an exercise, 34 00:02:02,080 --> 00:02:05,740 I'll share with you the answer or walk you through my solution. 35 00:02:05,740 --> 00:02:09,430 Also, I'd encourage you to follow along with each video. 36 00:02:09,430 --> 00:02:14,190 Write the code yourself as I'm writing it or just after and 37 00:02:14,190 --> 00:02:17,300 take the time to complete each exercise. 38 00:02:17,300 --> 00:02:21,300 Even if you aren't able to come up with the solution just the act of trying will 39 00:02:21,300 --> 00:02:26,030 help you to learn and retain the material Before we start working on setting 40 00:02:26,030 --> 00:02:29,710 up our solution, let's take a look at our web app in its finished form.