Skip to content

Instantly share code, notes, and snippets.

@ssougnez
Created June 8, 2018 13:42
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ssougnez/5d58e588be9bc72985d6c272e6b56a79 to your computer and use it in GitHub Desktop.
Save ssougnez/5d58e588be9bc72985d6c272e6b56a79 to your computer and use it in GitHub Desktop.
string sql = $@"SELECT [Id], [Title] FROM [Tracks] WHERE [Tracks].[Id] = 1;
SELECT [Id], [FirstName], [LastName] FROM [Drivers] WHERE [Id] IN (SELECT [DriverId] FROM [TrackWinners] WHERE [TrackWinners].[TrackId] = 1)";
using (var reader = await connection.QueryMultipleAsync(sql))
{
var track = reader.Read<Track>().FirstOrDefault();
if (track != null)
{
track.Winners = reader.Read<Driver>().ToList();
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment