Will you get the benefits of IQueryable if you use entity projections?
===

Lets say I have a method like this:

    IQueryable<MyFlatObject> GetMyFlatObjects()
    {
    	using (var context = new MyEntities())
    	{
    		return context.MyEntities.Select(x => new FlatObject()
                                                      {
                                                         Property1 = x.PropertyA,
                                                         Property2 = x.PropertyB,
                                                         Property3 = x.PropertyC,
                                                      });
    	}
    }

Now if I call:

    MyService.GetMyFlatObjects().Where(x => x.Property1 == "test");

Sanity check. This filter will not propagate to my database store (like if I had just queried my entities), but instead I will get all results back and be using LINQ-to-objects to filter. Right?