using System;
using System.Data.SqlClient;
using System.Linq;
public partial class Veritabani
{
public static string ConnectionString = string.Empty;
public static object Kontrol()
{
using (var l_oConnection = new SqlConnection(ConnectionString))
{
try
{
l_oConnection.Open();
return true;
}
catch (SqlException ex)
{
return ex.Message.ToString();
}
}
}
public static DataRow DataRowGetir(string SQL)
{
var Tablo = DataTableGetir(SQL);
if (Tablo is not null && Tablo.Rows.Count > 0)
{
return Tablo.Rows(0);
}
else
{
return default;
}
}
public static DataTable DataTableGetir(string SQL)
{
var DT = new DataTable();
var Command = new SqlCommand();
var Adaptor = new SqlDataAdapter();

var Baglanti = VTBaglanti();
if (Baglanti.State == ConnectionState.Open)
{
Command.CommandText = SQL.ToString();
Command.Connection = Baglanti;
Adaptor.SelectCommand = Command;
Adaptor.Fill(DT);
Command.Connection.Close();
Command.Dispose();
Adaptor.SelectCommand.Connection.Close();
Adaptor.Dispose();
Baglanti.Dispose();
return DT;
}
else
{
return default;
}

}
public static SqlConnection VTBaglanti()
{
string ConnectionSTr = ConnectionString;
var ClassConnection = new SqlConnection();
if (ClassConnection.State == ConnectionState.Open)
{
ClassConnection.Close();
ClassConnection.Dispose();
}
ClassConnection.ConnectionString = ConnectionSTr;
ClassConnection.Open();
if (ClassConnection.State == ConnectionState.Open)
{
return ClassConnection;
}
else
{
return null;
}
}

public static DataTable TestFunction()
{
string OrnekSql = "SELECT * FROM FALANCA_TABLO";
return DataTableGetir(OrnekSql);
}
}


En sondaki TestFunction ile veritabanına istediğin SQL sorgusunu gönderip verini çekebilirsin.