Query Index "Unable to cast object of type ... to type ..."

[Scott]

I think I have the most simple index possible:

public class ZipCodesWithAgent : AbstractIndexCreationTask<ZipCode, ZipCodesWithAgent.Result>

{

        public class Result

        {

            public ZipCode ZipCode { get; set; }

            public Agent Agent { get; set; }            

        }

        public ZipCodesWithAgent()

        {

            Map = zipcodes => from zip in zipcodes

                              select new

                              {

                                  ZipCode = zip,

                                  Agent = LoadDocument<Agent>(zip.AgentId)

                              };

            Store(x => x.Agent, Raven.Abstractions.Indexing.FieldStorage.Yes);

            Store(x => x.ZipCode, Raven.Abstractions.Indexing.FieldStorage.Yes);

        }

 }

I have tried each of the following:

var data = RavenSession.Query<ZipCodesWithAgent.Result, ZipCodesWithAgent>();

var data = RavenSession.Query<ZipCodesWithAgent.Result, ZipCodesWithAgent>().OfType<ZipCodesWithAgent.Result>();

But get:

Unable to cast object of type 'Models.ZipCode' to type 'Result'.

Every time. Any help is appreciated.

[Oren Eini (Ayende Rahien)]

You are using a Map for _indexing_.

Not for storage. It looks like what you want is a transformer, instead.

--
You received this message because you are subscribed to the Google Groups "ravendb" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ravendb+u...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[Kijana Woodard]

Maybe this:

http://ravendb.net/docs/client-api/querying/linq-extensions/project-from-index-fields-into?version=2

[Scott]

Kijana,

I don't see any ProjectFromIndexFieldsInto() method. 

Oren,

I will look in to a transformer.

[Kijana Woodard]

using Raven.Client;

using Raven.Client.Linq;

Google gave me older docs. I found the current copy:

http://ravendb.net/docs/2.0/client-api/querying/results-transformation/project-from-index-fields-into

[Scott Scowden]

Ugh! Can't believe I did that. I had Raven.Client.Linq, not Raven.Client. That worked, thank you!

--
You received this message because you are subscribed to a topic in the Google Groups "ravendb" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/ravendb/ZmgMTfaWbaA/unsubscribe?hl=en.
To unsubscribe from this group and all its topics, send an email to ravendb+u...@googlegroups.com.

[Kijana Woodard]

But...a transformer may be better. I didn't notice the LoadDocument before. Not sure how that plays with field Store.

TransformWith is in 2.5 unstable.

https://groups.google.com/forum/?fromgroups=#!topic/ravendb/kztoYT82lg8

[Kijana Woodard]

Or TransformResults in current builds:

http://ravendb.net/docs/2.0/client-api/querying/results-transformation/transform-results

[Scott]

Switched it, thanks!