{"id":811,"date":"2020-06-24T10:14:48","date_gmt":"2020-06-24T07:14:48","guid":{"rendered":"http:\/\/localhost\/bilisimkurdu\/?p=811"},"modified":"2020-06-24T10:14:48","modified_gmt":"2020-06-24T07:14:48","slug":"net-core-ef-ile-mysql-veritabani-islemleri","status":"publish","type":"post","link":"http:\/\/localhost\/bilisimkurdu\/net-core-ef-ile-mysql-veritabani-islemleri\/","title":{"rendered":".NET Core EF ile MYSQL veritaban\u0131 i\u015flemleri"},"content":{"rendered":"\n<p>Merhaba Muhterem Ziyaret\u00e7ilerimiz,<\/p>\n\n\n\n<p>Bu yaz\u0131mda .NET Core projesi \u00fczerinden Entity Framework ile MYSQL veritaban\u0131 ile i\u015flem yapmay\u0131 anlatmaya \u00e7al\u0131\u015faca\u011f\u0131m.<\/p>\n\n\n\n<!--more-->\n\n\n\n<p>Proje Visual Studio ilr olu\u015fturulmu\u015fsa;<\/p>\n\n\n\n<p>Visual Studio ile projeyi a\u00e7t\u0131ktan sonra Tools -&gt; NuGet Package Manager -&gt; Package Manager Console a\u015famalar\u0131n\u0131 takip ederek a\u015fa\u011f\u0131daki komutlar\u0131 girerek Entitiy Framework paketleri y\u00fcklenir.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Install-Package Microsoft.EntityFrameworkCore.Design\nInstall-Package Microsoft.EntityFrameworkCore.Tools<\/code><\/pre>\n\n\n\n<p>E\u011fer Console ile olu\u015fturulmu\u015fsa;<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>dotnet add package Microsoft.EntityFrameworkCore.Design\ndotnet add package Microsoft.EntityFrameworkCore.Tools<\/code><\/pre>\n\n\n\n<p>.NET Core versiyonu 3.0&#8217;\u0131n alt\u0131ndaysa (&lt;.NET Core 3.0)<\/p>\n\n\n\n<p>Visual Studio:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Install-Package Pomelo.EntityFrameworkCore.MySql\n\nScaffold-DbContext \"Server=serverIPorName;Database=databaseName;User=userName;Password=pass;TreatTinyAsBoolean=true\" Pomelo.EntityFrameworkCore.MySql -OutputDir Models-f\n<\/code><\/pre>\n\n\n\n<p>Console:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>dotnet add package Pomelo.EntityFrameworkCore.MySql\n\ndotnet ef dbcontext scaffold \"Server=serverIPorName;Database=databaseName;User=userName;Password=password;TreatTinyAsBoolean=true;\" \"Pomelo.EntityFrameworkCore.MySql\"\n -o Models -f\n\n\/\/veya\ndotnet add package Pomelo.EntityFrameworkCore.MySql\n\ndotnet ef dbcontext scaffold \"server=serverIPorName;port=3306;user=root;password=mypass;database=database\" Pomelo.EntityFrameworkCore.MySql -o Models -f\n<\/code><\/pre>\n\n\n\n<p>.NET Core 3.0 ve \u00fczeri ise:<\/p>\n\n\n\n<p>Visual Studio:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Install-Package MySql.Data.EntityFrameworkCore\n\nScaffold-DbContext \"server=serverIPorAdress;port=3306;user=userName;password=mypass;database=databaseName\" MySql.Data.EntityFrameworkCore -OutputDir Models -f<\/code><\/pre>\n\n\n\n<p>Console:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>dotnet add package MySql.Data.EntityFrameworkCore\n\ndotnet ef dbcontext scaffold \"server=serverIPorAdress;port=3306;user=userName;password=mypass;database=databaseName\" MySql.Data.EntityFrameworkCore -o Models -f<\/code><\/pre>\n\n\n\n<p>komutlar\u0131 girilerek gerekli paketler y\u00fcklenip ba\u011flant\u0131 sa\u011flan\u0131r.<\/p>\n\n\n\n<p>Sorgu i\u015flemleri i\u00e7in a\u015fa\u011f\u0131daki linkleri inceleyebilirsiniz.<\/p>\n\n\n\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"C# ile MYSQL veri taban\u0131na ba\u011flanmaya \u00e7al\u0131\u015ft\u0131k\" width=\"1180\" height=\"664\" src=\"https:\/\/www.youtube.com\/embed\/7phgYQiaXzM?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<p><a href=\"https:\/\/bilisimkurdu.github.io\/c-entity-framework-uzerinden-select-ve-like-deyimleri\/\">https:\/\/bilisimkurdu.github.io\/c-entity-framework-uzerinden-select-ve-like-deyimleri\/<\/a><\/p>\n\n\n\n<p>Not : Context olu\u015fturduktan sonra .NET Core Entitiy framework sorgu i\u015flemleri \u015fu \u015fekilde yap\u0131l\u0131r:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>contextName.TableName\n\n\/\/\u00d6rnek Context1 contexti ve cntx nesnesi ve Test tablosu oldu\u011funu d\u00fc\u015f\u00fcn\u00fcrsek.\n\nContext1 cntx = new Context1 ();\ncntx.Test<\/code><\/pre>\n\n\n\n<p>E\u011fer bu yaz\u0131yla ili\u015fkin anlatamad\u0131\u011f\u0131m\\anla\u015f\u0131lamayan konular varsa yaz\u0131n\u0131n alt\u0131na yorum yapabilirsiniz.<\/p>\n\n\n\n<p>\u0130yi g\u00fcnler.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Merhaba Muhterem Ziyaret\u00e7ilerimiz, Bu yaz\u0131mda .NET Core projesi \u00fczerinden Entity Framework ile MYSQL veritaban\u0131 ile i\u015flem yapmay\u0131 anlatmaya \u00e7al\u0131\u015faca\u011f\u0131m.<\/p>\n","protected":false},"author":3,"featured_media":813,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[89,90,96,84,85],"tags":[106,107,145,242,244,266,293,335,347,371,490,542,621,637,643],"_links":{"self":[{"href":"http:\/\/localhost\/bilisimkurdu\/wp-json\/wp\/v2\/posts\/811"}],"collection":[{"href":"http:\/\/localhost\/bilisimkurdu\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/localhost\/bilisimkurdu\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/localhost\/bilisimkurdu\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"http:\/\/localhost\/bilisimkurdu\/wp-json\/wp\/v2\/comments?post=811"}],"version-history":[{"count":0,"href":"http:\/\/localhost\/bilisimkurdu\/wp-json\/wp\/v2\/posts\/811\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/localhost\/bilisimkurdu\/wp-json\/wp\/v2\/media\/813"}],"wp:attachment":[{"href":"http:\/\/localhost\/bilisimkurdu\/wp-json\/wp\/v2\/media?parent=811"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/localhost\/bilisimkurdu\/wp-json\/wp\/v2\/categories?post=811"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/localhost\/bilisimkurdu\/wp-json\/wp\/v2\/tags?post=811"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}