Map Geometry type in func and stored procedures

[Dimigergo]

In issue #1349 the "Geometry" type is corrent not, but the using NetTopologySuite.Geometries; line is missing.

EF Core Power Tools: 2.5.966

Sample project is the same: EFCore5Geography.zip

[bngapiusr]

I'm trying to use EF Core Power Tools version: 2.5.966 to reverse engineer Northwind db but I'm not getting any results when I call the store procedure.

       using (var db = new NorthwindDbContext())
        {

            var orders = await db.Procedures().CustOrderHistAsync("ALFKI");

            foreach (var order in orders)
                Console.WriteLine($"{order.ProductName}: {order.Total}");
          }

I'm following the example in the docs. I noticed the examples has
var orders = await db.GetProcedures().CustOrderHist("ALFKI") and not the async method
db.Procedures().CustOrderHistAsync("ALFKI") that I'm using above. The generated code only provide the async option so I don't know what I'm missing here.

I'm using EF Core 5.16 and I tested it in VS2019 and VS2022.

Thank you!

[ErikEJ]

The docs probably need an Update

Does the call error? Do you have any data in the table?

[bngapiusr]

no errors and I have data in the table. I tested the store procedure in ssms and I got some data back.

[ErikEJ]

@bngapiusr You a posting in a completely unrelated issue !?

[ErikEJ]

@Dimigergo Where is it missing?

[bngapiusr]

oh sorry about that. I'll create a new issue.

[Dimigergo]

@Dimigergo Where is it missing?

The top of the generated func or sp .cs. It generates the file with Geometry type, but no using NTS at the top.

[Dimigergo]

This is the generated file:

[ErikEJ]

Thanks.

[ErikEJ]

@Dimigergo Fixed in latest daily build