{"id":13129,"date":"2020-02-03T23:11:04","date_gmt":"2020-02-03T23:11:04","guid":{"rendered":"https:\/\/www.gencayyildiz.com\/blog\/?p=13129"},"modified":"2020-02-03T23:26:54","modified_gmt":"2020-02-03T23:26:54","slug":"azureda-entity-framework-core-ile-migration-islemleri","status":"publish","type":"post","link":"https:\/\/www.gencayyildiz.com\/blog\/azureda-entity-framework-core-ile-migration-islemleri\/","title":{"rendered":"Azure\u2019da Entity Framework Core \u0130le Migration \u0130\u015flemleri"},"content":{"rendered":"

<\/div>\n

Merhaba,<\/p>\n

Bir \u00f6nceki Azure\u2019da Asp.NET Core API Projesi Yay\u0131nlamak<\/a> ba\u015fl\u0131kl\u0131 makalemde Azure’da bir Asp.NET Core API projesinin nas\u0131l yay\u0131nland\u0131\u011f\u0131n\u0131 ele alm\u0131\u015ft\u0131k. Bu i\u00e7eri\u011fimizde ise Azure bulutunda bulunan bir SQL veritaban\u0131na projede Code First yakla\u015f\u0131m\u0131 ile tasarlanm\u0131\u015f herhangi bir veritaban\u0131n\u0131n nas\u0131l migrate edilebilece\u011fini inceleyece\u011fiz.<\/p>\n

Ba\u015flarken<\/h3>\n

\u0130\u00e7eri\u011fimize ba\u015flarken yukar\u0131da adresi verilen \u00f6nceki makalemizde \u00f6rneklendirdi\u011fimiz proje \u00fczerinden devam edece\u011fimizi \u00f6ncelikle bildiriyorum.<\/p>\n

Azure’da SQL Veritaban\u0131 Olu\u015fturulmas\u0131<\/h3>\n

Her\u015feyden \u00f6nce Azure’da bir veritaban\u0131 olu\u015fturulmas\u0131 gerekmektedir. Bunun i\u00e7in https:\/\/portal.azure.com\/<\/a> adresine giriniz ve “Azure hizmetleri” alt\u0131nda “SQL Veritabanlar\u0131” sekmesine t\u0131klay\u0131n\u0131z.
\n $\"Azure\u2019da$ <\/a><\/p>\n

Ard\u0131ndan yeni bir SQL veritaban\u0131 olu\u015fturabilmek i\u00e7in ya sol \u00fcst k\u00f6\u015fedeki “Ekle” ya da sayfa ortas\u0131ndaki “SQL veritaban\u0131 olu\u015ftur” butonuna t\u0131klay\u0131n\u0131z. A\u00e7\u0131lan sayfay\u0131 a\u015fa\u011f\u0131daki gibi doldurunuz;
\n $\"Azure\u2019da$ <\/a>
\nYukar\u0131daki g\u00f6r\u00fcnt\u00fcde olan alanlar\u0131 a\u00e7\u0131klarsak e\u011fer;<\/p>\n\n\n\n\n\n\n\n\n\n\n
1 numaral\u0131 alan;<\/strong><\/td>\n Abonelik t\u00fcr\u00fcm\u00fcz\u00fc ifade etmektedir.<\/td>\n<\/tr>\n
2 numaral\u0131 alan;<\/strong><\/td>\n Kaynak grubunu ifade etmektedir. Kaynak grubu; bir Azure hesab\u0131 \u00fczerinde birden fazla uygulama ya da veritaban\u0131 s\u00f6z konusu olabilir. Burada her bir projeyi birbirinden ay\u0131rabilmek ve ilgili uygulamalar\u0131 birbirleriyle ba\u011fda\u015ft\u0131rabilmek i\u00e7in kaynak grubu bizlere bir isim alan\u0131\/namespace sa\u011flamaktad\u0131r. Dolay\u0131s\u0131yla bir \u00f6nceki makalemizde Azure’da yay\u0131nlad\u0131\u011f\u0131m\u0131z projemizin kaynak grubuyla ayn\u0131 ismi kullan\u0131yoruz.<\/td>\n<\/tr>\n
3 numaral\u0131 alan;<\/strong><\/td>\n Veritaban\u0131n\u0131n ad\u0131n\u0131 ifade etmektedir.<\/td>\n<\/tr>\n
4 numaral\u0131 alan;<\/strong><\/td>\n Veritaban\u0131 sunucusunu ifade etmektedir. Hemen alt\u0131ndaki “Yeni olu\u015ftur” alan\u0131na t\u0131klayarak sa\u011f tarafta a\u00e7\u0131lan sekme \u00fczerinden yeni sunucu bilgilerini girebiliriz.<\/td>\n<\/tr>\n
4.1 numaral\u0131 alan;<\/strong><\/td>\n Veritaban\u0131 sunucusunun ad\u0131.<\/td>\n<\/tr>\n
4.2 numaral\u0131 alan;<\/strong><\/td>\n Sunucu y\u00f6neticisi. Birnevi username.<\/td>\n<\/tr>\n
4.3 numaral\u0131 alan;<\/strong><\/td>\n Veritaban\u0131 eri\u015fim \u015fifresi.(1q2w3e!)<\/td>\n<\/tr>\n
4.4 numaral\u0131 alan;<\/strong><\/td>\n Sunucunun bar\u0131nd\u0131r\u0131laca\u011f\u0131 konum.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
Veritaban\u0131 sunucu bilgilerini girdikten sonra “Tamam” butonuna t\u0131klay\u0131n\u0131z ve ard\u0131ndan “G\u00f6zden ge\u00e7ir + olu\u015ftur” butonuna t\u0131klad\u0131ktan sonra a\u015fa\u011f\u0131daki ekranla kar\u015f\u0131la\u015facaks\u0131n\u0131z.
\n $\"Azure\u2019da$ <\/a>
\nBu ekranda da “Olu\u015ftur” butonuna t\u0131klad\u0131\u011f\u0131n\u0131z vakit SQL veritaban\u0131 olu\u015fturulacakt\u0131r… Olu\u015fturulduktan sonra a\u00e7\u0131lan sayfada “Kayna\u011fa Git” butonuna t\u0131klayarak ilgili veritaban\u0131n\u0131n portal\u0131na ula\u015fabilirsiniz.<\/p>\n
$\"Azure\u2019da$ <\/a><\/p>\n
Olu\u015fturulan veritaban\u0131na hangi IP’lerin eri\u015fip eri\u015femeyece\u011fini belirleyebilmek i\u00e7in g\u00fcvenlik duvar\u0131 ayar\u0131 yapmam\u0131z gerekmektedir. Bu ayar i\u00e7in “Sunucu g\u00fcvenlik duvar\u0131 ayarla” sekmesine t\u0131klayarak a\u00e7\u0131lan pencerede eri\u015fimine izin verilen IP de\u011ferlerinin yaz\u0131lmas\u0131 gerekmektedir.
\n $\"Azure\u2019da$ <\/a><\/p>\n
IP de\u011ferlerini yazd\u0131ktan sonra sol \u00fcst k\u00f6\u015fedeki “Kaydet” butonuna t\u0131klay\u0131n\u0131z. Bu i\u015flem neticesinde art\u0131k veritaban\u0131na eri\u015febilir ve Code First arac\u0131l\u0131\u011f\u0131yla t\u00fcm \u00e7al\u0131\u015fmay\u0131 migrate edebiliriz. Bunun i\u00e7in ilgili veritaban\u0131n\u0131n connection string \u00f6zelli\u011fini elde etmemiz gerekmektedir.
\n $\"Azure\u2019da$ <\/a>
\nConnection string’i elde edebilmek i\u00e7in yukar\u0131da g\u00f6r\u00fcld\u00fc\u011f\u00fc \u00fczere veritaban\u0131 portal\u0131 \u00fczerinden “Veritaban\u0131 ba\u011flant\u0131 dizelerini g\u00f6ster” linkine t\u0131klay\u0131n\u0131z.
\n $\"Azure\u2019da$ <\/a>
\nG\u00f6r\u00fcld\u00fc\u011f\u00fc \u00fczere olu\u015fturdu\u011fumuz ve temel ayarlar\u0131n\u0131 koordine etti\u011fimiz veritaban\u0131m\u0131za uygun connection string’i bu sayfa bizlere vermektedir.<\/p>\n
Bu ad\u0131m neticesinde Azure’da ki \u00e7al\u0131\u015fmam\u0131z sona ermi\u015f ve s\u0131ra proje \u00fczerinde gerekli konfig\u00fcrasyonlar\u0131 yapmaya gelmi\u015f bulunmaktad\u0131r.<\/p>\n
Uygulamada Connection String’in Ayarlanmas\u0131<\/h3>\n
Azure taraf\u0131nda elde edilen connection string de\u011ferini “Startup.cs” dosyas\u0131nda “ConfigureServices” metodu i\u00e7erisinde “AddDbContext” middleware’i ile a\u015fa\u011f\u0131daki gibi uygulamam\u0131za ekliyoruz.<\/p>\n
\r\n public class Startup\r\n {\r\n public void ConfigureServices(IServiceCollection services)\r\n {\r\n .\r\n .\r\n services.AddDbContext<AzureContext>(x => x.UseSqlServer("Server=tcp:azureexampledb.database.windows.net,1433;Initial Catalog=AzureExampleDB;Persist Security Info=False;User ID=gncy;Password=1q2w3e4r!;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;"));\r\n .\r\n .\r\n services.AddControllers();\r\n }\r\n\r\n public void Configure(IApplicationBuilder app, IWebHostEnvironment env)\r\n {\r\n .\r\n .\r\n .\r\n }\r\n }\r\n<\/pre>\n
Veritaban\u0131n\u0131n Migrate Edilmesi<\/h3>\n
T\u00fcm bu i\u015flemler neticesinde art\u0131k veritaban\u0131n\u0131 migrate edebiliriz.
\n $\"Azure\u2019da$ <\/a><\/p>\n
Uygulaman\u0131n Son Halini Azure’da Publish Etme<\/h3>\n
Uygulamam\u0131z\u0131n \u00f6nceki hali static verilerden ibaretti… Yap\u0131lan son \u00e7al\u0131\u015fmalar neticesinde g\u00fcncel halini kullanabilmek i\u00e7in veritaban\u0131ndan beslenir bir vaziyette publish etmemiz gerekmektedir.
\n $\"\"$ <\/a>
\nYukar\u0131daki g\u00f6rselden de g\u00f6r\u00fcld\u00fc\u011f\u00fc \u00fczere zaten bir \u00f6nceki makalede olu\u015fturdu\u011fumuz Azure profili \u00fczerinden direkt olarak “Publish” butonuna t\u0131klanmas\u0131 yeni s\u00fcr\u00fcm\u00fcn yay\u0131nlanmas\u0131 i\u00e7in yeterli olacakt\u0131r.<\/p>\n
Test Edelim<\/h3>\n
Azure’un bize vermi\u015f oldu\u011fu endpoint’i tetikleyerek testimizi ger\u00e7ekle\u015ftirebiliriz.
\n $\"Azure\u2019da$ <\/a><\/p>\n
G\u00f6rd\u00fc\u011f\u00fcn\u00fcz \u00fczere, gayet ba\u015far\u0131l\u0131 bir \u015fekilde \u00e7al\u0131\u015fmaktad\u0131r. \u0130lgili API’\u0131n \u00f6mr\u00fcn\u00fcn Azure’un insaf\u0131na kald\u0131\u011f\u0131n\u0131 bilmeniz kayd\u0131yla https:\/\/webapplication8820200112022315.azurewebsites.net\/api\/personel<\/a> adresine t\u0131klayarak birebir g\u00f6zlemleyebilmek i\u00e7in \u015fans\u0131n\u0131z\u0131 deneyebilirsiniz. <\/p>\n
\u0130lgilenenlerin faydalanmas\u0131 dile\u011fiyle…
\nSonraki yaz\u0131lar\u0131mda g\u00f6r\u00fc\u015fmek \u00fczere…
\n\u0130yi \u00e7al\u0131\u015fmalar…<\/p>\n","protected":false},"excerpt":{"rendered":"
Merhaba, Bir \u00f6nceki Azure\u2019da Asp.NET Core API Projesi Yay\u0131nlamak ba\u015fl\u0131kl\u0131 makalemde Azure’da bir Asp.NET Core API projesinin nas\u0131l yay\u0131nland\u0131\u011f\u0131n\u0131 ele alm\u0131\u015ft\u0131k. Bu i\u00e7eri\u011fimizde ise Azure bulutunda bulunan bir SQL veritaban\u0131na projede Code First yakla\u015f\u0131m\u0131...<\/p>\n","protected":false},"author":1,"featured_media":13125,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3103,3121,2914],"tags":[3124,3125,3123,3126,3122],"class_list":["post-13129","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-asp-net-core-3-1","category-azure","category-entity-framework-core","tag-azure-entity-framework-core","tag-azure-migration","tag-azure-migration-islemleri","tag-azure-sql-server","tag-azureda-entity-framework-core"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/13129","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=13129"}],"version-history":[{"count":47,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/13129\/revisions"}],"predecessor-version":[{"id":13193,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/13129\/revisions\/13193"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/media\/13125"}],"wp:attachment":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/media?parent=13129"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/categories?post=13129"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/tags?post=13129"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}