Documentation for Dapper.SqlBuilder

[markalanevans]

Hey guys, do you have any docs for how to use it?

For example, how does one do:

Select *, TotalUsers = (Select count(*) from Users where User.UserId=Profile.UserId) 
From Profile
WHERE Profile.ProfileId = 10

[mgravell]

What model do you want to populate here? Do you have a Profile class with
properties that match the table, for example? And where do you want
TotalUsers to go? Are we expecting one row? Or many? I'm guessing one, and
that TotalUsers is a member of Profile, in which case:

int profileId = 10;
var profile = connection.QuerySingleOrDefault<Profile>(
 @"Select ...
 ...
 WHERE Profile.ProfileId=@profileId",
 new { profileId });

I hope that renders OK - am on 'phone...

On Tue, 15 Mar 2016 23:11 Mark Evans, notifications@github.com wrote:

Hey guys, do you have any docs for how to use it?

For example, how does one do:

Select , TotalUsers = (Select count() from Users where User.UserId=Profile.UserId)
From Profile
WHERE Profile.ProfileId = 10

—
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub
#480

[markalanevans]

Hi @mgravell thank you.

I should have been more clear. I'm wondering how you do nested select queries using the SqlBuilder.

Where in this case, there is a select query with WHERE's that are are a sub select.