how to write string array index in ravendb

Question

i have ravendb document called Orders like this

{
"MyOrders": [
    "S1",
    "S2"
],

"Id": "6666"
}

I will query this document and pass order string for example S1 Then it should return me that document as S1 matches it. I am pretty new to this ravendb. I am unable to find way. I have written only this so far

   public class MyOrderIndexes: AbstractIndexCreationTask<Order>
{

    public MyOrderIndexes()
    {
        Map = Orders => from Order in Orders
                                 select new
                                             {
                                                 ID= Order.Id
                                             };
        Index(x => x.Id, FieldIndexing.NotAnalyzed);
    }
}

can someone help me

Judah Gabriel Himango · Accepted Answer · 2018-12-12 17:02:08Z

2

To query that, you don't need to create an index. Just do a query, Raven will create it for you.

This query should work just fine:

var hasS2 = session.Query<Orders>()
   .Where(o => o.MyOrders.Contains("S2"))
   .ToList();

edited Dec 12, 2018 at 17:02

answered Dec 11, 2018 at 18:49

Judah Gabriel Himango

60.2k39 gold badges162 silver badges217 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

James Over a year ago

So when we need to write index?

James Over a year ago

it complains that it cannot understand expression .Where(o => o.MyOrders.Any(myO => myO == "S2"))

Judah Gabriel Himango Over a year ago

Try use .Contains instead. I've updated the post with the code sample.

Judah Gabriel Himango Over a year ago

>> "When do we need to write an index?" If you need special handling for fields at index time. For example, maybe you want to add spatial search data for a particular field, so that you can later search by geographic coordinates. Indexes are useful for such scenarios. But I recommend you let Raven handle indexes; my personal approach is, "Unless there's a special reason to write an index, don't. Let Raven handle it."

James Over a year ago

can you help me with index as i have pressure to write index and i am still struggling

|

Embri · Accepted Answer · 2018-12-11 13:30:59Z

0

One problem is the FieldIndexing on Id, and also that you need to map MyOrders to perform query on it.

Index:

public class MyOrderIndexes: AbstractIndexCreationTask<Order>
{    
    public MyOrderIndexes()
    {
        Map = Orders => from Order in Orders
                                 select new
                                 {
                                       Id = Order.Id,
                                       MyOrders = Order.MyOrders
                                 };
    }
}

Query:

var results = session
    .Query<Order, MyOrderIndexes>()
    .Where(x => x.MyOrders.Any(l => l == "S1"))
    .ToList();

Model:

public class Order
{
    public string Id { get; set; }
    public ICollection<string> MyOrders { get; set; }
}

answered Dec 11, 2018 at 13:30

Embri

6223 silver badges15 bronze badges

4 Comments

James Over a year ago

i have like this public List<string> MyOrders { get; private set; }

Embri Over a year ago

remove the private

James Over a year ago

what we acheive doing so and what is impact?

Embri Over a year ago

i'm not sure that RavenDB can set MyOrders with private set

Collectives™ on Stack Overflow

how to write string array index in ravendb

2 Answers 2

8 Comments

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

8 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related