public T QuerySql <T>(string sql, string connectionString) where T : class
{
var dbconnection = new SQLiteConnection(connectionString);
try
{
var dbcommand = new SQLiteCommand();
dbcommand.Connection = dbconnection;
var dba = new SQLiteDataAdapter(dbcommand);
if (dbconnection.State == ConnectionState.Closed)
{
dbconnection.Open();
}
dbcommand.CommandText = $"{sql};";
var dt = new DataTable();
dba.Fill(dt);
var json = JsonSerialzer.SerializeObject(dt.ToDictionary("yyyy/MM/dd HH:mm:ss"));
dba.Dispose();
return(JsonSerialzer.DeserializeObject <T>(json));
}
catch (Exception ex)
{
LogManager.WriteLog(ex.Message);
throw ex;
}
finally
{
dbconnection.Close();
}
}
static SqliteDBHelper()
{
JsonSerialzer = new JsonSerialzer();
LogManager = new LogManager();
}