MVC-databaskonstruktion

Log | Files | Refs | README

commit 1dc141b3bbbd07dc4e80ec6d739b3a5d21c02f87
parent 6933a41eb54e59134cf08d6aaf7a83352a56a4f7
Author: William Lindholm <a22willi@student.his.se>
Date:   Wed, 11 Oct 2023 09:19:47 +0200

Moved to Utils directory.

Diffstat:
DMVC-databaskonstruktion/Models/DatabaseRepository.cs | 32--------------------------------
AMVC-databaskonstruktion/Utils/DatabaseRepository.cs | 32++++++++++++++++++++++++++++++++
2 files changed, 32 insertions(+), 32 deletions(-)

diff --git a/MVC-databaskonstruktion/Models/DatabaseRepository.cs b/MVC-databaskonstruktion/Models/DatabaseRepository.cs @@ -1,32 +0,0 @@ -using MySql.Data.MySqlClient; -using System.Data; - -namespace MVC_databaskonstruktion.Models -{ - public class DatabaseRepository - { - private readonly string _connectionString; - - public DatabaseRepository(IConfiguration configuration) - { - _connectionString = configuration["ConnectionString"]; - } - - public DataTable GetTable(string query) - { - using (MySqlConnection dbcon = new MySqlConnection(_connectionString)) - { - if (!query.Contains(" ")) - { - query = $"SELECT * FROM {query};"; - } - - dbcon.Open(); - MySqlDataAdapter adapter = new MySqlDataAdapter(query, dbcon); - DataSet ds = new DataSet(); - adapter.Fill(ds, "result"); - return ds.Tables["result"]; - } - } - } -} diff --git a/MVC-databaskonstruktion/Utils/DatabaseRepository.cs b/MVC-databaskonstruktion/Utils/DatabaseRepository.cs @@ -0,0 +1,32 @@ +using MySql.Data.MySqlClient; +using System.Data; + +namespace MVC_databaskonstruktion.Utils +{ + public class DatabaseRepository + { + private readonly string _connectionString; + + public DatabaseRepository(IConfiguration configuration) + { + _connectionString = configuration["ConnectionString"]; + } + + public DataTable GetTable(string query) + { + using (MySqlConnection dbcon = new MySqlConnection(_connectionString)) + { + if (!query.Contains(" ")) + { + query = $"SELECT * FROM {query};"; + } + + dbcon.Open(); + MySqlDataAdapter adapter = new MySqlDataAdapter(query, dbcon); + DataSet ds = new DataSet(); + adapter.Fill(ds, "result"); + return ds.Tables["result"]; + } + } + } +}