{"id":31980,"date":"2025-10-16T09:01:21","date_gmt":"2025-10-16T06:01:21","guid":{"rendered":"https:\/\/fatihsoysal.com\/blog\/c-selenium-testleri-ile-mysql-veritabani-baglantisi-rehberi\/"},"modified":"2025-10-16T09:01:21","modified_gmt":"2025-10-16T06:01:21","slug":"c-selenium-testleri-ile-mysql-veritabani-baglantisi-rehberi","status":"publish","type":"post","link":"https:\/\/fatihsoysal.com\/blog\/c-selenium-testleri-ile-mysql-veritabani-baglantisi-rehberi\/","title":{"rendered":"C# Selenium Testleri ile MySQL Veritaban\u0131 Ba\u011flant\u0131s\u0131 Rehberi"},"content":{"rendered":"<p><body><\/p>\n<style>\n        body {\n            font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;\n            line-height: 1.6;\n            color: #333;\n            max-width: 900px;\n            margin: 20px auto;\n            padding: 0 15px;\n            background-color: #f9f9f9;\n        }<\/p>\n<p>        h2, h3 {\n            color: #2c3e50;\n            margin-top: 30px;\n            margin-bottom: 15px;\n            border-bottom: 2px solid #e0e0e0;\n            padding-bottom: 5px;\n        }<\/p>\n<p>        h2 {\n            font-size: 2em;\n        }<\/p>\n<p>        h3 {\n            font-size: 1.5em;\n        }<\/p>\n<p>        p {\n            margin-bottom: 15px;\n            text-align: justify;\n        }<\/p>\n<p>        ul, ol {\n            margin-bottom: 15px;\n            padding-left: 25px;\n        }<\/p>\n<p>        li {\n            margin-bottom: 8px;\n        }<\/p>\n<p>        pre {\n            background-color: #e8f0fe;\n            border: 1px solid #cceeff;\n            padding: 15px;\n            border-radius: 5px;\n            overflow-x: auto;\n            margin-bottom: 20px;\n        }<\/p>\n<p>        code {\n            font-family: 'Consolas', 'Monaco', monospace;\n            font-size: 0.9em;\n            color: #0055a4;\n        }<\/p>\n<p>        .info-box {\n            background-color: #d9edf7;\n            border-left: 5px solid #31708f;\n            padding: 15px;\n            margin: 20px 0;\n            border-radius: 4px;\n            color: #31708f;\n        }<\/p>\n<p>        .warning-box {\n            background-color: #fcf8e3;\n            border-left: 5px solid #8a6d3b;\n            padding: 15px;\n            margin: 20px 0;\n            border-radius: 4px;\n            color: #8a6d3b;\n        }<\/p>\n<p>        table {\n            width: 100%;\n            border-collapse: collapse;\n            margin-bottom: 20px;\n            background-color: #fff;\n        }<\/p>\n<p>        th, td {\n            border: 1px solid #ddd;\n            padding: 10px;\n            text-align: left;\n        }<\/p>\n<p>        th {\n            background-color: #f2f2f2;\n            font-weight: bold;\n        }<\/p>\n<p>        \/* Mobil uyumluluk i\u00e7in medya sorgular\u0131 *\/\n        @media (max-width: 768px) {\n            body {\n                margin: 10px auto;\n                padding: 0 10px;\n            }<\/p>\n<p>            h2 {\n                font-size: 1.6em;\n            }<\/p>\n<p>            h3 {\n                font-size: 1.3em;\n            }<\/p>\n<p>            pre {\n                padding: 10px;\n            }<\/p>\n<p>            table, thead, tbody, th, td, tr {\n                display: block;\n            }<\/p>\n<p>            thead tr {\n                position: absolute;\n                top: -9999px;\n                left: -9999px;\n            }<\/p>\n<p>            tr {\n                border: 1px solid #ccc;\n                margin-bottom: 10px;\n            }<\/p>\n<p>            td {\n                border: none;\n                border-bottom: 1px solid #eee;\n                position: relative;\n                padding-left: 50%;\n                text-align: right;\n            }<\/p>\n<p>            td:before {\n                position: absolute;\n                top: 6px;\n                left: 6px;\n                width: 45%;\n                padding-right: 10px;\n                white-space: nowrap;\n                content: attr(data-label);\n                font-weight: bold;\n                text-align: left;\n            }\n        }\n    <\/style>\n<p>Selenium testlerinizi C# kullanarak MySQL veritaban\u0131n\u0131zla nas\u0131l entegre edece\u011finizi merak m\u0131 ediyorsunuz? Bu kapsaml\u0131 rehber, veritaban\u0131 ba\u011flant\u0131lar\u0131n\u0131 ad\u0131m ad\u0131m kurmaktan, test verilerini y\u00f6netmeye ve otomasyon stratejilerinizi geli\u015ftirmeye kadar her \u015feyi ele alarak size yol g\u00f6sterecek.<\/p>\n<p>G\u00fcn\u00fcm\u00fczde yaz\u0131l\u0131m test otomasyonu, \u00fcr\u00fcn kalitesini sa\u011flaman\u0131n ayr\u0131lmaz bir par\u00e7as\u0131 haline gelmi\u015ftir. Selenium, web tabanl\u0131 uygulamalar\u0131n kullan\u0131c\u0131 aray\u00fcz\u00fc (UI) testlerini otomatikle\u015ftirmek i\u00e7in sekt\u00f6r standard\u0131 bir ara\u00e7t\u0131r. Ancak sadece UI d\u00fczeyinde yap\u0131lan testler, genellikle bir uygulaman\u0131n t\u00fcm katmanlar\u0131ndaki mant\u0131\u011f\u0131 do\u011frulama konusunda yetersiz kalabilir. \u00d6zellikle karma\u015f\u0131k i\u015f mant\u0131\u011f\u0131na sahip uygulamalarda, kullan\u0131c\u0131 aray\u00fcz\u00fc eylemlerinin veritaban\u0131nda do\u011fru sonu\u00e7lar do\u011furup do\u011furmad\u0131\u011f\u0131n\u0131 kontrol etmek kritik \u00f6neme sahiptir. \u0130\u015fte bu noktada, Selenium testlerini bir veritaban\u0131 ile entegre etme ihtiyac\u0131 ortaya \u00e7\u0131kar.<\/p>\n<p>Bir e-ticaret uygulamas\u0131nda yeni bir \u00fcr\u00fcn ekledi\u011finizi veya bir kullan\u0131c\u0131n\u0131n sipari\u015f verdi\u011fini d\u00fc\u015f\u00fcnelim. Selenium ile bu i\u015flemlerin UI \u00fczerinden ba\u015far\u0131l\u0131 bir \u015fekilde ger\u00e7ekle\u015fti\u011fini do\u011frulayabilirsiniz. Ancak, \u00fcr\u00fcn\u00fcn stok bilgisinin ger\u00e7ekten g\u00fcncellendi\u011fini veya sipari\u015fin t\u00fcm detaylar\u0131yla veritaban\u0131na do\u011fru bir \u015fekilde kaydedildi\u011fini nas\u0131l anlars\u0131n\u0131z? \u0130\u015fte tam da bu t\u00fcr senaryolarda, testlerinizin do\u011frudan MySQL veritaban\u0131na ba\u011flan\u0131p ilgili verileri sorgulamas\u0131, g\u00fcncellemeler yapmas\u0131 veya yeni veriler eklemesi gerekebilir. Bu sayede, testleriniz sadece \u00f6n y\u00fczdeki g\u00f6rsel de\u011fi\u015fiklikleri de\u011fil, ayn\u0131 zamanda arka plandaki veri b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc ve i\u015f mant\u0131\u011f\u0131n\u0131 da do\u011frular.<\/p>\n<p>Veritaban\u0131 ba\u011flant\u0131s\u0131, test senaryolar\u0131n\u0131z i\u00e7in dinamik veri sa\u011flaman\u0131n da etkili bir yoludur. \u00d6rne\u011fin, farkl\u0131 kullan\u0131c\u0131 rolleriyle (admin, m\u00fc\u015fteri, sat\u0131c\u0131) giri\u015f yapman\u0131z gereken bir\u00e7ok test senaryonuz olabilir. Bu kullan\u0131c\u0131 bilgilerini kod i\u00e7inde sabit tutmak yerine, bir veritaban\u0131ndan dinamik olarak \u00e7ekmek, testlerinizi daha esnek ve y\u00f6netilebilir hale getirir. Her test \u00e7al\u0131\u015ft\u0131rmas\u0131nda farkl\u0131 test verileri kullanmak, test kapsam\u0131n\u0131 geni\u015fletir ve hatalar\u0131n erken a\u015famada tespit edilmesine yard\u0131mc\u0131 olur. Ayr\u0131ca, testlerinizi belirli bir duruma getirmek i\u00e7in veritaban\u0131n\u0131 temizlemek veya ba\u015flang\u0131\u00e7 verilerini y\u00fcklemek (test setup\/teardown) de veritaban\u0131 ba\u011flant\u0131lar\u0131 sayesinde kolayca ger\u00e7ekle\u015ftirilebilir. Bu strateji, testlerin ba\u011f\u0131ms\u0131zl\u0131\u011f\u0131n\u0131 art\u0131r\u0131r ve tekrar \u00e7al\u0131\u015ft\u0131r\u0131labilirli\u011fini sa\u011flar. Sonu\u00e7 olarak, C# ile yaz\u0131lm\u0131\u015f Selenium testlerinize MySQL veritaban\u0131 ba\u011flant\u0131s\u0131n\u0131 entegre etmek, test otomasyon stratejinizi g\u00fc\u00e7lendirir, testlerinizin g\u00fcvenilirli\u011fini art\u0131r\u0131r ve uygulaman\u0131z\u0131n derinlemesine do\u011frulanmas\u0131na olanak tan\u0131r.<\/p>\n<h3>C# ve MySQL Entegrasyonunun Temelleri: Nelere \u0130htiyac\u0131m\u0131z Var?<\/h3>\n<p>C# ile MySQL veritaban\u0131na ba\u011flanmak i\u00e7in Microsoft&#8217;un ADO.NET (ActiveX Data Objects) teknolojisini kullan\u0131r\u0131z. ADO.NET, veritaban\u0131 ba\u011flant\u0131s\u0131, komut y\u00fcr\u00fctme ve veri okuma gibi i\u015flemleri y\u00f6netmek i\u00e7in bir dizi s\u0131n\u0131f ve aray\u00fcz sa\u011flar. MySQL \u00f6zelinde ise, bu genel ADO.NET \u00e7er\u00e7evesini MySQL&#8217;e \u00f6zg\u00fc i\u015flevsellikle birle\u015ftiren bir sa\u011flay\u0131c\u0131ya ihtiyac\u0131m\u0131z vard\u0131r. \u0130\u015fte tam da burada &#8220;MySql.Data&#8221; isimli NuGet paketi devreye girer. Bu paket, C# uygulamalar\u0131n\u0131z\u0131n MySQL sunucular\u0131yla sorunsuz bir \u015fekilde ileti\u015fim kurmas\u0131n\u0131 sa\u011flayan resmi MySQL Connector\/NET s\u00fcr\u00fcc\u00fcs\u00fcd\u00fcr.<\/p>\n<p>Entegrasyona ba\u015flamadan \u00f6nce, projenizin bu temel bile\u015fenlere sahip oldu\u011fundan emin olmal\u0131s\u0131n\u0131z:<\/p>\n<ol>\n<li><strong>Visual Studio:<\/strong> C# kodu yazmak ve y\u00f6netmek i\u00e7in tercih edilen entegre geli\u015ftirme ortam\u0131 (IDE).<\/li>\n<li><strong>.NET Framework veya .NET Core SDK:<\/strong> Projenizin hedefledi\u011fi .NET versiyonu y\u00fckl\u00fc olmal\u0131.<\/li>\n<li><strong>MySQL Sunucusu:<\/strong> Test etmek istedi\u011finiz veritaban\u0131n\u0131n \u00e7al\u0131\u015ft\u0131\u011f\u0131 bir MySQL sunucusu. Bu, yerel makinenizde kurulu bir sunucu (\u00f6rne\u011fin XAMPP, WAMP, MAMP ile gelen) veya uzaktan eri\u015filebilir bir sunucu olabilir.<\/li>\n<li><strong>MySql.Data NuGet Paketi:<\/strong> Bu paket, C# projenizin MySQL ile ileti\u015fim kurmas\u0131n\u0131 sa\u011flayan ana bile\u015fendir.<\/li>\n<\/ol>\n<p>MySql.Data paketini projenize eklemek olduk\u00e7a basittir. Visual Studio&#8217;da projenizi a\u00e7t\u0131ktan sonra, \u00c7\u00f6z\u00fcm Gezgini&#8217;nde projenize sa\u011f t\u0131klay\u0131p &#8220;NuGet Paketlerini Y\u00f6net&#8230;&#8221; se\u00e7ene\u011fini se\u00e7ebilirsiniz. A\u00e7\u0131lan pencerede &#8220;G\u00f6zat&#8221; sekmesine gelerek arama kutucu\u011funa &#8220;MySql.Data&#8221; yaz\u0131p arama yap\u0131n. \u00c7\u0131kan sonu\u00e7lardan &#8220;MySql.Data&#8221; paketini se\u00e7ip &#8220;Y\u00fckle&#8221; butonuna t\u0131klayarak projenize dahil edebilirsiniz. Bu ad\u0131m\u0131 tamamlad\u0131\u011f\u0131n\u0131zda, projeniz MySQL veritaban\u0131 i\u015flemleri i\u00e7in gerekli referanslara sahip olacakt\u0131r. Bu temel haz\u0131rl\u0131klar tamamland\u0131ktan sonra, art\u0131k veritaban\u0131 ba\u011flant\u0131s\u0131 kurmaya ve test senaryolar\u0131n\u0131zda kullanmaya haz\u0131rs\u0131n\u0131z.<\/p>\n<div class=\"info-box\">\n        Uzman \u0130pucu: MySql.Data paketini y\u00fcklarken, projenizin hedefledi\u011fi .NET versiyonu ile uyumlu bir s\u00fcr\u00fcm se\u00e7ti\u011finizden emin olun. Genellikle en g\u00fcncel kararl\u0131 s\u00fcr\u00fcm\u00fc tercih etmek iyi bir yakla\u015f\u0131md\u0131r.\n    <\/div>\n<p>Visual Studio ile NuGet paketini eklemek i\u00e7in a\u015fa\u011f\u0131daki komutu da Paket Y\u00f6neticisi Konsolu&#8217;nda kullanabilirsiniz:<\/p>\n<pre><code>\nInstall-Package MySql.Data\n    <\/pre>\n<p><\/code><\/p>\n<h2>Ad\u0131m Ad\u0131m MySQL Veritaban\u0131 Ba\u011flant\u0131s\u0131 Nas\u0131l Kurulur?<\/h2>\n<p>C# projenizde MySQL veritaban\u0131 ba\u011flant\u0131s\u0131 kurmak, belirli ad\u0131mlar\u0131 takip etmeyi gerektirir. Bu ad\u0131mlar, veritaban\u0131na ba\u011flant\u0131 a\u00e7maktan, komutlar\u0131 y\u00fcr\u00fctmeye ve sonu\u00e7lar\u0131 i\u015flemeye kadar uzan\u0131r. Bir e-ticaret uygulamas\u0131nda \u00fcr\u00fcn stoklar\u0131n\u0131 do\u011frulamak istedi\u011fimiz bir senaryo \u00fczerinden ilerleyelim. Amac\u0131m\u0131z, Selenium ile bir \u00fcr\u00fcn\u00fcn sepete eklenmesi veya sat\u0131n al\u0131nmas\u0131 i\u015fleminden sonra, veritaban\u0131ndan \u00fcr\u00fcn\u00fcn stok miktar\u0131n\u0131n do\u011fru bir \u015fekilde g\u00fcncellenip g\u00fcncellenmedi\u011fini kontrol etmek olsun.<\/p>\n<p>\u0130lk olarak, projenizde <code>MySql.Data<\/code> ad alan\u0131n\u0131 (namespace) import etmeniz gerekir:<\/p>\n<pre><code>\nusing MySql.Data.MySqlClient;\n    <\/pre>\n<p><\/code><\/p>\n<p>Ard\u0131ndan, veritaban\u0131 ba\u011flant\u0131 bilgilerini i\u00e7eren bir ba\u011flant\u0131 dizesi (connection string) olu\u015fturman\u0131z gerekecek. Bu dize, MySQL sunucusunun adresi, veritaban\u0131 ad\u0131, kullan\u0131c\u0131 ad\u0131 ve \u015fifre gibi bilgileri i\u00e7erir. G\u00fcvenlik nedeniyle bu bilgileri do\u011frudan kod i\u00e7inde sabit de\u011ferler olarak tutmak yerine, bir yap\u0131land\u0131rma dosyas\u0131ndan (\u00f6rne\u011fin <code>appsettings.json<\/code> veya <code>Web.config<\/code>) okumak daha iyi bir uygulamad\u0131r. Ancak, bu \u00f6rnek i\u00e7in do\u011frudan kod i\u00e7inde g\u00f6sterece\u011fiz:<\/p>\n<pre><code>\npublic static class DbConnector\n{\n    private static string ConnectionString = \"Server=localhost;Port=3306;Database=ecommerce_db;Uid=root;Pwd=my_password;\";\n\n    public static MySqlConnection GetConnection()\n    {\n        return new MySqlConnection(ConnectionString);\n    }\n\n    public static int GetProductStock(string productName)\n    {\n        int stock = -1;\n        using (MySqlConnection connection = GetConnection())\n        {\n            try\n            {\n                connection.Open();\n                Console.WriteLine(\"Veritaban\u0131 ba\u011flant\u0131s\u0131 ba\u015far\u0131yla a\u00e7\u0131ld\u0131.\");\n\n                string query = \"SELECT stock_quantity FROM products WHERE product_name = @productName;\";\n                using (MySqlCommand command = new MySqlCommand(query, connection))\n                {\n                    command.Parameters.AddWithValue(\"@productName\", productName);\n                    object result = command.ExecuteScalar();\n                    if (result != null && result != DBNull.Value)\n                    {\n                        stock = Convert.ToInt32(result);\n                    }\n                }\n            }\n            catch (MySqlException ex)\n            {\n                Console.WriteLine($\"Veritaban\u0131 hatas\u0131 olu\u015ftu: {ex.Message}\");\n                \/\/ Hata detaylar\u0131n\u0131 loglayabilir veya daha ayr\u0131nt\u0131l\u0131 i\u015flem yapabilirsiniz.\n            }\n            finally\n            {\n                if (connection.State == System.Data.ConnectionState.Open)\n                {\n                    connection.Close();\n                    Console.WriteLine(\"Veritaban\u0131 ba\u011flant\u0131s\u0131 kapat\u0131ld\u0131.\");\n                }\n            }\n        }\n        return stock;\n    }\n\n    public static void UpdateProductStock(string productName, int newStock)\n    {\n        using (MySqlConnection connection = GetConnection())\n        {\n            try\n            {\n                connection.Open();\n                Console.WriteLine(\"Veritaban\u0131 ba\u011flant\u0131s\u0131 ba\u015far\u0131yla a\u00e7\u0131ld\u0131.\");\n\n                string query = \"UPDATE products SET stock_quantity = @newStock WHERE product_name = @productName;\";\n                using (MySqlCommand command = new MySqlCommand(query, connection))\n                {\n                    command.Parameters.AddWithValue(\"@newStock\", newStock);\n                    command.Parameters.AddWithValue(\"@productName\", productName);\n                    int rowsAffected = command.ExecuteNonQuery();\n                    Console.WriteLine($\"{rowsAffected} sat\u0131r g\u00fcncellendi.\");\n                }\n            }\n            catch (MySqlException ex)\n            {\n                Console.WriteLine($\"Veritaban\u0131 g\u00fcncelleme hatas\u0131 olu\u015ftu: {ex.Message}\");\n            }\n            finally\n            {\n                if (connection.State == System.Data.ConnectionState.Open)\n                {\n                    connection.Close();\n                    Console.WriteLine(\"Veritaban\u0131 ba\u011flant\u0131s\u0131 kapat\u0131ld\u0131.\");\n                }\n            }\n        }\n    }\n}\n    <\/pre>\n<p><\/code><\/p>\n<p>Yukar\u0131daki <code>DbConnector<\/code> s\u0131n\u0131f\u0131, veritaban\u0131 ba\u011flant\u0131s\u0131n\u0131 y\u00f6netmek ve \u00fcr\u00fcn stok bilgisi gibi temel i\u015flemleri ger\u00e7ekle\u015ftirmek i\u00e7in bir katman sa\u011flar. <code>GetProductStock<\/code> metodu, belirli bir \u00fcr\u00fcn\u00fcn g\u00fcncel stok miktar\u0131n\u0131 veritaban\u0131ndan \u00e7ekerken, <code>UpdateProductStock<\/code> metodu ise \u00fcr\u00fcn\u00fcn stok miktar\u0131n\u0131 g\u00fcnceller. Bu metotlar\u0131 Selenium testlerinizde kolayca kullanabilirsiniz. \u00d6rne\u011fin, bir \u00fcr\u00fcn\u00fcn sat\u0131n alma i\u015flemi \u00f6ncesi ve sonras\u0131 stok miktar\u0131n\u0131 kar\u015f\u0131la\u015ft\u0131rmak i\u00e7in a\u015fa\u011f\u0131daki gibi bir test senaryosu yazabilirsiniz:<\/p>\n<pre><code>\nusing NUnit.Framework;\nusing OpenQA.Selenium;\nusing OpenQA.Selenium.Chrome;\nusing System.Threading; \/\/ Thread.Sleep i\u00e7in\n\n[TestFixture]\npublic class ProductStockTests\n{\n    private IWebDriver driver;\n\n    [SetUp]\n    public void Setup()\n    {\n        driver = new ChromeDriver();\n        driver.Manage().Window.Maximize();\n        driver.Navigate().GoToUrl(\"http:\/\/your-ecommerce-app.com\/products\/example-product\"); \/\/ \u00d6rnek \u00fcr\u00fcn sayfas\u0131\n    }\n\n    [Test]\n    public void VerifyProductStockUpdateAfterPurchase()\n    {\n        string productName = \"Example Product X\"; \/\/ Test edece\u011fimiz \u00fcr\u00fcn ad\u0131\n        int initialStock = DbConnector.GetProductStock(productName);\n        Assert.AreNotEqual(-1, initialStock, \"Ba\u015flang\u0131\u00e7 stok bilgisi veritaban\u0131ndan al\u0131namad\u0131.\");\n        Console.WriteLine($\"Test \u00f6ncesi {productName} sto\u011fu: {initialStock}\");\n\n        \/\/ Selenium ile \u00fcr\u00fcn\u00fc sepete ekleme ve sat\u0131n alma ad\u0131mlar\u0131\n        \/\/ Bu k\u0131s\u0131m uygulaman\u0131z\u0131n UI'\u0131na g\u00f6re de\u011fi\u015fir.\n        IWebElement addToCartButton = driver.FindElement(By.Id(\"add-to-cart-button\"));\n        addToCartButton.Click();\n        Thread.Sleep(2000); \/\/ Sepete ekleme animasyonu i\u00e7in bekleyebiliriz\n\n        \/\/ Sepet veya \u00f6deme sayfas\u0131na gitme ad\u0131mlar\u0131...\n        \/\/ \u00d6deme i\u015flemini tamamlama...\n        \/\/ \u00d6rne\u011fin: driver.FindElement(By.Id(\"checkout-button\")).Click();\n        \/\/ driver.FindElement(By.Id(\"payment-method-radio\")).Click();\n        \/\/ driver.FindElement(By.Id(\"complete-order-button\")).Click();\n        Thread.Sleep(5000); \/\/ \u00d6deme i\u015fleminin tamamlanmas\u0131 ve veritaban\u0131 g\u00fcncellemesi i\u00e7in bekleyelim\n\n        int finalStock = DbConnector.GetProductStock(productName);\n        Assert.AreNotEqual(-1, finalStock, \"Son stok bilgisi veritaban\u0131ndan al\u0131namad\u0131.\");\n        Console.WriteLine($\"Test sonras\u0131 {productName} sto\u011fu: {finalStock}\");\n\n        \/\/ Stokun bir azalmas\u0131 beklendi\u011fi i\u00e7in kontrol ediyoruz\n        Assert.AreEqual(initialStock - 1, finalStock, $\"\u00dcr\u00fcn {productName} sto\u011fu do\u011fru g\u00fcncellenmedi.\");\n    }\n\n    [TearDown]\n    public void Teardown()\n    {\n        driver.Quit();\n        \/\/ Test sonras\u0131 veritaban\u0131n\u0131 eski haline getirmek gerekebilir.\n        \/\/ \u00d6rne\u011fin, e\u011fer testte bir \u00fcr\u00fcn\u00fcn sto\u011funu d\u00fc\u015f\u00fcrd\u00fcysek, tekrar art\u0131rabiliriz.\n        \/\/ DbConnector.UpdateProductStock(\"Example Product X\", originalStock);\n    }\n}\n    <\/pre>\n<p><\/code><\/p>\n<p>Bu \u00f6rnekte, <code>DbConnector.GetProductStock()<\/code> metodunu kullanarak Selenium eylemleri \u00f6ncesinde ve sonras\u0131nda veritaban\u0131 stok durumunu sorguluyoruz. Bu sayede, UI'daki bir i\u015flemin arka plandaki veri katman\u0131nda do\u011fru bir \u015fekilde yans\u0131t\u0131ld\u0131\u011f\u0131n\u0131 g\u00fcvenle do\u011frulayabiliyoruz. Veritaban\u0131 ba\u011flant\u0131s\u0131, testlerinizin daha derin ve kapsaml\u0131 olmas\u0131n\u0131 sa\u011flayarak hatalar\u0131 daha erken yakalaman\u0131za yard\u0131mc\u0131 olur. Her zaman oldu\u011fu gibi, ba\u011flant\u0131lar\u0131n do\u011fru \u015fekilde a\u00e7\u0131l\u0131p kapat\u0131lmas\u0131na ve hata y\u00f6netimine dikkat etmek, uygulaman\u0131z\u0131n kararl\u0131l\u0131\u011f\u0131 a\u00e7\u0131s\u0131ndan hayati \u00f6neme sahiptir.<\/p>\n<h3>Ba\u011flant\u0131 Dizeleri ve G\u00fcvenli Veri Eri\u015fimi: En \u0130yi Uygulamalar<\/h3>\n<p>Veritaban\u0131 ba\u011flant\u0131 dizeleri, sunucu adresi, kullan\u0131c\u0131 ad\u0131 ve \u015fifre gibi hassas bilgileri i\u00e7erir. Bu bilgilerin g\u00fcvenli bir \u015fekilde y\u00f6netilmesi, herhangi bir uygulaman\u0131n g\u00fcvenli\u011fi i\u00e7in kritik \u00f6neme sahiptir. Ba\u011flant\u0131 dizelerini do\u011frudan kod i\u00e7inde sabit de\u011ferler olarak tutmak, k\u00f6t\u00fc uygulamalardan biridir \u00e7\u00fcnk\u00fc bu, hassas bilgilerin kodla birlikte yay\u0131nlanmas\u0131na veya versiyon kontrol sistemlerine s\u0131zmas\u0131na neden olabilir. \u0130\u015fte ba\u011flant\u0131 dizeleri ve g\u00fcvenli veri eri\u015fimi i\u00e7in en iyi uygulamalar:<\/p>\n<ol>\n<li><strong>Yap\u0131land\u0131rma Dosyalar\u0131 Kullan\u0131m\u0131:<\/strong> Ba\u011flant\u0131 dizelerini <code>appsettings.json<\/code> (ASP.NET Core uygulamalar\u0131 i\u00e7in) veya <code>Web.config<\/code> \/ <code>App.config<\/code> (geleneksel .NET Framework uygulamalar\u0131 i\u00e7in) gibi yap\u0131land\u0131rma dosyalar\u0131nda saklay\u0131n. Bu dosyalar, uygulaman\u0131n da\u011f\u0131t\u0131m ortam\u0131na g\u00f6re kolayca de\u011fi\u015ftirilebilir ve hassas bilgiler koddan ayr\u0131lm\u0131\u015f olur.<\/li>\n<pre><code>\n\/\/ appsettings.json \u00f6rne\u011fi\n{\n  \"ConnectionStrings\": {\n    \"MySqlConnection\": \"Server=localhost;Port=3306;Database=ecommerce_db;Uid=root;Pwd=my_password;\"\n  }\n}\n\n\/\/ C# kodunda okuma\nusing Microsoft.Extensions.Configuration; \/\/ Gerekli namespace\n\n\/\/ ...\nvar builder = new ConfigurationBuilder()\n    .SetBasePath(Directory.GetCurrentDirectory())\n    .AddJsonFile(\"appsettings.json\", optional: true, reloadOnChange: true);\n\nIConfigurationRoot configuration = builder.Build();\nstring connectionString = configuration.GetConnectionString(\"MySqlConnection\");\n\/\/ ... MySqlConnection(connectionString) ile kullan\u0131n\n        <\/pre>\n<p><\/code><\/p>\n<li><strong>Ortam De\u011fi\u015fkenleri:<\/strong> \u00d6zellikle bulut ortamlar\u0131nda (Azure, AWS, Docker vb.) uygulama da\u011f\u0131t\u0131rken, hassas bilgileri ortam de\u011fi\u015fkenleri olarak ayarlamak yayg\u0131n ve g\u00fcvenli bir yakla\u015f\u0131md\u0131r. Uygulama, \u00e7al\u0131\u015fma zaman\u0131nda bu de\u011fi\u015fkenleri okuyabilir.<\/li>\n<li><strong>Gizli Y\u00f6netimi (Secret Management):<\/strong> Geli\u015ftirme s\u0131ras\u0131nda bile hassas bilgileri g\u00fcvenli bir \u015fekilde saklamak i\u00e7in Visual Studio'nun \"User Secrets\" \u00f6zelli\u011fini kullanabilirsiniz. \u00dcretim ortamlar\u0131 i\u00e7in Azure Key Vault, AWS Secrets Manager veya HashiCorp Vault gibi \u00f6zel gizli y\u00f6netim \u00e7\u00f6z\u00fcmleri tercih edilmelidir.<\/li>\n<li><strong>En Az Yetki \u0130lkesi:<\/strong> Veritaban\u0131 kullan\u0131c\u0131lar\u0131 i\u00e7in her zaman en az yetki ilkesini uygulay\u0131n. Selenium testleriniz i\u00e7in veritaban\u0131na ba\u011flanan kullan\u0131c\u0131n\u0131n yaln\u0131zca testlerinizin gerektirdi\u011fi minimum okuma\/yazma\/g\u00fcncelleme izinlerine sahip oldu\u011fundan emin olun. \u00d6rne\u011fin, bir test kullan\u0131c\u0131s\u0131n\u0131n tablo silme veya yeni tablo olu\u015fturma yetkisi olmamal\u0131d\u0131r.<\/li>\n<li><strong>Parametreli Sorgular:<\/strong> SQL enjeksiyon sald\u0131r\u0131lar\u0131n\u0131 \u00f6nlemek i\u00e7in her zaman parametreli sorgular kullan\u0131n. Yukar\u0131daki kod \u00f6rneklerimizde <code>command.Parameters.AddWithValue()<\/code> kullan\u0131m\u0131, bu g\u00fcvenlik \u00f6nlemini sa\u011flamaktad\u0131r. Bu sadece g\u00fcvenlik i\u00e7in de\u011fil, ayn\u0131 zamanda sorgular\u0131n daha okunabilir ve bak\u0131m\u0131 kolay olmas\u0131n\u0131 da sa\u011flar.<\/li>\n<li><strong>Ba\u011flant\u0131lar\u0131 Y\u00f6netme:<\/strong> Veritaban\u0131 ba\u011flant\u0131lar\u0131n\u0131 her zaman a\u00e7\u0131p kapat\u0131rken <code>using<\/code> bloklar\u0131n\u0131 veya <code>try-catch-finally<\/code> yap\u0131lar\u0131n\u0131 kullanarak do\u011fru \u015fekilde y\u00f6netin. Ba\u011flant\u0131n\u0131n a\u00e7\u0131k kalmas\u0131, performans sorunlar\u0131na ve kaynak s\u0131z\u0131nt\u0131lar\u0131na yol a\u00e7abilir. <code>using<\/code> ifadesi, <code>IDisposable<\/code> aray\u00fcz\u00fcn\u00fc uygulayan nesnelerin (<code>MySqlConnection<\/code> gibi) kapsam d\u0131\u015f\u0131na \u00e7\u0131kt\u0131\u011f\u0131nda otomatik olarak <code>Dispose()<\/code> metodunu \u00e7a\u011f\u0131rarak kaynaklar\u0131 serbest b\u0131rakmas\u0131n\u0131 sa\u011flar.<\/li>\n<\/ol>\n<div class=\"warning-box\">\n        \u00d6nemli Uyar\u0131: Ba\u011flant\u0131 dizelerinizi asla herkese a\u00e7\u0131k depolarda (GitHub gibi) do\u011frudan payla\u015fmay\u0131n! Bu, ciddi g\u00fcvenlik zafiyetlerine yol a\u00e7abilir.\n    <\/div>\n<h3>Veri Okuma ve Yazma \u0130\u015flemleri: CRUD Operasyonlar\u0131 Selenium Testlerinde Nas\u0131l Kullan\u0131l\u0131r?<\/h3>\n<p>Selenium testleri ba\u011flam\u0131nda veritaban\u0131 ile etkile\u015fim, genellikle CRUD (Create, Read, Update, Delete) operasyonlar\u0131n\u0131 i\u00e7erir. Bu operasyonlar, test verilerini haz\u0131rlamak, test sonu\u00e7lar\u0131n\u0131 do\u011frulamak ve test ortam\u0131n\u0131 temizlemek i\u00e7in kullan\u0131l\u0131r. \u0130\u015fte bu operasyonlar\u0131n Selenium testlerinde nas\u0131l kullan\u0131labilece\u011fine dair detayl\u0131 \u00f6rnekler:<\/p>\n<h4>CREATE (Olu\u015fturma) - Test Verisi Haz\u0131rlama<\/h4>\n<p>Bir test senaryosu i\u00e7in \u00f6zel bir kullan\u0131c\u0131 veya veri olu\u015fturman\u0131z gerekti\u011finde bu i\u015flem kullan\u0131l\u0131r. \u00d6rne\u011fin, yeni bir kullan\u0131c\u0131n\u0131n kay\u0131t ak\u0131\u015f\u0131n\u0131 test etmeden \u00f6nce, testin \u00e7al\u0131\u015faca\u011f\u0131 ortamda belirli \u00f6zelliklere sahip bir kullan\u0131c\u0131 olu\u015fturmak isteyebilirsiniz.<\/p>\n<pre><code>\npublic static void AddTestUser(string username, string email, string passwordHash)\n{\n    using (MySqlConnection connection = DbConnector.GetConnection())\n    {\n        connection.Open();\n        string query = \"INSERT INTO users (username, email, password_hash, created_at) VALUES (@username, @email, @passwordHash, NOW());\";\n        using (MySqlCommand command = new MySqlCommand(query, connection))\n        {\n            command.Parameters.AddWithValue(\"@username\", username);\n            command.Parameters.AddWithValue(\"@email\", email);\n            command.Parameters.AddWithValue(\"@passwordHash\", passwordHash); \/\/ \u015eifrenin hash'lenmi\u015f hali\n            command.ExecuteNonQuery();\n            Console.WriteLine($\"Kullan\u0131c\u0131 '{username}' ba\u015far\u0131yla eklendi.\");\n        }\n    }\n}\n\n\/\/ Selenium testinde kullan\u0131m:\n[Test]\npublic void RegisterNewUserTest()\n{\n    \/\/ Test \u00f6ncesi veritaban\u0131na bir kullan\u0131c\u0131 ekleyebiliriz (\u00f6rne\u011fin daha sonra silmek i\u00e7in)\n    DbConnector.AddTestUser(\"testuser123\", \"test@example.com\", \"hashedpassword\"); \/\/ Kullan\u0131c\u0131 kay\u0131tl\u0131 gibi davran\u0131yoruz\n\n    driver.Navigate().GoToUrl(\"http:\/\/your-app.com\/register\");\n    \/\/ Selenium ile kay\u0131t formunu doldurma ve g\u00f6nderme i\u015flemleri\n    \/\/ driver.FindElement(By.Id(\"username\")).SendKeys(\"testuser123\");\n    \/\/ ...\n}\n    <\/pre>\n<p><\/code><\/p>\n<h4>READ (Okuma) - Do\u011frulama ve Test Verisi \u00c7ekme<\/h4>\n<p>En s\u0131k kullan\u0131lan operasyondur. Selenium bir eylemi tamamlad\u0131ktan sonra, bu eylemin veritaban\u0131ndaki etkilerini do\u011frulamak i\u00e7in kullan\u0131l\u0131r. Ayr\u0131ca, test senaryolar\u0131nda kullan\u0131lacak dinamik verileri (\u00f6rne\u011fin giri\u015f i\u00e7in kullan\u0131c\u0131 bilgileri) veritaban\u0131ndan \u00e7ekmek i\u00e7in de idealdir.<\/p>\n<pre><code>\npublic static string GetUserEmail(string username)\n{\n    string email = null;\n    using (MySqlConnection connection = DbConnector.GetConnection())\n    {\n        connection.Open();\n        string query = \"SELECT email FROM users WHERE username = @username;\";\n        using (MySqlCommand command = new MySqlCommand(query, connection))\n        {\n            command.Parameters.AddWithValue(\"@username\", username);\n            object result = command.ExecuteScalar();\n            if (result != null && result != DBNull.Value)\n            {\n                email = result.ToString();\n            }\n        }\n    }\n    return email;\n}\n\n\/\/ Selenium testinde kullan\u0131m:\n[Test]\npublic void UserLoginVerification()\n{\n    string usernameToTest = \"existingUser\";\n    string expectedEmail = DbConnector.GetUserEmail(usernameToTest);\n    Assert.IsNotNull(expectedEmail, \"Kullan\u0131c\u0131 e-posta bilgisi veritaban\u0131ndan \u00e7ekilemedi.\");\n\n    driver.Navigate().GoToUrl(\"http:\/\/your-app.com\/login\");\n    driver.FindElement(By.Id(\"username\")).SendKeys(usernameToTest);\n    driver.FindElement(By.Id(\"password\")).SendKeys(\"password123\"); \/\/ \u00d6rnek \u015fifre\n    driver.FindElement(By.Id(\"loginButton\")).Click();\n\n    \/\/ Giri\u015f sonras\u0131 kullan\u0131c\u0131n\u0131n e-postas\u0131n\u0131n do\u011fru g\u00f6sterildi\u011fini UI'dan do\u011frulama\n    IWebElement userEmailDisplay = driver.FindElement(By.CssSelector(\".user-profile-email\"));\n    Assert.AreEqual(expectedEmail, userEmailDisplay.Text, \"Giri\u015f sonras\u0131 e-posta bilgisi yanl\u0131\u015f.\");\n}\n    <\/pre>\n<p><\/code><\/p>\n<h4>UPDATE (G\u00fcncelleme) - Test Ortam\u0131n\u0131 Haz\u0131rlama veya Temizleme<\/h4>\n<p>Bir testin belirli bir ba\u015flang\u0131\u00e7 durumunda \u00e7al\u0131\u015fmas\u0131 gerekti\u011finde veya test sonras\u0131 verileri varsay\u0131lan duruma d\u00f6nd\u00fcrmek i\u00e7in kullan\u0131l\u0131r. \u00d6rne\u011fin, bir kullan\u0131c\u0131n\u0131n yetki seviyesini ge\u00e7ici olarak y\u00fckseltip test yapmak ve sonra eski haline d\u00f6nd\u00fcrmek.<\/p>\n<pre><code>\npublic static void UpdateUserRole(string username, string newRole)\n{\n    using (MySqlConnection connection = DbConnector.GetConnection())\n    {\n        connection.Open();\n        string query = \"UPDATE users SET user_role = @newRole WHERE username = @username;\";\n        using (MySqlCommand command = new MySqlCommand(query, connection))\n        {\n            command.Parameters.AddWithValue(\"@newRole\", newRole);\n            command.Parameters.AddWithValue(\"@username\", username);\n            command.ExecuteNonQuery();\n            Console.WriteLine($\"Kullan\u0131c\u0131 '{username}' rol\u00fc '{newRole}' olarak g\u00fcncellendi.\");\n        }\n    }\n}\n\n\/\/ Selenium testinde kullan\u0131m:\n[Test]\npublic void AdminPanelAccessTest()\n{\n    string testAdminUser = \"testAdmin\";\n    \/\/ Testten \u00f6nce kullan\u0131c\u0131y\u0131 admin yap\n    DbConnector.UpdateUserRole(testAdminUser, \"admin\");\n\n    \/\/ Selenium ile testAdmin olarak giri\u015f yap ve admin paneline eri\u015fimi do\u011frula\n    \/\/ ...\n\n    \/\/ Test bittikten sonra rol\u00fc tekrar normal kullan\u0131c\u0131ya d\u00fc\u015f\u00fcr (TearDown i\u00e7inde veya testin sonunda)\n    DbConnector.UpdateUserRole(testAdminUser, \"user\");\n}\n    <\/pre>\n<p><\/code><\/p>\n<h4>DELETE (Silme) - Test Ortam\u0131n\u0131 Temizleme<\/h4>\n<p>Testlerinizin birbirini etkilememesi i\u00e7in testten sonra olu\u015fturulan test verilerini temizlemek i\u00e7in kullan\u0131l\u0131r. Bu, her testin izole bir ortamda \u00e7al\u0131\u015fmas\u0131n\u0131 sa\u011flar ve \"kirli\" verilerin birikmesini \u00f6nler.<\/p>\n<pre><code>\npublic static void DeleteTestUser(string username)\n{\n    using (MySqlConnection connection = DbConnector.GetConnection())\n    {\n        connection.Open();\n        string query = \"DELETE FROM users WHERE username = @username;\";\n        using (MySqlCommand command = new MySqlCommand(query, connection))\n        {\n            command.Parameters.AddWithValue(\"@username\", username);\n            command.ExecuteNonQuery();\n            Console.WriteLine($\"Kullan\u0131c\u0131 '{username}' ba\u015far\u0131yla silindi.\");\n        }\n    }\n}\n\n\/\/ Selenium testinde kullan\u0131m (TearDown i\u00e7inde genellikle):\n[TearDown]\npublic void Teardown()\n{\n    driver.Quit();\n    \/\/ Test s\u0131ras\u0131nda olu\u015fturulan kullan\u0131c\u0131y\u0131 sil\n    DbConnector.DeleteTestUser(\"testuser123\");\n}\n    <\/pre>\n<p><\/code><\/p>\n<p>Bu CRUD operasyonlar\u0131n\u0131 do\u011fru bir \u015fekilde kullanarak, Selenium testlerinizin kapsam\u0131n\u0131 ve g\u00fcvenilirli\u011fini \u00f6nemli \u00f6l\u00e7\u00fcde art\u0131rabilir, test verilerini daha etkili y\u00f6netebilir ve test otomasyonu stratejinizi daha sa\u011flam hale getirebilirsiniz.<\/p>\n<h2>Geli\u015fmi\u015f Senaryolar ve Performans \u0130pu\u00e7lar\u0131: Test Otomasyonunuzu \u0130yile\u015ftirin<\/h2>\n<p>Selenium testlerini MySQL ile entegre etmek, temel do\u011frulama ve veri haz\u0131rlaman\u0131n \u00f6tesine ge\u00e7ebilir. Daha karma\u015f\u0131k senaryolar\u0131 ele almak ve test performans\u0131n\u0131 optimize etmek i\u00e7in baz\u0131 ileri d\u00fczey tekniklere ve ipu\u00e7lar\u0131na ihtiya\u00e7 duyulabilir. B\u00fcy\u00fck veri k\u00fcmeleriyle \u00e7al\u0131\u015fmak veya s\u0131k veritaban\u0131 etkile\u015fimleri olan testlerde performans\u0131 korumak \u00f6nemlidir.<\/p>\n<h3>B\u00fcy\u00fck Veri K\u00fcmeleriyle \u00c7al\u0131\u015fmak ve Test Verisi Y\u00f6netimi Stratejileri<\/h3>\n<p>Ger\u00e7ek d\u00fcnya uygulamalar\u0131nda, veritabanlar\u0131 genellikle milyonlarca kayda ev sahipli\u011fi yapar. Test otomasyonunda bu t\u00fcr b\u00fcy\u00fck veri k\u00fcmeleriyle \u00e7al\u0131\u015f\u0131rken, performans ve testlerin kararl\u0131l\u0131\u011f\u0131 a\u00e7\u0131s\u0131ndan dikkatli olmak gerekir. \u0130\u015fte baz\u0131 stratejiler:<\/p>\n<ol>\n<li><strong>S\u0131n\u0131rl\u0131 ve Hedefli Veri Kullan\u0131m\u0131:<\/strong> Her test i\u00e7in m\u00fcmk\u00fcn olan en k\u00fc\u00e7\u00fck ve en alakal\u0131 veri k\u00fcmesini kullan\u0131n. T\u00fcm veritaban\u0131n\u0131 test ortam\u0131na kopyalamak yerine, sadece testin gerektirdi\u011fi kay\u0131tlar\u0131 olu\u015fturun veya mevcut k\u00fc\u00e7\u00fck bir alt k\u00fcmesini kullan\u0131n.<\/li>\n<li><strong>Veri \u00dcretimi (Data Generation):<\/strong> Test verilerini manuel olarak girmek yerine, programatik olarak otomatik veri \u00fcretimi yap\u0131n. Bu, \u00f6zellikle her test \u00e7al\u0131\u015ft\u0131rmas\u0131nda farkl\u0131, rastgele veya benzersiz verilere ihtiyac\u0131n\u0131z oldu\u011funda faydal\u0131d\u0131r.<\/li>\n<pre><code>\n\/\/ \u00d6rnek: Rastgele \u00fcr\u00fcn ad\u0131 ve stok \u00fcreten metod\npublic static void GenerateRandomProduct(int count)\n{\n    using (MySqlConnection connection = DbConnector.GetConnection())\n    {\n        connection.Open();\n        for (int i = 0; i < count; i++)\n        {\n            string productName = \"RandomProduct_\" + Guid.NewGuid().ToString().Substring(0, 8);\n            int stock = new Random().Next(10, 100);\n            string query = \"INSERT INTO products (product_name, stock_quantity) VALUES (@productName, @stock);\";\n            using (MySqlCommand command = new MySqlCommand(query, connection))\n            {\n                command.Parameters.AddWithValue(\"@productName\", productName);\n                command.Parameters.AddWithValue(\"@stock\", stock);\n                command.ExecuteNonQuery();\n            }\n        }\n        Console.WriteLine($\"{count} adet rastgele \u00fcr\u00fcn olu\u015fturuldu.\");\n    }\n}\n        <\/pre>\n<p><\/code><\/p>\n<li><strong>Test Verisi Fabrikalar\u0131:<\/strong> Karma\u015f\u0131k nesneler i\u00e7in test verilerini olu\u015fturan \"veri fabrikalar\u0131\" (data factories) veya \"builder\" desenleri kullan\u0131n. Bu, test kodunuzu daha okunabilir ve y\u00f6netilebilir hale getirir. \u00d6rne\u011fin, <code>UserBuilder.WithRole(\"admin\").Build()<\/code> gibi zincirleme metotlar olu\u015fturabilirsiniz.<\/li>\n<li><strong>Test Verisi Y\u00f6netim Sistemleri (Test Data Management - TDM):<\/strong> B\u00fcy\u00fck projeler ve ekipler i\u00e7in, test verilerini merkezi olarak y\u00f6neten ve farkl\u0131 test senaryolar\u0131na \u00f6zel veri setleri sa\u011flayan TDM ara\u00e7lar\u0131n\u0131 de\u011ferlendirebilirsiniz.<\/li>\n<li><strong>Veritaban\u0131 Snapshot'lar\u0131:<\/strong> Test \u00f6ncesinde veritaban\u0131n\u0131n bir anl\u0131k g\u00f6r\u00fcnt\u00fcs\u00fcn\u00fc (snapshot) al\u0131p test sonras\u0131 geri y\u00fcklemek, ortam\u0131 h\u0131zl\u0131 ve g\u00fcvenilir bir \u015fekilde s\u0131f\u0131rlaman\u0131n bir yoludur. Ancak bu, veritaban\u0131 sunucusunun \u00f6zelliklerine ve altyap\u0131ya ba\u011fl\u0131d\u0131r.<\/li>\n<\/ol>\n<h3>Hata Y\u00f6netimi ve Robust Testler \u0130\u00e7in \u0130pu\u00e7lar\u0131<\/h3>\n<p>Robust (sa\u011flam) testler yazmak, sadece ba\u015far\u0131l\u0131 durumlar\u0131 de\u011fil, ayn\u0131 zamanda beklenen ve beklenmeyen hatalar\u0131 da ele almay\u0131 gerektirir. Veritaban\u0131 etkile\u015fimleri s\u0131ras\u0131nda ortaya \u00e7\u0131kabilecek hatalar\u0131 do\u011fru y\u00f6netmek, testlerinizin g\u00fcvenilirli\u011fini art\u0131r\u0131r.<\/p>\n<ol>\n<li><strong>Try-Catch Bloklar\u0131:<\/strong> T\u00fcm veritaban\u0131 etkile\u015fimlerini <code>try-catch<\/code> bloklar\u0131 i\u00e7ine al\u0131n. <code>MySqlException<\/code> gibi spesifik istisnalar\u0131 yakalayarak, a\u011f sorunlar\u0131, ba\u011flant\u0131 hatalar\u0131 veya sorgu hatalar\u0131 gibi durumlar\u0131 y\u00f6netebilirsiniz.<\/li>\n<pre><code>\ntry\n{\n    connection.Open();\n    \/\/ Veritaban\u0131 i\u015flemleri\n}\ncatch (MySqlException ex)\n{\n    \/\/ Hata tipine g\u00f6re farkl\u0131 aksiyonlar alabilirsiniz\n    if (ex.Number == 1045) \/\/ Eri\u015fim reddedildi hatas\u0131\n    {\n        Console.WriteLine(\"Veritaban\u0131 eri\u015fimi reddedildi. Kullan\u0131c\u0131 ad\u0131 veya \u015fifreyi kontrol edin.\");\n        Assert.Fail($\"Veritaban\u0131 ba\u011flant\u0131 hatas\u0131: {ex.Message}\");\n    }\n    else\n    {\n        Console.WriteLine($\"Genel veritaban\u0131 hatas\u0131: {ex.Message}\");\n        Assert.Fail($\"Veritaban\u0131 i\u015flemi s\u0131ras\u0131nda hata olu\u015ftu: {ex.Message}\");\n    }\n}\nfinally\n{\n    if (connection != null && connection.State == System.Data.ConnectionState.Open)\n    {\n        connection.Close();\n    }\n}\n        <\/pre>\n<p><\/code><\/p>\n<li><strong>Ba\u011flant\u0131 Zaman A\u015f\u0131m\u0131 (Connection Timeout):<\/strong> Ba\u011flant\u0131 dizenizde <code>Connection Timeout<\/code> de\u011ferini belirleyin. Bu, bir ba\u011flant\u0131n\u0131n ne kadar s\u00fcreyle kurulmaya \u00e7al\u0131\u015f\u0131laca\u011f\u0131n\u0131 tan\u0131mlar ve sonsuz bir bekleme d\u00f6ng\u00fcs\u00fcne girilmesini engeller.<\/li>\n<pre><code>\n\"Server=localhost;Port=3306;Database=ecommerce_db;Uid=root;Pwd=my_password;Connection Timeout=15;\" \/\/ 15 saniye zaman a\u015f\u0131m\u0131\n        <\/pre>\n<p><\/code><\/p>\n<li><strong>Komut Zaman A\u015f\u0131m\u0131 (Command Timeout):<\/strong> Sorgular\u0131n\u0131z\u0131n ne kadar s\u00fcreyle \u00e7al\u0131\u015faca\u011f\u0131n\u0131 <code>MySqlCommand<\/code> nesnesinin <code>CommandTimeout<\/code> \u00f6zelli\u011fi ile belirleyin. Uzun s\u00fcren sorgular\u0131n testleri t\u0131kamas\u0131n\u0131 \u00f6nler.<\/li>\n<pre><code>\nusing (MySqlCommand command = new MySqlCommand(query, connection))\n{\n    command.CommandTimeout = 30; \/\/ Sorgunun 30 saniye i\u00e7inde bitmesini bekle\n    \/\/ ...\n}\n        <\/pre>\n<p><\/code><\/p>\n<li><strong>Loglama:<\/strong> Veritaban\u0131 etkile\u015fimlerindeki t\u00fcm \u00f6nemli olaylar\u0131 ve hatalar\u0131 loglay\u0131n. Bu, sorun giderme ve test ba\u015far\u0131s\u0131zl\u0131klar\u0131n\u0131n temel nedenlerini belirlemede paha bi\u00e7ilmezdir. Log4Net, Serilog gibi pop\u00fcler C# loglama k\u00fct\u00fcphanelerini kullanabilirsiniz.<\/li>\n<li><strong>Yeniden Deneme Mekanizmalar\u0131:<\/strong> \u00d6zellikle a\u011f kaynakl\u0131 ge\u00e7ici hatalar i\u00e7in, ba\u011flant\u0131 veya sorgu denemelerini belirli bir gecikmeyle birka\u00e7 kez yeniden denemeye \u00e7al\u0131\u015fan bir mekanizma (retry mechanism) uygulayabilirsiniz. Polly k\u00fct\u00fcphanesi bu t\u00fcr senaryolar i\u00e7in \u00e7ok kullan\u0131\u015fl\u0131d\u0131r.<\/li>\n<\/ol>\n<div class=\"info-box\">\n        Uzman \u0130pucu: Testlerinizi paralel olarak \u00e7al\u0131\u015ft\u0131r\u0131yorsan\u0131z, veritaban\u0131 ba\u011flant\u0131 havuzlar\u0131n\u0131n (connection pooling) nas\u0131l \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131 ve ayn\u0131 anda birden fazla testin veritaban\u0131na nas\u0131l eri\u015fti\u011fini anlamak \u00f6nemlidir. Her testin kendi ba\u011flant\u0131s\u0131n\u0131 a\u00e7\u0131p kapatmas\u0131 genellikle en iyi yakla\u015f\u0131md\u0131r.\n    <\/div>\n<p>Bu ileri d\u00fczey stratejiler ve ipu\u00e7lar\u0131, Selenium testlerinizin MySQL veritaban\u0131 ile entegrasyonunu sadece i\u015flevsel de\u011fil, ayn\u0131 zamanda performansl\u0131, g\u00fcvenilir ve bak\u0131m\u0131 kolay hale getirecektir. Unutmay\u0131n ki test otomasyonunda ama\u00e7, sadece hatalar\u0131 bulmak de\u011fil, ayn\u0131 zamanda test s\u00fcrecini kendisini de sa\u011flam ve verimli k\u0131lmakt\u0131r.<\/p>\n<h2>Sonu\u00e7: Selenium ve MySQL Entegrasyonuyla Testlerinizi G\u00fc\u00e7lendirin<\/h2>\n<p>Bu makalede, C# ile Selenium testlerinizi bir MySQL veritaban\u0131na nas\u0131l ba\u011flayaca\u011f\u0131n\u0131z\u0131 ve bu entegrasyonun test otomasyon stratejinize nas\u0131l de\u011fer kataca\u011f\u0131n\u0131 detayl\u0131 bir \u015fekilde inceledik. G\u00f6rd\u00fc\u011f\u00fcm\u00fcz gibi, yaln\u0131zca kullan\u0131c\u0131 aray\u00fcz\u00fc etkile\u015fimlerini do\u011frulamak, modern uygulamalar\u0131n karma\u015f\u0131kl\u0131\u011f\u0131 kar\u015f\u0131s\u0131nda yeterli olmayabilir. Veritaban\u0131 ba\u011flant\u0131s\u0131 sayesinde, testlerinizin kapsam\u0131n\u0131 geni\u015fleterek arka plandaki i\u015f mant\u0131\u011f\u0131n\u0131, veri b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc ve sistemin genel davran\u0131\u015f\u0131n\u0131 g\u00fcvenle do\u011frulayabilirsiniz. Bu yakla\u015f\u0131m, hatalar\u0131 daha erken a\u015famalarda tespit etmenize, test verilerini daha dinamik ve esnek bir \u015fekilde y\u00f6netmenize olanak tan\u0131r ve sonu\u00e7 olarak yaz\u0131l\u0131m kalitenizi \u00f6nemli \u00f6l\u00e7\u00fcde art\u0131r\u0131r.<\/p>\n<p>Ad\u0131m ad\u0131m kurulumdan, CRUD operasyonlar\u0131n\u0131n uygulanmas\u0131na, g\u00fcvenli ba\u011flant\u0131 dizesi y\u00f6netimine ve performans ipu\u00e7lar\u0131na kadar bir\u00e7ok konuya de\u011findik. Unutmay\u0131n ki sa\u011flam bir test otomasyonu, sadece do\u011fru ara\u00e7lar\u0131 kullanmakla kalmaz, ayn\u0131 zamanda bu ara\u00e7lar\u0131 en iyi uygulamalarla birle\u015ftirmeyi de gerektirir. Parametreli sorgular kullanmak, try-catch bloklar\u0131yla hata y\u00f6netimi yapmak ve test sonras\u0131 ortam\u0131 temizlemek, testlerinizin kararl\u0131l\u0131\u011f\u0131 ve g\u00fcvenilirli\u011fi i\u00e7in vazge\u00e7ilmezdir. Bu rehberdeki bilgileri uygulayarak, C# ve Selenium ile MySQL entegrasyonunu ba\u015far\u0131yla ger\u00e7ekle\u015ftirebilir ve test otomasyon s\u00fcre\u00e7lerinizi bir sonraki seviyeye ta\u015f\u0131yabilirsiniz. Art\u0131k testleriniz sadece \"g\u00f6rd\u00fc\u011f\u00fcn\u00fc\" do\u011frulamakla kalmayacak, ayn\u0131 zamanda \"ger\u00e7ekte ne oldu\u011funu\" da kontrol edecektir.<\/p>\n<h3>S\u0131k\u00e7a Sorulan Sorular<\/h3>\n<ul>\n<li>\n            <strong>Selenium testlerinde MySQL yerine ba\u015fka veritabanlar\u0131 kullan\u0131labilir mi?<\/strong><\/p>\n<p>Evet, ADO.NET ve ilgili sa\u011flay\u0131c\u0131lar sayesinde MySQL d\u0131\u015f\u0131nda SQL Server, PostgreSQL, Oracle gibi farkl\u0131 veritabanlar\u0131 da C# Selenium testleriyle entegre edilebilir. Her veritaban\u0131n\u0131n kendi \u00f6zel NuGet paketi (\u00f6rne\u011fin SQL Server i\u00e7in <code>System.Data.SqlClient<\/code> veya <code>Microsoft.Data.SqlClient<\/code>, PostgreSQL i\u00e7in <code>Npgsql<\/code>) ve ba\u011flant\u0131 dizesi format\u0131 bulunur. Temel ADO.NET prensipleri (<code>SqlConnection<\/code>, <code>SqlCommand<\/code>, <code>SqlDataReader<\/code> vb.) benzer kal\u0131r.<\/p>\n<\/li>\n<li>\n            <strong>Veritaban\u0131 ba\u011flant\u0131s\u0131 Selenium testlerimi yava\u015flat\u0131r m\u0131?<\/strong><\/p>\n<p>Evet, her veritaban\u0131 etkile\u015fimi, a\u011f gecikmesi ve veritaban\u0131 sunucusunun i\u015fleme s\u00fcresi nedeniyle bir miktar performans maliyeti getirir. Testlerinizi yava\u015flatmamak i\u00e7in gereksiz veritaban\u0131 \u00e7a\u011fr\u0131lar\u0131ndan ka\u00e7\u0131nmal\u0131, sorgular\u0131n\u0131z\u0131 optimize etmeli ve ba\u011flant\u0131lar\u0131 her zaman d\u00fczg\u00fcn bir \u015fekilde kapatmal\u0131s\u0131n\u0131z. Ayr\u0131ca, s\u0131k\u00e7a eri\u015filen veriler i\u00e7in \u00f6nbellekleme (caching) stratejileri d\u00fc\u015f\u00fcn\u00fclebilir, ancak test senaryolar\u0131nda bu durum dikkatli y\u00f6netilmelidir.<\/p>\n<\/li>\n<li>\n            <strong>Veritaban\u0131 ba\u011flant\u0131 bilgilerini test kodunda sabit olarak tutmak g\u00fcvenli mi?<\/strong><\/p>\n<p>Hay\u0131r, kesinlikle \u00f6nerilmez. Kullan\u0131c\u0131 adlar\u0131, \u015fifreler ve sunucu adresleri gibi hassas bilgileri do\u011frudan kod i\u00e7inde sabit de\u011ferler olarak tutmak g\u00fcvenlik riski olu\u015fturur. Bu bilgiler, yap\u0131land\u0131rma dosyalar\u0131 (<code>appsettings.json<\/code>), ortam de\u011fi\u015fkenleri veya gizli y\u00f6netim sistemleri (Azure Key Vault gibi) kullan\u0131larak g\u00fcvenli bir \u015fekilde saklanmal\u0131 ve \u00e7al\u0131\u015fma zaman\u0131nda okunmal\u0131d\u0131r.<\/p>\n<\/li>\n<li>\n            <strong>Test verilerini y\u00f6netirken hangi stratejiler kullan\u0131lmal\u0131?<\/strong><\/p>\n<p>Test verisi y\u00f6netimi i\u00e7in birden fazla strateji vard\u0131r: Her test \u00e7al\u0131\u015ft\u0131rmas\u0131nda yeni, benzersiz veri olu\u015fturmak (data generation); mevcut veritaban\u0131n\u0131 test \u00f6ncesi belirli bir duruma s\u0131f\u0131rlamak (test data setup); test sonras\u0131 olu\u015fturulan verileri temizlemek (test data teardown); veya test senaryolar\u0131na \u00f6zel k\u00fc\u00e7\u00fck ve hedeflenmi\u015f veri setleri kullanmak. B\u00fcy\u00fck projelerde, \u00f6zel test verisi y\u00f6netim ara\u00e7lar\u0131 veya framework'leri (test data factories) faydal\u0131 olabilir.<\/p>\n<\/li>\n<li>\n            <strong>Selenium testleri yaln\u0131zca veritaban\u0131 do\u011frulamalar\u0131yla m\u0131 s\u0131n\u0131rl\u0131 kalmal\u0131?<\/strong><\/p>\n<p>Hay\u0131r, Selenium testleri \u00f6ncelikle kullan\u0131c\u0131 aray\u00fcz\u00fc etkile\u015fimlerini ve kullan\u0131c\u0131 deneyimini do\u011frulamak i\u00e7in kullan\u0131l\u0131r. Veritaban\u0131 do\u011frulamalar\u0131, bu UI testlerini destekleyici ve g\u00fc\u00e7lendirici bir rol oynar. M\u00fcmk\u00fcn oldu\u011funca, temel i\u015f mant\u0131\u011f\u0131 ve veri do\u011frulamalar\u0131n\u0131 UI katman\u0131ndan ba\u011f\u0131ms\u0131z olarak (\u00f6rne\u011fin API testleri veya birim testleri ile) test etmek daha verimli ve h\u0131zl\u0131d\u0131r. Selenium ve veritaban\u0131 entegrasyonu, \u00f6zellikle u\u00e7tan uca (end-to-end) senaryolarda ve UI \u00fczerindeki i\u015flemlerin veritaban\u0131ndaki etkilerini do\u011frulamak gerekti\u011finde en de\u011ferlidir.<\/p>\n<\/li>\n<\/ul>\n<p><\/body><\/p>\n","protected":false},"excerpt":{"rendered":"Selenium testlerinizi C# kullanarak MySQL veritaban\u0131n\u0131zla nas\u0131l entegre edece\u011finizi merak m\u0131 ediyorsunuz? Bu kapsaml\u0131 rehber, veritaban\u0131 ba\u011flant\u0131lar\u0131n\u0131 ad\u0131m&hellip;","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"csco_page_header_type":"","csco_page_load_nextpost":"","csco_page_subscribe_form":"","csco_page_contact_form":"","footnotes":""},"categories":[138],"tags":[],"class_list":{"0":"post-31980","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-mysql","7":"cs-entry","8":"cs-video-wrap"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.5 (Yoast SEO v25.3.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>C# Selenium Testleri ile MySQL Veritaban\u0131 Ba\u011flant\u0131s\u0131 Rehberi<\/title>\n<meta name=\"description\" content=\"Selenium testlerinizi C# kullanarak MySQL veritaban\u0131n\u0131zla nas\u0131l entegre edece\u011finizi merak m\u0131 ediyorsunuz? Bu kapsaml\u0131 rehber, veritaban\u0131 ba\u011flant\u0131lar\u0131n\u0131 ad\u0131m ad\u0131m kurmaktan, test verilerini y\u00f6netmeye ve otomasyon stratejilerinizi geli\u015ftirmeye kadar her \u015feyi ele alarak size yol g\u00f6sterecek.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/fatihsoysal.com\/blog\/c-selenium-testleri-ile-mysql-veritabani-baglantisi-rehberi\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C# Selenium Testleri ile MySQL Veritaban\u0131 Ba\u011flant\u0131s\u0131 Rehberi\" \/>\n<meta property=\"og:description\" content=\"Selenium testlerinizi C# kullanarak MySQL veritaban\u0131n\u0131zla nas\u0131l entegre edece\u011finizi merak m\u0131 ediyorsunuz? Bu kapsaml\u0131 rehber, veritaban\u0131 ba\u011flant\u0131lar\u0131n\u0131 ad\u0131m ad\u0131m kurmaktan, test verilerini y\u00f6netmeye ve otomasyon stratejilerinizi geli\u015ftirmeye kadar her \u015feyi ele alarak size yol g\u00f6sterecek.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/c-selenium-testleri-ile-mysql-veritabani-baglantisi-rehberi\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2025-10-16T06:01:21+00:00\" \/>\n<meta name=\"author\" content=\"Fatih Soysal\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Fatih Soysal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"23 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/c-selenium-testleri-ile-mysql-veritabani-baglantisi-rehberi\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/c-selenium-testleri-ile-mysql-veritabani-baglantisi-rehberi\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"C# Selenium Testleri ile MySQL Veritaban\u0131 Ba\u011flant\u0131s\u0131 Rehberi\",\"datePublished\":\"2025-10-16T06:01:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/c-selenium-testleri-ile-mysql-veritabani-baglantisi-rehberi\/\"},\"wordCount\":3405,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"articleSection\":[\"MySQL\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/c-selenium-testleri-ile-mysql-veritabani-baglantisi-rehberi\/#respond\"]}],\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/c-selenium-testleri-ile-mysql-veritabani-baglantisi-rehberi\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/c-selenium-testleri-ile-mysql-veritabani-baglantisi-rehberi\/\",\"name\":\"C# Selenium Testleri ile MySQL Veritaban\u0131 Ba\u011flant\u0131s\u0131 Rehberi\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"datePublished\":\"2025-10-16T06:01:21+00:00\",\"description\":\"Selenium testlerinizi C# kullanarak MySQL veritaban\u0131n\u0131zla nas\u0131l entegre edece\u011finizi merak m\u0131 ediyorsunuz? Bu kapsaml\u0131 rehber, veritaban\u0131 ba\u011flant\u0131lar\u0131n\u0131 ad\u0131m ad\u0131m kurmaktan, test verilerini y\u00f6netmeye ve otomasyon stratejilerinizi geli\u015ftirmeye kadar her \u015feyi ele alarak size yol g\u00f6sterecek.\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/c-selenium-testleri-ile-mysql-veritabani-baglantisi-rehberi\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/c-selenium-testleri-ile-mysql-veritabani-baglantisi-rehberi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/c-selenium-testleri-ile-mysql-veritabani-baglantisi-rehberi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"C# Selenium Testleri ile MySQL Veritaban\u0131 Ba\u011flant\u0131s\u0131 Rehberi\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/\",\"name\":\"Fatihsoysal.com\",\"description\":\"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim\",\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\",\"name\":\"Fatih Soysal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"contentUrl\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"width\":512,\"height\":512,\"caption\":\"Fatih Soysal\"},\"logo\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\"},\"description\":\"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"C# Selenium Testleri ile MySQL Veritaban\u0131 Ba\u011flant\u0131s\u0131 Rehberi","description":"Selenium testlerinizi C# kullanarak MySQL veritaban\u0131n\u0131zla nas\u0131l entegre edece\u011finizi merak m\u0131 ediyorsunuz? Bu kapsaml\u0131 rehber, veritaban\u0131 ba\u011flant\u0131lar\u0131n\u0131 ad\u0131m ad\u0131m kurmaktan, test verilerini y\u00f6netmeye ve otomasyon stratejilerinizi geli\u015ftirmeye kadar her \u015feyi ele alarak size yol g\u00f6sterecek.","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:\/\/fatihsoysal.com\/blog\/c-selenium-testleri-ile-mysql-veritabani-baglantisi-rehberi\/","og_locale":"tr_TR","og_type":"article","og_title":"C# Selenium Testleri ile MySQL Veritaban\u0131 Ba\u011flant\u0131s\u0131 Rehberi","og_description":"Selenium testlerinizi C# kullanarak MySQL veritaban\u0131n\u0131zla nas\u0131l entegre edece\u011finizi merak m\u0131 ediyorsunuz? Bu kapsaml\u0131 rehber, veritaban\u0131 ba\u011flant\u0131lar\u0131n\u0131 ad\u0131m ad\u0131m kurmaktan, test verilerini y\u00f6netmeye ve otomasyon stratejilerinizi geli\u015ftirmeye kadar her \u015feyi ele alarak size yol g\u00f6sterecek.","og_url":"https:\/\/fatihsoysal.com\/blog\/c-selenium-testleri-ile-mysql-veritabani-baglantisi-rehberi\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2025-10-16T06:01:21+00:00","author":"Fatih Soysal","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Fatih Soysal","Tahmini okuma s\u00fcresi":"23 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fatihsoysal.com\/blog\/c-selenium-testleri-ile-mysql-veritabani-baglantisi-rehberi\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/c-selenium-testleri-ile-mysql-veritabani-baglantisi-rehberi\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"C# Selenium Testleri ile MySQL Veritaban\u0131 Ba\u011flant\u0131s\u0131 Rehberi","datePublished":"2025-10-16T06:01:21+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/c-selenium-testleri-ile-mysql-veritabani-baglantisi-rehberi\/"},"wordCount":3405,"commentCount":0,"publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"articleSection":["MySQL"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fatihsoysal.com\/blog\/c-selenium-testleri-ile-mysql-veritabani-baglantisi-rehberi\/#respond"]}],"copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/c-selenium-testleri-ile-mysql-veritabani-baglantisi-rehberi\/","url":"https:\/\/fatihsoysal.com\/blog\/c-selenium-testleri-ile-mysql-veritabani-baglantisi-rehberi\/","name":"C# Selenium Testleri ile MySQL Veritaban\u0131 Ba\u011flant\u0131s\u0131 Rehberi","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"datePublished":"2025-10-16T06:01:21+00:00","description":"Selenium testlerinizi C# kullanarak MySQL veritaban\u0131n\u0131zla nas\u0131l entegre edece\u011finizi merak m\u0131 ediyorsunuz? Bu kapsaml\u0131 rehber, veritaban\u0131 ba\u011flant\u0131lar\u0131n\u0131 ad\u0131m ad\u0131m kurmaktan, test verilerini y\u00f6netmeye ve otomasyon stratejilerinizi geli\u015ftirmeye kadar her \u015feyi ele alarak size yol g\u00f6sterecek.","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/c-selenium-testleri-ile-mysql-veritabani-baglantisi-rehberi\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/c-selenium-testleri-ile-mysql-veritabani-baglantisi-rehberi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/c-selenium-testleri-ile-mysql-veritabani-baglantisi-rehberi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"C# Selenium Testleri ile MySQL Veritaban\u0131 Ba\u011flant\u0131s\u0131 Rehberi"}]},{"@type":"WebSite","@id":"https:\/\/fatihsoysal.com\/blog\/#website","url":"https:\/\/fatihsoysal.com\/blog\/","name":"Fatihsoysal.com","description":"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim","publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":["Person","Organization"],"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1","name":"Fatih Soysal","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","contentUrl":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","width":512,"height":512,"caption":"Fatih Soysal"},"logo":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/"},"description":"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.","url":"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/"}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/31980","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/comments?post=31980"}],"version-history":[{"count":0,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/31980\/revisions"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=31980"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=31980"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=31980"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}