<\/div>\n

Merhaba,<\/p>\n

Bir \u00f6nceki Entity Framework \u0130le Code First Yakla\u015f\u0131m\u0131<\/a> ba\u015fl\u0131kl\u0131 yaz\u0131mda Entity Framework – Code First yakla\u015f\u0131m\u0131na giri\u015f yaparak nas\u0131l veritaban\u0131 ve tablo olu\u015fturuldu\u011funa ve bu s\u00fcre\u00e7te nelere dikkat edilmesi gerekti\u011fine detayl\u0131ca g\u00f6z atm\u0131\u015ft\u0131k. Bu yaz\u0131m\u0131zda ise Code First yap\u0131s\u0131yla tablolar aras\u0131nda Foreign Key ili\u015fkisi kurmay\u0131 inceleyece\u011fiz.<\/p>\n

\u00d6rneklendirmemi bir okul senaryosu \u00fczerine kuraca\u011f\u0131m. Okul veritaban\u0131 olu\u015fturacak, i\u00e7erisinde \u00f6\u011fretmen ve derslere \u00f6zel tablolar bar\u0131nd\u0131raca\u011f\u0131m. \u0130\u015fte gerekli yerlerde senaryoyu d\u00fczenleyip ekleme \u00e7\u0131karma yaparsak nedenini yaz\u0131n\u0131n ak\u0131\u015f\u0131ndan yakalayacaks\u0131n\u0131zd\u0131r.<\/p>\n

\u00d6ncelikle \u00f6\u011fretmenler ve derslere \u00f6zel Entity’lerimizi olu\u015ftural\u0131m. Bu entityler veritaban\u0131m\u0131zda tablo g\u00f6revi g\u00f6recek s\u0131n\u0131flard\u0131r.<\/p>\n

\r\n    class Ogretmen\r\n    {\r\n        public int OgretmenID { get; set; }\r\n        public string Adi { get; set; }\r\n        public string SoyAdi { get; set; }\r\n    }\r\n<\/pre>\n\r\n    class Ders\r\n    {\r\n        public int DersID { get; set; }\r\n        public string DersAdi { get; set; }\r\n    }\r\n<\/pre>\nG\u00f6rd\u00fc\u011f\u00fcn\u00fcz gibi \u00f6\u011fretmen ve ders tablolar\u0131m\u0131 nitelendiren s\u0131n\u0131flar\u0131 olu\u015fturmu\u015f oldum.<\/p>\n
\u015eimdi bu tablolar aras\u0131nda ili\u015fkiyi \u015fu mant\u0131kla kuraca\u011f\u0131z.<\/p>\n
Her \u00f6\u011fretmenin bir dersi mevcuttur lakin her dersin birden fazla \u00f6\u011fretmeni olabilir.<\/p>\n
Olaya bu mant\u0131k a\u00e7\u0131s\u0131ndan bak\u0131nca \u00f6\u011fretmenleri a\u015fa\u011f\u0131daki gibi g\u00fcncellemeliyiz.<\/p>\n\r\n    class Ogretmen\r\n    {\r\n        public int OgretmenID { get; set; }\r\n        public string Adi { get; set; }\r\n        public string SoyAdi { get; set; }\r\n        public int DersID { get; set; }\r\n        public virtual Ders Ders { get; set; }\r\n    }\r\n<\/pre>\nG\u00f6rd\u00fc\u011f\u00fcn\u00fcz gibi her \u00f6\u011fretmenin bir dersi mevcut oldu\u011fundan dolay\u0131 Ders tipinde bir Ders propertysi, int tipinde de DersID propertysi ekledim.
\nAyn\u0131 mant\u0131kla dersleride a\u015fa\u011f\u0131daki gibi g\u00fcncellemeliyiz.<\/p>\n\r\n    class Ders\r\n    {\r\n        public int DersID { get; set; }\r\n        public string DersAdi { get; set; }\r\n        public virtual List<Ogretmen> Ogretmenler { get; set; }\r\n    }\r\n<\/pre>\nMadem her bir dersin birden fazla \u00f6\u011fretmeni olabilir, bir \u00f6\u011fretmenler tipinde liste \u015feklinde property tuttum.<\/p>\n
\u015eimdi bu yapt\u0131\u011f\u0131m i\u015flemlerle server aras\u0131nda ba\u011flant\u0131y\u0131 olu\u015fturacak Context’timizi yazal\u0131m.<\/p>\n\r\n    class OkulDbContext : DbContext\r\n    {\r\n        public DbSet<Ogretmen> Ogretmenler { get; set; }\r\n        public DbSet<Ders> Dersler { get; set; }\r\n    }\r\n<\/pre>\nArd\u0131ndan veritaban\u0131 olu\u015fturmas\u0131 i\u00e7in server bilgilerimizi config dosyas\u0131nda olu\u015ftural\u0131m.<\/p>\n\r\n  <connectionStrings>\r\n    <add name="OkulDbContext" connectionString="Server=.;Database=OkulVeriTabani;Trusted_Connection=true;" providerName="System.Data.SqlClient"\/>\r\n  <\/connectionStrings>\r\n<\/pre>\nVe son olarak Context s\u0131n\u0131f\u0131m\u0131zdan bir nesne olu\u015fturup, gerekli veritaban\u0131 ve tablolar\u0131m\u0131z\u0131 olu\u015ftural\u0131m.<\/p>\n\r\n    class Program\r\n    {\r\n        static void Main(string[] args)\r\n        {\r\n            OkulDbContext Veri = new OkulDbContext();\r\n            Veri.Database.Create();\r\n        }\r\n    }\r\n<\/pre>\nSQL Server’\u0131 incelersek e\u011fer,
\n<\/a>Entity Framework – Code First \u0130le Tablolar\u0131 \u0130li\u015fkilendirme<\/p><\/div>
\nG\u00f6rd\u00fc\u011f\u00fcn\u00fcz gibi veritaban\u0131 ve tablolar\u0131m\u0131z olu\u015fturulmu\u015ftur. Bunlar\u0131n yan\u0131nda tablolar\u0131n aras\u0131ndaki ili\u015fkide a\u015fikard\u0131r.
\nDiyagramdan da incelemek gerekirse,
\n<\/a>Entity Framework – Code First \u0130le Tablolar\u0131 \u0130li\u015fkilendirme<\/p><\/div>
\nG\u00f6rd\u00fc\u011f\u00fcn\u00fcz gibi tablolar aras\u0131nda bu \u015fekilde ili\u015fki kurulmaktad\u0131r.<\/p>\n
Bir sonraki yaz\u0131mda g\u00f6r\u00fc\u015fmek \u00fczere…
\n\u0130yi \u00e7al\u0131\u015fmalar dilerim…<\/p>\n","protected":false},"excerpt":{"rendered":"
Merhaba, Bir \u00f6nceki Entity Framework \u0130le Code First Yakla\u015f\u0131m\u0131 ba\u015fl\u0131kl\u0131 yaz\u0131mda Entity Framework – Code First yakla\u015f\u0131m\u0131na giri\u015f yaparak nas\u0131l veritaban\u0131 ve tablo olu\u015fturuldu\u011funa ve bu s\u00fcre\u00e7te nelere dikkat edilmesi gerekti\u011fine detayl\u0131ca g\u00f6z atm\u0131\u015ft\u0131k....<\/p>\n","protected":false},"author":1,"featured_media":3739,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[955],"tags":[967,952,964,965,963,966],"class_list":["post-3744","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-entity-framework","tag-code-firset-constraint","tag-code-first","tag-ef-constraint","tag-ef-foreign-key","tag-entity-framework","tag-iliskiler"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/3744","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/comments?post=3744"}],"version-history":[{"count":0,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/3744\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/media\/3739"}],"wp:attachment":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/media?parent=3744"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/categories?post=3744"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/tags?post=3744"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}