Media3 stands as a proactive, growth-oriented organization aiming at professional excellence with a pool of talented and dedicated work force. Our key strengths are motivated associates; value based work ethics, experienced personnel (live tech leads) and state of the art infrastructure. Media3 is one of the best IT Training institution in Visakhapatnam & Vizianagaram with most latest software courses on board like PHP, WordPress, Magento Commerce, Microsoft .Net, Java, Web Design & Responsive UI Development, AngularJS, NodeJS, Android and iOS app development, Python, Digital Marketing, Software Testing and SEO.

Course Overview

Introducing the Entity Framework

  •   Defining an entity
  •   Understanding the Entity Framework elements
  •   Introducing the Entity Framework files
  •   Developing a simple Entity Framework example

Looking more closely at queries

  •   Defining a basic query
  •   Creating specific queries
  •   Combining and summarizing data
  •   Grouping data

Choosing a workflow

  •   Understanding the code-first workflow
  •   Understanding the model-first workflow
  •   Understanding the database-first workflow
  •   Defining the workflow choices
    •   Creating a code-first example
    •   Adding a record
    •   Creating a model-first example
    •   Creating a database-first example
  • Generating and using objects
    •   Understanding the Entity objects
    •   Making queries using objects
    •   Modifying data using objects
    •   Working with Query Builder methods
  • Performing essential tasks
    •   Defining the essential tasks
    •   Creating a master/detail form
  • Manipulating data using LINQ
    •   Introducing LINQ to Entities
    •   Understanding LINQ compilation
    •   Using entity and database functions

    Manipulating data using Entity SQL

    •   Understanding Entity SQL
    •   Selecting data
    •   Working with literals in Entity SQL
    •   Ordering data
        Grouping data
  • Interaction with stored procedures
    •   Understanding stored procedures
    •   Adding stored procedures to your model
    •   Building an application using stored procedures
    •   Creating a basic stored procedure example
    • Interaction with views
      •   Understanding views
      •   Adding views to your model
      •   Creating a basic view example
      •   Making views writable
    • Interaction with Table-Valued Functions
      •   Understanding TVFs
      •   Adding TVFs to your model
      •   Calling a TVF using Entity SQL
      •   Calling a TVF using LINQ
          Mapping a TVF to an entity type collection
    • Dealing with exceptions
      •   Understanding exceptions
      •   Considering exception sources
      •   Handling connection string exceptions
      •   Dealing with query exceptions
          Dealing with other data exception types
      •   Understanding concurrency exceptions
    • Overcoming concurrency issues
      •     Visualizing database concurrency issues
      •   Considering optimistic concurrency problems
      •   Implementing optimistic concurrency in an application
      •   Considering pessimistic concurrency issues
    • Handling performance problems
    •   Understanding performance issue sources
    •   Viewing performance issues
    •   Defining the performance triangle
    •   Using multithreading as an aid to speed
  • Creating custom entities
  •   Developing POCO classes
  •   Creating and using event handlers
  •   Creating custom methods
  •   Creating custom properties

Mapping data types to properties

  •   Understanding mapping automation configuration
  •   Working with standard data types
  •   Working with enumerated data types
  •   Working with complex data types
  •   Working with geography and geometry spatial data types

Performing advanced management tasks

  •   Developing multiple diagrams for a model
  •   Performing batch imports of stored procedures and functions
  •   Mapping a stored procedure that returns multiple result sets
  •   Creating entities with inheritance
  •   Controlling context actions for automatically generated classes