How do I get the document from using ISession?

[weirdyang]

I'm trying out using ISession, I managed to save the items, and able to query the items using the index, but how do I the document id? I notice the mapIndex has a long property Id, can that be used?

        public async Task<List<TestEntity>> GetTestObjectByName(string name)
        {
            var items = await _session.Query<TestEntity, TestObjectIndex>(collection: TestEntity.Collection)
                .Where(item => item.Name.StartsWith(name))
                .ListAsync();

            return items.ToList();
        }

What could be the issue? Is it the contains?

Here's my code:

    public class TestObjectManager
    {
        private readonly ISession _session;

        public TestObjectManager(ISession session)
        {
            _session = session;
        }

        public async Task<List<TestEntity>> GetTestObjectByName(string name)
        {
            var items = await _session.Query<TestEntity, TestObjectIndex>(collection: TestEntity.Collection)
                .Where(item => item.Name.Contains(name, StringComparison.InvariantCultureIgnoreCase))
                .ListAsync();

            return items.ToList();
        }
        public async Task SaveTestObject(TestEntity testObject)
        {
            await _session.SaveAsync(testObject, TestEntity.Collection);
        }
    }
    public class TestEntity: Entity
    {
        public const string Collection = "TestObject";

        public string ObjectId { get; set; }  = Guid.NewGuid().ToString();

        public string Name { get; set; } = Path.GetRandomFileName();
    }
    public class TestObjectIndexProvider : IndexProvider<TestEntity>
    {
        public TestObjectIndexProvider() => CollectionName = TestEntity.Collection;

        public override void Describe(DescribeContext<TestEntity> context) =>
            context.For<TestObjectIndex>()
                .Map(test =>
                {
                    return new TestObjectIndex
                    {
                        Name = test.Name,
                        ObjectId = test.ObjectId,
                    };
                });
    }
    public class TestObjectIndex : MapIndex
    {
        public string ObjectId { get; set; }

        public string Name { get; set; }
    }
    public sealed class Migrations : DataMigration
    {
        public async Task<int> CreateAsync()
        {
            await SchemaBuilder.CreateMapIndexTableAsync<TestObjectIndex>(table => table
                .Column<string>(nameof(TestEntity.ObjectId), column => column.Unlimited())
                .Column<string>(nameof(TestEntity.Name), column => column.Unlimited()),
                collection: TestEntity.Collection);

            await SchemaBuilder.AlterIndexTableAsync<TestObjectIndex>(table => table
                .CreateIndex("IDX_TestObjectIndex_DocumentId",
                    "DocumentId",
                    "ObjectId",
                    "Name"
                    ),
                collection: TestEntity.Collection
            );

            return 1;
        }
    }

[hishamco]

Could you please give us an example of what you are trying to do?

[weirdyang]

The code is above, I just want to know how to get the document id of the returned models.

The first snippet shows how I am doing the query.

[weirdyang]

Declare a property id with type long on your model, this will be autopopulated with the document id

    public class TestEntity: Entity
    {
        public long Id { get; set; }

        public const string Collection = "TestObject";

        public string ObjectId { get; set; }  = Guid.NewGuid().ToString();

        public string Name { get; set; } = Path.GetRandomFileName();
    }

[hishamco]

Seems you solve yourself :)