Skip to content

Instantly share code, notes, and snippets.

@kenny-evitt

kenny-evitt/gist:9121755

Created February 20, 2014 19:48
Show Gist options
  • Save kenny-evitt/9121755 to your computer and use it in GitHub Desktop.
Save kenny-evitt/9121755 to your computer and use it in GitHub Desktop.
Download ZIP
NHibernate QueryOver AndRestrictionOn IsIn generated SQL
Raw
gistfile1.sql
exec sp_executesql N'SELECT this_.ThingId as ThingId261_0_, this_.SomethingRelatedId as SomethingRelatedId261_0_, this_.Label as Label261_0_, this_.IsAwesome as IsAwesome261_0_, this_.IsAmazing as IsAmazing261_0_, this_.IsCool as IsCool261_0_, this_.FriendlyName as FriendlyName261_0_, this_.TypeId as Ty8_261_0_, this_.StatusId as StatusId9_261_0_, this_.LastUpdatedUserId as LastUpdatedUserId261_0_ FROM Things this_ WHERE this_.ThingId in (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14)',N'@p0 int,@p1 int,@p2 int,@p3 int,@p4 int,@p5 int,@p6 int,@p7 int,@p8 int,@p9 int,@p10 int,@p11 int,@p12 int,@p13 int,@p14 int',@p0=9436,@p1=9411,@p2=8905,@p3=8829,@p4=8803,@p5=8804,@p6=8683,@p7=8930,@p8=10012,@p9=10012,@p10=10012,@p11=8449,@p12=8470,@p13=8461,@p14=8443
@kenny-evitt
Copy link
Author

This SQL (or something similar) was generated by NHibernate code based on the Stack Overflow question nhibernate - QueryOver IN Clause?.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment