Membuka atau menutup koneksi saat menggunakan ADO.NET
Tetap teratur dengan koleksi
Simpan dan kategorikan konten berdasarkan preferensi Anda.
Jalankan pernyataan SQL INSERT untuk membuka dan menutup koneksi ke Cloud SQL untuk MySQL menggunakan paket ADO.NET System.Data.Common.
Contoh kode
Kecuali dinyatakan lain, konten di halaman ini dilisensikan berdasarkan Lisensi Creative Commons Attribution 4.0, sedangkan contoh kode dilisensikan berdasarkan Lisensi Apache 2.0. Untuk mengetahui informasi selengkapnya, lihat Kebijakan Situs Google Developers. Java adalah merek dagang terdaftar dari Oracle dan/atau afiliasinya.
[[["Mudah dipahami","easyToUnderstand","thumb-up"],["Memecahkan masalah saya","solvedMyProblem","thumb-up"],["Lainnya","otherUp","thumb-up"]],[["Sulit dipahami","hardToUnderstand","thumb-down"],["Informasi atau kode contoh salah","incorrectInformationOrSampleCode","thumb-down"],["Informasi/contoh yang saya butuhkan tidak ada","missingTheInformationSamplesINeed","thumb-down"],["Masalah terjemahan","translationIssue","thumb-down"],["Lainnya","otherDown","thumb-down"]],[],[],[],null,["# Open or close a connection when using ADO.NET\n\nRun a SQL INSERT statement to open and close a connection to Cloud SQL for MySQL by using the ADO.NET System.Data.Common package.\n\nCode sample\n-----------\n\n### C#\n\n\nTo authenticate to Cloud SQL for MySQL, set up Application Default Credentials.\nFor more information, see\n\n[Set up authentication for a local development environment](/docs/authentication/set-up-adc-local-dev-environment).\n\n insertTimestamp = DateTime.UtcNow;\n try\n {\n using(var connection = new MySqlConnection(_connectionString.ConnectionString))\n { \n connection.OpenWithRetry();\n using (var insertVoteCommand = connection.CreateCommand())\n {\n insertVoteCommand.CommandText =\n @\"INSERT INTO votes (candidate, time_cast) VALUES (@candidate, @time_cast)\";\n var candidate = insertVoteCommand.CreateParameter();\n candidate.ParameterName = \"@candidate\";\n candidate.DbType = DbType.String;\n candidate.Value = team;\n insertVoteCommand.Parameters.Add(candidate);\n var timeCast = insertVoteCommand.CreateParameter();\n timeCast.ParameterName = \"@time_cast\";\n timeCast.DbType = DbType.DateTime;\n timeCast.Value = insertTimestamp;\n insertVoteCommand.Parameters.Add(timeCast);\n await insertVoteCommand.ExecuteNonQueryAsync();\n }\n }\n return Content($\"Vote successfully cast for '{team}' at time {insertTimestamp}!\");\n }\n catch (Exception ex)\n {\n // If something goes wrong, handle the error in this\n // section. This might involve retrying or adjusting\n // parameters depending on the situation.\n return StatusCode((int)HttpStatusCode.InternalServerError, ex);\n }\n\nWhat's next\n-----------\n\n\nTo search and filter code samples for other Google Cloud products, see the\n[Google Cloud sample browser](/docs/samples?product=cloud_sql_mysql)."]]