Developing Applications with Entity Framework 4.1, Part 2 of 3

Course description The course starts with an introduction to Entity Framework, where you will learn about data access and...

Content Provider

LearnNow Online

Duration

4 hrs 22 mins

Mode Of Delivery

Online

Course Validity

12 months

Course Level

Advanced

Certification By

Go1 - KRACKiN
  • ( ₹9999 ₹3499)
Speak with our Expert Team Today Ask Now
Description

Course description



The course starts with an introduction to Entity Framework, where you will learn about data access and object-relational mapping, how the Entity Framework works and the tools it provides, and you will see how to build an entity data model. Then you will explore the entity data model in more detail, where you will learn about the model designer and the raw XML that actually defines the conceptual, storage, and mapping models. You will also learn how you can use stored procedures and functions with Entity Framework. Next you will learn about the most important ways to query data using Entity Framework objects. You are most likely to use LINQ to Entities, but other options include Entity SQL and an Entity Client API. After that, you will learn about the ways that you can modify and customize the entity data objects, using the model designer, partial classes and methods, and events. Finally, you will learn about code-first development, which we are confident is going to become the primary way to develop new Entity Framework applications.



Each LearnNowOnline training course is made up of Modules (typically an hour in length). Within each module there are Topics (typically 15-30 minutes each) and Subtopics (typically 2-5 minutes each). There is a Post Exam for each Module that must be passed with a score of 70% or higher to successfully and fully complete the course.



Prerequisites



This course assumes you are familiar with the Entity Framework and using Visual Studio 2010.



Meet the expert



Don Kiely



Don Kiely is a featured instructor on many of our SQL Server and Visual Studio courses. He is a nationally recognized author, instructor, and consultant specializing in Microsoft technologies. Don has many years of teaching experience, is the author or co-author of several programming books, and has spoken at many industry conferences and user groups. In addition, Don is a consultant for a variety of companies that develop distributed applications for public and private organizations.



Video Runtime



202 Minutes



Time to complete



262 Minutes



Course Outline



Module 4



Model First Designs (31:00)




  • Introduction (01:27)

  • Event Registration (02:30)

  • Demo: Create a New Model (01:45)

  • Demo: Add Items to Designer (01:26)

  • Demo: Add Entities (12:06)

  • Demo: Add Associations (03:29)

  • Demo: Create/Generate Database (02:52)

  • Demo: Examine Generated Code (05:07)

  • Summary (00:15)



Model Browser / XML (44:54)




  • Introduction (00:54)

  • Demo: Model Browser (01:44)

  • Entity Data Model in the Raw (02:18)

  • XML Definition Languages (01:45)

  • Demo: Explore the XML Code (00:26)

  • Demo: Outline the XML (01:22)

  • Demo: Designer Element (01:24)

  • Demo: Diagram Content (02:08)

  • Demo: Runtime Content (01:11)

  • Demo: Conceptual Models (01:37)

  • Demo: EntityContainer (01:06)

  • Demo: EntitySet/AssociationSet (02:20)

  • Demo: EntityType (03:27)

  • Demo: NavigationProperty (03:24)

  • Demo: Association Elements (02:35)

  • Demo: Storage Models (07:45)

  • Demo: Mappings (03:09)

  • Demo: ScalarProperty (02:06)

  • Model Build Mechanics (01:24)

  • MetadataArtifactProcessing (02:13)

  • Summary (00:28)



Module 5



Using Stored Procedures (33:38)




  • Introduction (02:25)

  • Ways to Use Stored Procedures (01:18)

  • Update Model from Database (02:40)

  • Demo: Define Stored Procedures (02:56)

  • Demo: Import into Model (04:28)

  • Demo: View Function Elements (04:17)

  • Change An Entity (00:48)

  • Demo: Change an Entity (04:37)

  • Demo: View Changed XML (01:55)

  • Demo: Test Stored Procedures (05:08)

  • Demo: View SQL Server Profiler (02:47)

  • Summary (00:13)



Stored Procedures To Read Data (20:25)




  • Introduction (01:19)

  • Demo: Read Data w/Stored Procs (11:15)

  • Demo: Test Reading Data (00:29)

  • Return a Scalar Value (00:59)

  • Demo: Return Scalar Value (05:55)

  • Demo: Test Scalar Value (00:11)

  • Summary (00:15)



Module 6



Querying Entity Framework (25:18)




  • Introduction (00:54)

  • Entity Framework Query Options (02:33)

  • Framework Architecture (01:03)

  • LINQPad (02:27)

  • Demo: LINQPad (05:21)

  • Demo: A Simple Query (07:16)

  • Demo: Examine Class Diagram (05:15)

  • Summary (00:25)



LINQ to Entities (47:17)




  • Introduction (00:55)

  • LINQ Primer (04:13)

  • LINQ Query Expressions (03:20)

  • LINQ Methods (02:17)

  • Demo: LINQ Query Expression (01:12)

  • Demo: LINQ Methods (03:01)

  • Which Syntax to use (03:12)

  • LINQ to Entities (00:45)

  • Projections (01:07)

  • Demo: Projections (14:22)

  • Querying Related Data (01:40)

  • Demo: Navigation References (05:10)

  • Demo: Navigation Collections (05:27)

  • Summary (00:30)


Who Should Attend

Students from various streams of Computer Science and Engineering like BCA, MCA, B.Tech, M.Tech


Frequently Asked Questions

Where can I find courses on the Platform?

After login to KRACKiN(www.krackin.com), you can find courses on the dashboard which are segregated as skill courses, career tracks and also Annual Membership.consisting of 75000 + courses. You can enrol to any of the courses available by selecting the ‘Buy Now’ button.
Can I search courses domain wise on the platform?

Yes, Skill courses and Annual Membership plans are segregated domain wise. You can enter your domain and search for the desired courses.
Is online classes available for all the courses on KRACKiN?

No, online classes are not available for all courses on KRACKiN. Courses are designed as self- paced learning courses supported by videos, PPTs and practice quizzes etc. are provided for easy understanding of the students.
Are the course certificates valid?

Yes, the certificates are valid across all the sectors in the Industry.
Can I access your courses on Mobile device?

Yes, you can access the courses on your mobile browser.
Can my course access be extended?

We recommend you complete your assigned courses within the stipulated time as we do not have the provision to extend the course validity.
How to get my certificate after completing the course?

After the completion of all the given modules, the certificate will be auto generated by the system.

Content & Certification Partners


About KRACKiN