Skip to content

Instantly share code, notes, and snippets.

@ssougnez

ssougnez/wp-dapper-10.cs

Created June 8, 2018 13:39
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/7f0bbf2603a0b73ceef351c89719f899 to your computer and use it in GitHub Desktop.
Save ssougnez/7f0bbf2603a0b73ceef351c89719f899 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
wp-dapper-10.cs
string sql = $@"SELECT [Tracks].[Id], [Tracks].[Title],
[Drivers].[Id], [Drivers].[FirstName], [Drivers].[LastName], [Drivers].[ChampionTitleCount]
FROM [Tracks]
INNER JOIN [Drivers]
ON [Drivers].[Id] = [Tracks].[BeastLapTimeDriverId]
WHERE [Tracks].[Id] = 1;";
Track track = (await connection.QueryAsync<Track, Driver>(sql)).FirstOrDefault();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment