{"id":104,"date":"2020-06-15T22:44:00","date_gmt":"2020-06-15T22:44:00","guid":{"rendered":"https:\/\/okankaradag.com\/?p=104"},"modified":"2021-06-16T11:40:18","modified_gmt":"2021-06-16T11:40:18","slug":"entity-framework-code-first-vs-sql-server-birebir-iliski","status":"publish","type":"post","link":"https:\/\/okankaradag.com\/en\/entity-framewok\/entity-framework-code-first-vs-sql-server-birebir-iliski","title":{"rendered":"Entity Framework Code First Vs Sql Server: Birebir \u0130li\u015fki(One to one)"},"content":{"rendered":"<p>\u0130lk olarak Sql Server ile birebir ili\u015fkili bir veritaban\u0131 yapt\u0131ktan sonra bunu Entiy framework code first y\u00f6ntemiyle nas\u0131l yapaca\u011f\u0131m\u0131z\u0131 anlataca\u011f\u0131m.<\/p>\n\n\n\n<p>Sql serverde klasik olarak new database diyerek veritaban\u0131n\u0131 olu\u015fturduktan sonra yeni bir diagram a\u00e7\u0131yoruz ve tablolar\u0131m\u0131z\u0131 a\u015fa\u011f\u0131daki gibi ili\u015fkilendiriyoruz.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"528\" height=\"402\" src=\"https:\/\/okankaradag.com\/wp-content\/uploads\/2020\/06\/ForeignKeySqlServer.jpg\" alt=\"\" class=\"wp-image-106\" srcset=\"https:\/\/okankaradag.com\/wp-content\/uploads\/2020\/06\/ForeignKeySqlServer.jpg 528w, https:\/\/okankaradag.com\/wp-content\/uploads\/2020\/06\/ForeignKeySqlServer-300x228.jpg 300w\" sizes=\"(max-width: 528px) 100vw, 528px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"1024\" height=\"244\" src=\"https:\/\/okankaradag.com\/wp-content\/uploads\/2020\/06\/ColumnlarVeDiagram-1024x244.jpg\" alt=\"\" class=\"wp-image-107\" srcset=\"https:\/\/okankaradag.com\/wp-content\/uploads\/2020\/06\/ColumnlarVeDiagram-1024x244.jpg 1024w, https:\/\/okankaradag.com\/wp-content\/uploads\/2020\/06\/ColumnlarVeDiagram-300x72.jpg 300w, https:\/\/okankaradag.com\/wp-content\/uploads\/2020\/06\/ColumnlarVeDiagram-768x183.jpg 768w, https:\/\/okankaradag.com\/wp-content\/uploads\/2020\/06\/ColumnlarVeDiagram.jpg 1191w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Sql Server&#8217;da basit bir \u015fekilde tablolar aras\u0131nda birebir ili\u015fkiyi yapt\u0131k \u015fimdi de ayn\u0131s\u0131n\u0131 entity framework&#8217;de code first y\u00f6ntemiyle yapmaya geldi. <\/p>\n\n\n\n<p>Mvc projesi a\u00e7t\u0131ktan sonra Models klas\u00f6r\u00fc i\u00e7ine a\u015fa\u011f\u0131daki gibi iki adet s\u0131n\u0131f tan\u0131ml\u0131yoruz<\/p>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"theme:github lang:c# decode:true\">public class Yazar\n{\n    public int Id { get; set; }\n    public string Yay\u0131nEvi\u0130smi { get; set; }\n    public virtual YazarBiografi YazarBiografi { get; set; }\n}<\/pre><\/div>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"theme:github lang:default decode:true\">public class YazarBiografi\n{\n    public int Id { get; set; }\n    public string Ad { get; set; }\n    public string Soyad { get; set; }\n    public int DogumYili { get; set; }\n    public virtual Yazar Yazar { get; set; }\n}<\/pre><\/div>\n\n\n\n<p>Birebir ili\u015fki yapmam\u0131z i\u00e7in ili\u015fkili alanlar\u0131 birbirlerinin s\u0131n\u0131f\u0131na eklemeliyiz. Yukar\u0131daki kodlarda g\u00f6r\u00fcld\u00fc\u011f\u00fc gibi Yazar&#8217;a ait YazarBiografi tipinde bir property&#8217;si bulunmakta ayn\u0131 \u015fekilde YazarBiografi s\u0131n\u0131f\u0131nda da Yazar property&#8217;si bulunuyor. Son olarak da Context s\u0131n\u0131f\u0131m\u0131zda fluent api kullanarak iki tablo aras\u0131ndaki ili\u015fkiyi yapaca\u011f\u0131z<\/p>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"theme:github lang:c# decode:true\">public DbSet&lt;Yazar&gt; Yazarlar { get; set; }\npublic DbSet&lt;YazarBiografi&gt; YazarBiografileri { get; set; }\n\nprotected override void OnModelCreating(DbModelBuilder modelBuilder)\n{\n    base.OnModelCreating(modelBuilder);\n    modelBuilder.Entity&lt;Yazar&gt;()\n        .HasRequired(x =&gt; x.YazarBiografi)\n        .WithRequiredPrincipal(x =&gt; x.Yazar);            \n}<\/pre><\/div>\n\n\n\n<p><strong>OnModelCreating<\/strong> i\u00e7inde yazd\u0131\u011f\u0131m\u0131z metodu t\u00fcrk\u00e7ele\u015ftirirsek \u015f\u00f6yle bir ifade olur; her yazar\u0131n zorunlu bir <strong>YazarBiografisi<\/strong> vard\u0131r Her YazarBiografinin de zorunlu bir <strong>Yazar <\/strong>alan\u0131 vard\u0131r. Bu zorunlu alanlar\u0131 isterseniz <strong>required <\/strong>yerine <strong>optional <\/strong>yaparak zorunlu olmaktan \u00e7\u0131karabilirsiniz.<\/p>\n\n\n\n<h4>Migration \u0130\u015flemlerine Detayl\u0131 bakmak i\u00e7in:<\/h4>\n\n\n\n<p><a href=\"https:\/\/okankaradag.com\/en\/entity-framewok\/entity-framework-migration-komutlari\/\">https:\/\/okankaradag.com\/entity-framewok\/entity-framework-migration-komutlari\/<\/a><\/p>\n\n\n\n<p>Bir sonraki yaz\u0131da g\u00f6r\u00fc\u015fmek \u00fczere.<\/p>","protected":false},"excerpt":{"rendered":"<p>\u0130lk olarak Sql Server ile birebir ili\u015fkili bir veritaban\u0131 yapt\u0131ktan sonra bunu Entiy framework code first y\u00f6ntemiyle nas\u0131l yapaca\u011f\u0131m\u0131z\u0131 anlataca\u011f\u0131m. Sql serverde klasik olarak new database diyerek veritaban\u0131n\u0131 olu\u015fturduktan sonra yeni bir diagram a\u00e7\u0131yoruz&#46;&#46;&#46;<\/p>","protected":false},"author":1,"featured_media":108,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[16,32],"tags":[34,35,33],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.13 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Entity Framework Code First Vs Sql Server: Birebir \u0130li\u015fki(One to one) - Okan Karada\u011f<\/title>\n<meta name=\"description\" content=\"\u0130lk olarak Sql Server ile birebir ili\u015fkili bir veritaban\u0131 yapt\u0131ktan sonra bunu Entiy framework code first y\u00f6ntemiyle nas\u0131l yapaca\u011f\u0131m\u0131z\u0131 anlataca\u011f\u0131m.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/okankaradag.com\/en\/entity-framewok\/entity-framework-code-first-vs-sql-server-birebir-iliski\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Entity Framework Code First Vs Sql Server: Birebir \u0130li\u015fki(One to one) - Okan Karada\u011f\" \/>\n<meta property=\"og:description\" content=\"\u0130lk olarak Sql Server ile birebir ili\u015fkili bir veritaban\u0131 yapt\u0131ktan sonra bunu Entiy framework code first y\u00f6ntemiyle nas\u0131l yapaca\u011f\u0131m\u0131z\u0131 anlataca\u011f\u0131m.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/okankaradag.com\/en\/entity-framewok\/entity-framework-code-first-vs-sql-server-birebir-iliski\/\" \/>\n<meta property=\"og:site_name\" content=\"Okan Karada\u011f\" \/>\n<meta property=\"article:published_time\" content=\"2020-06-15T22:44:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-06-16T11:40:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/okankaradag.com\/wp-content\/uploads\/2020\/06\/entity-framework.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"500\" \/>\n\t<meta property=\"og:image:height\" content=\"258\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Okan Karada\u011f\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Okan Karada\u011f\" \/>\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:\/\/okankaradag.com\/asp-net\/asp-net-mvc\/entity-framework-code-first-vs-sql-server-birebir-iliski#article\",\"isPartOf\":{\"@id\":\"https:\/\/okankaradag.com\/asp-net\/asp-net-mvc\/entity-framework-code-first-vs-sql-server-birebir-iliski\"},\"author\":{\"name\":\"Okan Karada\u011f\",\"@id\":\"https:\/\/okankaradag.com\/#\/schema\/person\/0196919c5e3b6a496101ded872640d52\"},\"headline\":\"Entity Framework Code First Vs Sql Server: Birebir \u0130li\u015fki(One to one)\",\"datePublished\":\"2020-06-15T22:44:00+00:00\",\"dateModified\":\"2021-06-16T11:40:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/okankaradag.com\/asp-net\/asp-net-mvc\/entity-framework-code-first-vs-sql-server-birebir-iliski\"},\"wordCount\":239,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/okankaradag.com\/#\/schema\/person\/0196919c5e3b6a496101ded872640d52\"},\"keywords\":[\"Birebir \u0130li\u015fki\",\"EntityFramework\",\"One To One\"],\"articleSection\":[\"Asp.Net MVC\",\"Entity Framewok\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/okankaradag.com\/asp-net\/asp-net-mvc\/entity-framework-code-first-vs-sql-server-birebir-iliski#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/okankaradag.com\/asp-net\/asp-net-mvc\/entity-framework-code-first-vs-sql-server-birebir-iliski\",\"url\":\"https:\/\/okankaradag.com\/asp-net\/asp-net-mvc\/entity-framework-code-first-vs-sql-server-birebir-iliski\",\"name\":\"Entity Framework Code First Vs Sql Server: Birebir \u0130li\u015fki(One to one) - Okan Karada\u011f\",\"isPartOf\":{\"@id\":\"https:\/\/okankaradag.com\/#website\"},\"datePublished\":\"2020-06-15T22:44:00+00:00\",\"dateModified\":\"2021-06-16T11:40:18+00:00\",\"description\":\"\u0130lk olarak Sql Server ile birebir ili\u015fkili bir veritaban\u0131 yapt\u0131ktan sonra bunu Entiy framework code first y\u00f6ntemiyle nas\u0131l yapaca\u011f\u0131m\u0131z\u0131 anlataca\u011f\u0131m.\",\"breadcrumb\":{\"@id\":\"https:\/\/okankaradag.com\/asp-net\/asp-net-mvc\/entity-framework-code-first-vs-sql-server-birebir-iliski#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/okankaradag.com\/asp-net\/asp-net-mvc\/entity-framework-code-first-vs-sql-server-birebir-iliski\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/okankaradag.com\/asp-net\/asp-net-mvc\/entity-framework-code-first-vs-sql-server-birebir-iliski#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/okankaradag.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Entity Framework Code First Vs Sql Server: Birebir \u0130li\u015fki(One to one)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/okankaradag.com\/#website\",\"url\":\"https:\/\/okankaradag.com\/\",\"name\":\"Okan Karada\u011f\",\"description\":\"Programlama \u00dczerine\",\"publisher\":{\"@id\":\"https:\/\/okankaradag.com\/#\/schema\/person\/0196919c5e3b6a496101ded872640d52\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/okankaradag.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/okankaradag.com\/#\/schema\/person\/0196919c5e3b6a496101ded872640d52\",\"name\":\"Okan Karada\u011f\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/okankaradag.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ca08a5537d7e304914c37189abedd2a1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ca08a5537d7e304914c37189abedd2a1?s=96&d=mm&r=g\",\"caption\":\"Okan Karada\u011f\"},\"logo\":{\"@id\":\"https:\/\/okankaradag.com\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:\/\/okankaradag.com\"],\"url\":\"https:\/\/okankaradag.com\/en\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Entity Framework Code First Vs Sql Server: Birebir \u0130li\u015fki(One to one) - Okan Karada\u011f","description":"\u0130lk olarak Sql Server ile birebir ili\u015fkili bir veritaban\u0131 yapt\u0131ktan sonra bunu Entiy framework code first y\u00f6ntemiyle nas\u0131l yapaca\u011f\u0131m\u0131z\u0131 anlataca\u011f\u0131m.","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:\/\/okankaradag.com\/en\/entity-framewok\/entity-framework-code-first-vs-sql-server-birebir-iliski\/","og_locale":"en_US","og_type":"article","og_title":"Entity Framework Code First Vs Sql Server: Birebir \u0130li\u015fki(One to one) - Okan Karada\u011f","og_description":"\u0130lk olarak Sql Server ile birebir ili\u015fkili bir veritaban\u0131 yapt\u0131ktan sonra bunu Entiy framework code first y\u00f6ntemiyle nas\u0131l yapaca\u011f\u0131m\u0131z\u0131 anlataca\u011f\u0131m.","og_url":"https:\/\/okankaradag.com\/en\/entity-framewok\/entity-framework-code-first-vs-sql-server-birebir-iliski\/","og_site_name":"Okan Karada\u011f","article_published_time":"2020-06-15T22:44:00+00:00","article_modified_time":"2021-06-16T11:40:18+00:00","og_image":[{"width":500,"height":258,"url":"https:\/\/okankaradag.com\/wp-content\/uploads\/2020\/06\/entity-framework.jpg","type":"image\/jpeg"}],"author":"Okan Karada\u011f","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Okan Karada\u011f","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/okankaradag.com\/asp-net\/asp-net-mvc\/entity-framework-code-first-vs-sql-server-birebir-iliski#article","isPartOf":{"@id":"https:\/\/okankaradag.com\/asp-net\/asp-net-mvc\/entity-framework-code-first-vs-sql-server-birebir-iliski"},"author":{"name":"Okan Karada\u011f","@id":"https:\/\/okankaradag.com\/#\/schema\/person\/0196919c5e3b6a496101ded872640d52"},"headline":"Entity Framework Code First Vs Sql Server: Birebir \u0130li\u015fki(One to one)","datePublished":"2020-06-15T22:44:00+00:00","dateModified":"2021-06-16T11:40:18+00:00","mainEntityOfPage":{"@id":"https:\/\/okankaradag.com\/asp-net\/asp-net-mvc\/entity-framework-code-first-vs-sql-server-birebir-iliski"},"wordCount":239,"commentCount":0,"publisher":{"@id":"https:\/\/okankaradag.com\/#\/schema\/person\/0196919c5e3b6a496101ded872640d52"},"keywords":["Birebir \u0130li\u015fki","EntityFramework","One To One"],"articleSection":["Asp.Net MVC","Entity Framewok"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/okankaradag.com\/asp-net\/asp-net-mvc\/entity-framework-code-first-vs-sql-server-birebir-iliski#respond"]}]},{"@type":"WebPage","@id":"https:\/\/okankaradag.com\/asp-net\/asp-net-mvc\/entity-framework-code-first-vs-sql-server-birebir-iliski","url":"https:\/\/okankaradag.com\/asp-net\/asp-net-mvc\/entity-framework-code-first-vs-sql-server-birebir-iliski","name":"Entity Framework Code First Vs Sql Server: Birebir \u0130li\u015fki(One to one) - Okan Karada\u011f","isPartOf":{"@id":"https:\/\/okankaradag.com\/#website"},"datePublished":"2020-06-15T22:44:00+00:00","dateModified":"2021-06-16T11:40:18+00:00","description":"\u0130lk olarak Sql Server ile birebir ili\u015fkili bir veritaban\u0131 yapt\u0131ktan sonra bunu Entiy framework code first y\u00f6ntemiyle nas\u0131l yapaca\u011f\u0131m\u0131z\u0131 anlataca\u011f\u0131m.","breadcrumb":{"@id":"https:\/\/okankaradag.com\/asp-net\/asp-net-mvc\/entity-framework-code-first-vs-sql-server-birebir-iliski#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/okankaradag.com\/asp-net\/asp-net-mvc\/entity-framework-code-first-vs-sql-server-birebir-iliski"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/okankaradag.com\/asp-net\/asp-net-mvc\/entity-framework-code-first-vs-sql-server-birebir-iliski#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/okankaradag.com\/"},{"@type":"ListItem","position":2,"name":"Entity Framework Code First Vs Sql Server: Birebir \u0130li\u015fki(One to one)"}]},{"@type":"WebSite","@id":"https:\/\/okankaradag.com\/#website","url":"https:\/\/okankaradag.com\/","name":"Okan Karada\u011f","description":"Programlama \u00dczerine","publisher":{"@id":"https:\/\/okankaradag.com\/#\/schema\/person\/0196919c5e3b6a496101ded872640d52"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/okankaradag.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/okankaradag.com\/#\/schema\/person\/0196919c5e3b6a496101ded872640d52","name":"Okan Karada\u011f","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/okankaradag.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ca08a5537d7e304914c37189abedd2a1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ca08a5537d7e304914c37189abedd2a1?s=96&d=mm&r=g","caption":"Okan Karada\u011f"},"logo":{"@id":"https:\/\/okankaradag.com\/#\/schema\/person\/image\/"},"sameAs":["https:\/\/okankaradag.com"],"url":"https:\/\/okankaradag.com\/en\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/okankaradag.com\/en\/wp-json\/wp\/v2\/posts\/104"}],"collection":[{"href":"https:\/\/okankaradag.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/okankaradag.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/okankaradag.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/okankaradag.com\/en\/wp-json\/wp\/v2\/comments?post=104"}],"version-history":[{"count":5,"href":"https:\/\/okankaradag.com\/en\/wp-json\/wp\/v2\/posts\/104\/revisions"}],"predecessor-version":[{"id":358,"href":"https:\/\/okankaradag.com\/en\/wp-json\/wp\/v2\/posts\/104\/revisions\/358"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/okankaradag.com\/en\/wp-json\/wp\/v2\/media\/108"}],"wp:attachment":[{"href":"https:\/\/okankaradag.com\/en\/wp-json\/wp\/v2\/media?parent=104"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/okankaradag.com\/en\/wp-json\/wp\/v2\/categories?post=104"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/okankaradag.com\/en\/wp-json\/wp\/v2\/tags?post=104"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}