C# Linq Provider - Mongo Driver - How to view / tell the Mongo query that is about to be sent to the server? - mongodb-user

The old Google Groups will be going away soon, but your browser is incompatible with the new version.
Message from discussion C# Linq Provider - Mongo Driver - How to view / tell the Mongo query that is about to be sent to the server?
View parsed - Show only message text
Received-SPF: pass (google.com: domain of rob...@10gen.com designates 209.85.212.50 as permitted sender) client-ip=209.85.212.50;
MIME-Version: 1.0
In-Reply-To: <09bf7500-7d09-47ac-8477-ada8d5b51948@googlegroups.com>
References: <09bf7500-7d09-47ac-8477-ada8d5b51948@googlegroups.com>
Date: Fri, 12 Oct 2012 14:52:09 -0400
Message-ID: <CAJCJWG2kdC6D--yNBtfjD+rn8H+vBXa_HYdj9gk4_mvHKi=...@mail.gmail.com>
Subject: Re: [mongodb-user] C# Linq Provider - Mongo Driver - How to view /
 tell the Mongo query that is about to be sent to the server?
From: Robert Stam <rob...@10gen.com>
To: mongodb-user@googlegroups.com
Content-Type: multipart/alternative; boundary=20cf307d04085853a804cbe12f76

--20cf307d04085853a804cbe12f76
Content-Type: text/plain; charset=ISO-8859-1

There is. You can do this:

    var query =
        from x in collection.AsQueryable<C>()
        where x.Id == 1
        select x;

    var json = ((MongoQueryable<C>)query).GetMongoQuery().ToJson();


The json variable is now a string that represents the native MongoDB query.

On Fri, Oct 12, 2012 at 2:41 PM, Jonathan Gill <jonathan.g...@gmail.com>wrote:

> We're having an issue were we need to see the Mongo query that is being
> sent to Mongo from the Mongo C# driver's LINQ provider for a "complex"
> query with ANDs and ORs.
>
> Is there a property or way to view this in C# from the IQueryable that is
> being built up?
>
> --
> You received this message because you are subscribed to the Google
> Groups "mongodb-user" group.
> To post to this group, send email to mongodb-user@googlegroups.com
> To unsubscribe from this group, send email to
> mongodb-user+unsubscribe@googlegroups.com
> See also the IRC channel -- freenode.net#mongodb
>

--20cf307d04085853a804cbe12f76
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

There is. You can do this:<div><br></div><div><div><font face=3D"courier ne=
w, monospace">=A0 =A0 var query =3D</font></div><div><font face=3D"courier =
new, monospace">=A0 =A0 =A0 =A0 from x in collection.AsQueryable&lt;C&gt;()=
</font></div><div>
<font face=3D"courier new, monospace">=A0 =A0 =A0 =A0 where x.Id =3D=3D 1</=
font></div><div><font face=3D"courier new, monospace">=A0 =A0 =A0 =A0 selec=
t x;</font></div><div><font face=3D"courier new, monospace"><br></font></di=
v><div><font face=3D"courier new, monospace">=A0 =A0 var json =3D ((MongoQu=
eryable&lt;C&gt;)query).GetMongoQuery().ToJson();</font></div>
<div><br></div><div><br></div><div>The json variable is now a string that r=
epresents the native MongoDB query.</div><br><div class=3D"gmail_quote">On =
Fri, Oct 12, 2012 at 2:41 PM, Jonathan Gill <span dir=3D"ltr">&lt;<a href=
=3D"mailto:jonathan.g...@gmail.com" target=3D"_blank">jonathan.g...@gmail.c=
om</a>&gt;</span> wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex">We&#39;re having an issue were we need to se=
e the Mongo query that is being sent to Mongo from the Mongo C# driver&#39;=
s LINQ provider for a &quot;complex&quot; query with ANDs and ORs.<br>
<br>Is there a property or way to view this in C# from the IQueryable that =
is being built up?<span class=3D"HOEnZb"><font color=3D"#888888"><br>

<p></p>

-- <br>
You received this message because you are subscribed to the Google<br>
Groups &quot;mongodb-user&quot; group.<br>
To post to this group, send email to <a href=3D"mailto:mongodb-user@googleg=
roups.com" target=3D"_blank">mongodb-user@googlegroups.com</a><br>
To unsubscribe from this group, send email to<br>
<a href=3D"mailto:mongodb-user%2Bunsubscribe@googlegroups.com" target=3D"_b=
lank">mongodb-user+unsubscribe@googlegroups.com</a><br>
See also the IRC channel -- <a href=3D"http://freenode.net#mongodb" target=
=3D"_blank">freenode.net#mongodb</a><br>
</font></span></blockquote></div><br></div>

--20cf307d04085853a804cbe12f76--
Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
Account Options
