public async Task <IEnumerable <User> > GetAllAsync()
{
string query = "SELECT * FROM users;";
await _connection.OpenAsync();
var users = await _connection.ExecuteReaderAsync <User>(query);
_connection.Close();
return(users);
}
private void DisposeConnection()
{
try
{
lock (_disposeLock)
{
using (lock_manager.getLockItem().Write())
{
if (_connection != null)
{
using (_connection)
{
_connection.Close();
}
_connection = null;
}
CloseConnection();
}
}
}
catch (Exception ex)
{
Logger.ErrorException("Error disposing database", ex);
}
}
private void PrepareCurrentConnection(IDatabaseConnection connection)
{
CurrentConnection = connection;
CurrentConnection.Open();
SqlCommon.Status.Set(CurrentConnection);
CurrentConnection.Close();
SqlCommon.SqlForm.Text = String.Format("{0} - {1}", connection.Name, Global.FullTitle);
SqlCommon.DatabaseContent.ConnectedTo();
SqlCommon.SqlForm.menuWindowNewSame.Enabled = true;
}
private static void TestDbConnection(IDatabaseConnection connection)
{
connection.Open();
connection.SetCommandType(SqormCommandType.Text);
string query = "SELECT * FROM users WHERE id >= @id;";
var users = connection.ExecuteReader<User>(query, new ParameterContainer {{ "@id", 1 }});
query = "SELECT * FROM users WHERE id=@id;";
connection.SetCommandType(SqormCommandType.StoredProcedure);
connection.Close();
foreach (var user in users)
{
System.Console.WriteLine(user.ToString());
}
}
