{"id":1125,"date":"2019-09-26T04:21:24","date_gmt":"2019-09-26T04:21:24","guid":{"rendered":"https:\/\/studysection.com\/blog\/?p=1125"},"modified":"2019-09-26T04:55:36","modified_gmt":"2019-09-26T04:55:36","slug":"entity-framework-introduction","status":"publish","type":"post","link":"https:\/\/studysection.com\/blog\/entity-framework-introduction\/","title":{"rendered":"Entity Framework Introduction"},"content":{"rendered":"

Entity Framework is a Platform independent, open-source ORM (object-relational mapping) framework provided by Microsoft to automate Database related activities in applications. It fits between business logic and database, in other words, it provides decoupling between the two. It uses LINQ queries to access the database.
\n
\n\"Entity-Framework\"\/
\n
\nTo use the entity framework in a project one needs to add an entity framework package in the project. Entity Framework uses three approaches to use the database. The approaches are <\/p>\n

    \n
  1. Database-First <\/li>\n
  2. Code-First <\/li>\n
  3. Model first.<\/li>\n<\/ol>\n

    Database-First approach:<\/strong>– In this approach, we make a database first by using a visual designer and then the entity framework generates the model classes according to the table generated on the database.
    \n
    \nIn this we first go to the SQL<\/a> server management studio we either select the existing database or create a new database and then generate a table under it. Then we go to the project and import this database into the project. The code will be auto-generated by the entity framework in a .cs file and the class will have an extension DBContext which is an abstraction of database which is a simple API to load data from the database. We also use database properties to use database tables.
    \n
    \nCode-First approach:<\/strong>– We start with the code by simply creating the domain classes first and the entity framework generates the database tables according to this. This is the new approach applied by the entity framework.
    \n
    \nIn this approach, we create a class in the .cs file with the no of elements we want to use in a table and then we create another context class with an extension of DBContext and we name the table under which we want to use the properties. In this, we also need to give a connection string in the app.config file. Then the entity framework will provide the table and its columns in the database automatically.
    \n
    \nModel-first:<\/strong>– In this approach we use visual designer to model the tables and there associations in some kind of UML diagram. Then the entity framework model the classes and database according to the design.
    \n
    \nIn this a visual representation of table is generated in visual designer with the no of elements and the entity framework will generate the code and table according to that approach. This approach is rarely used by developer because of the poor accessibility and user interface.<\/p>\n","protected":false},"excerpt":{"rendered":"

    Entity Framework is a Platform independent, open-source ORM (object-relational mapping) framework provided by Microsoft to automate Database related activities in<\/p>\n","protected":false},"author":1,"featured_media":1128,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[149,190,189,191],"acf":[],"yoast_head":"\nStudy section blog for Entity Framework Introduction<\/title>\n<meta name=\"description\" content=\"Entity Framework is a Platform independent, open-source ORM framework provided by Microsoft to automate Database related activities in applications.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/studysection.com\/blog\/entity-framework-introduction\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Study section blog for Entity Framework Introduction\" \/>\n<meta property=\"og:description\" content=\"Entity Framework is a Platform independent, open-source ORM framework provided by Microsoft to automate Database related activities in applications.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/studysection.com\/blog\/entity-framework-introduction\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog Posts on famous people, innovations and educational topics\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/studysection\" \/>\n<meta property=\"article:published_time\" content=\"2019-09-26T04:21:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-09-26T04:55:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/studysection.com\/blog\/wp-content\/uploads\/2019\/09\/orm.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"300\" \/>\n\t<meta property=\"og:image:height\" content=\"200\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"admin-studysection-blog\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@studysection\" \/>\n<meta name=\"twitter:site\" content=\"@studysection\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin-studysection-blog\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/studysection.com\/blog\/entity-framework-introduction\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/studysection.com\/blog\/entity-framework-introduction\/\"},\"author\":{\"name\":\"admin-studysection-blog\",\"@id\":\"https:\/\/studysection.com\/blog\/#\/schema\/person\/db367e2c29a12d1808fb1979edb3d402\"},\"headline\":\"Entity Framework Introduction\",\"datePublished\":\"2019-09-26T04:21:24+00:00\",\"dateModified\":\"2019-09-26T04:55:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/studysection.com\/blog\/entity-framework-introduction\/\"},\"wordCount\":400,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/studysection.com\/blog\/#organization\"},\"keywords\":[\"database\",\"Entity Framework\",\"Framework\",\"ORM\"],\"articleSection\":[\"Learn and Grow\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/studysection.com\/blog\/entity-framework-introduction\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/studysection.com\/blog\/entity-framework-introduction\/\",\"url\":\"https:\/\/studysection.com\/blog\/entity-framework-introduction\/\",\"name\":\"Study section blog for Entity Framework Introduction\",\"isPartOf\":{\"@id\":\"https:\/\/studysection.com\/blog\/#website\"},\"datePublished\":\"2019-09-26T04:21:24+00:00\",\"dateModified\":\"2019-09-26T04:55:36+00:00\",\"description\":\"Entity Framework is a Platform independent, open-source ORM framework provided by Microsoft to automate Database related activities in applications.\",\"breadcrumb\":{\"@id\":\"https:\/\/studysection.com\/blog\/entity-framework-introduction\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/studysection.com\/blog\/entity-framework-introduction\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/studysection.com\/blog\/entity-framework-introduction\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/studysection.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Entity Framework Introduction\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/studysection.com\/blog\/#website\",\"url\":\"https:\/\/studysection.com\/blog\/\",\"name\":\"Blog Posts on famous people, innovations and educational topics\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/studysection.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/studysection.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/studysection.com\/blog\/#organization\",\"name\":\"StudySection\",\"url\":\"https:\/\/studysection.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/studysection.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/studysection.com\/blog\/wp-content\/uploads\/2021\/10\/studySection-logo.png\",\"contentUrl\":\"https:\/\/studysection.com\/blog\/wp-content\/uploads\/2021\/10\/studySection-logo.png\",\"width\":920,\"height\":440,\"caption\":\"StudySection\"},\"image\":{\"@id\":\"https:\/\/studysection.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/studysection\",\"https:\/\/twitter.com\/studysection\",\"https:\/\/www.instagram.com\/study.section\/\",\"https:\/\/www.linkedin.com\/company\/studysection\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/studysection.com\/blog\/#\/schema\/person\/db367e2c29a12d1808fb1979edb3d402\",\"name\":\"admin-studysection-blog\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/studysection.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/054ac87a6874df1932004239cd8eab36?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/054ac87a6874df1932004239cd8eab36?s=96&d=mm&r=g\",\"caption\":\"admin-studysection-blog\"},\"url\":\"https:\/\/studysection.com\/blog\/author\/admin-studysection-blog\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Study section blog for Entity Framework Introduction","description":"Entity Framework is a Platform independent, open-source ORM framework provided by Microsoft to automate Database related activities in applications.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/studysection.com\/blog\/entity-framework-introduction\/","og_locale":"en_US","og_type":"article","og_title":"Study section blog for Entity Framework Introduction","og_description":"Entity Framework is a Platform independent, open-source ORM framework provided by Microsoft to automate Database related activities in applications.","og_url":"https:\/\/studysection.com\/blog\/entity-framework-introduction\/","og_site_name":"Blog Posts on famous people, innovations and educational topics","article_publisher":"https:\/\/www.facebook.com\/studysection","article_published_time":"2019-09-26T04:21:24+00:00","article_modified_time":"2019-09-26T04:55:36+00:00","og_image":[{"width":300,"height":200,"url":"https:\/\/studysection.com\/blog\/wp-content\/uploads\/2019\/09\/orm.jpg","type":"image\/jpeg"}],"author":"admin-studysection-blog","twitter_card":"summary_large_image","twitter_creator":"@studysection","twitter_site":"@studysection","twitter_misc":{"Written by":"admin-studysection-blog","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/studysection.com\/blog\/entity-framework-introduction\/#article","isPartOf":{"@id":"https:\/\/studysection.com\/blog\/entity-framework-introduction\/"},"author":{"name":"admin-studysection-blog","@id":"https:\/\/studysection.com\/blog\/#\/schema\/person\/db367e2c29a12d1808fb1979edb3d402"},"headline":"Entity Framework Introduction","datePublished":"2019-09-26T04:21:24+00:00","dateModified":"2019-09-26T04:55:36+00:00","mainEntityOfPage":{"@id":"https:\/\/studysection.com\/blog\/entity-framework-introduction\/"},"wordCount":400,"commentCount":0,"publisher":{"@id":"https:\/\/studysection.com\/blog\/#organization"},"keywords":["database","Entity Framework","Framework","ORM"],"articleSection":["Learn and Grow"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/studysection.com\/blog\/entity-framework-introduction\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/studysection.com\/blog\/entity-framework-introduction\/","url":"https:\/\/studysection.com\/blog\/entity-framework-introduction\/","name":"Study section blog for Entity Framework Introduction","isPartOf":{"@id":"https:\/\/studysection.com\/blog\/#website"},"datePublished":"2019-09-26T04:21:24+00:00","dateModified":"2019-09-26T04:55:36+00:00","description":"Entity Framework is a Platform independent, open-source ORM framework provided by Microsoft to automate Database related activities in applications.","breadcrumb":{"@id":"https:\/\/studysection.com\/blog\/entity-framework-introduction\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/studysection.com\/blog\/entity-framework-introduction\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/studysection.com\/blog\/entity-framework-introduction\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/studysection.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Entity Framework Introduction"}]},{"@type":"WebSite","@id":"https:\/\/studysection.com\/blog\/#website","url":"https:\/\/studysection.com\/blog\/","name":"Blog Posts on famous people, innovations and educational topics","description":"","publisher":{"@id":"https:\/\/studysection.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/studysection.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/studysection.com\/blog\/#organization","name":"StudySection","url":"https:\/\/studysection.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/studysection.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/studysection.com\/blog\/wp-content\/uploads\/2021\/10\/studySection-logo.png","contentUrl":"https:\/\/studysection.com\/blog\/wp-content\/uploads\/2021\/10\/studySection-logo.png","width":920,"height":440,"caption":"StudySection"},"image":{"@id":"https:\/\/studysection.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/studysection","https:\/\/twitter.com\/studysection","https:\/\/www.instagram.com\/study.section\/","https:\/\/www.linkedin.com\/company\/studysection"]},{"@type":"Person","@id":"https:\/\/studysection.com\/blog\/#\/schema\/person\/db367e2c29a12d1808fb1979edb3d402","name":"admin-studysection-blog","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/studysection.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/054ac87a6874df1932004239cd8eab36?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/054ac87a6874df1932004239cd8eab36?s=96&d=mm&r=g","caption":"admin-studysection-blog"},"url":"https:\/\/studysection.com\/blog\/author\/admin-studysection-blog\/"}]}},"views":386,"_links":{"self":[{"href":"https:\/\/studysection.com\/blog\/wp-json\/wp\/v2\/posts\/1125"}],"collection":[{"href":"https:\/\/studysection.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/studysection.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/studysection.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/studysection.com\/blog\/wp-json\/wp\/v2\/comments?post=1125"}],"version-history":[{"count":5,"href":"https:\/\/studysection.com\/blog\/wp-json\/wp\/v2\/posts\/1125\/revisions"}],"predecessor-version":[{"id":1132,"href":"https:\/\/studysection.com\/blog\/wp-json\/wp\/v2\/posts\/1125\/revisions\/1132"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/studysection.com\/blog\/wp-json\/wp\/v2\/media\/1128"}],"wp:attachment":[{"href":"https:\/\/studysection.com\/blog\/wp-json\/wp\/v2\/media?parent=1125"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/studysection.com\/blog\/wp-json\/wp\/v2\/categories?post=1125"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/studysection.com\/blog\/wp-json\/wp\/v2\/tags?post=1125"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}