public IEnumerable <GetAllTeamsQueryDataAccessOutput> Query()
{
using (var connection = _dataService.GetSqlConnection())
{
var query = "select Id, Name, CreateSharePointSite, CreateTeamsChannel from Teams";
return(connection.Query <GetAllTeamsQueryDataAccessOutput>(query));
}
}
public GetTeamQueryDataAccessOutput Query(Guid id)
{
using (var connection = _dataService.GetSqlConnection())
{
var query = "select Name, Description, CreateSharePointSite, CreateTeamsChannel from Teams where Id = @Id";
var parameters = new DynamicParameters(new { Id = id });
return(connection.QueryFirstOrDefault <GetTeamQueryDataAccessOutput>(query, parameters));
}
}
