Skip to content

Instantly share code, notes, and snippets.

@gnschenker
Created July 13, 2015 23:35
Get method of SQL Server repository
public T GetById<T>(Guid id) where T : class
{
using (var conn = new SqlConnection(_settings.ConnectionString))
{
const string sql = "SELECT * FROM Events WHERE AggregateId=@id";
var listOfEventData = conn.Query<EventData>(sql, new { id });
var events = listOfEventData.Select(x => x.DeserializeEvent());
var aggregate = _factory.Create<T>(events);
return aggregate;
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment