How can I map Sql File Table in Entity Framework Core

Asked Jun 27 '21 at 19:12

Active Jun 28 '21 at 06:29

Viewed 462 times

Recently the company I work for used SQL Server FileTables. How can I map these tables in Entity Framework Core? This is one of them:

I've searched. There are some solutions like creating a stored procedure and so on. But unfortunately I cannot create any stored procedure or view or any other table.

I'm using C# 8.0, .NET Core 3.1 and EF Core 5.0

edited Jun 27 '21 at 20:09

marc_s

732,580
175
1,330
1,459

asked Jun 27 '21 at 19:12

Mohammad Mirmostafa

1,720
2
16
32

Scaffolding doesn't work? – Elyas Esna Jun 27 '21 at 20:50
No. It says: Could not find type mapping for column 'biz.ProductMerchantsImages.path_locator' with data type 'hierarchyid'. Skipping column. ... – Mohammad Mirmostafa Jun 27 '21 at 21:14
1

Does your EF Core project use [EntityFrameworkCore.SqlServer.HierarchyId](https://learn.microsoft.com/en-us/ef/core/extensions/#entityframeworkcoresqlserverhierarchyid)? – AlwaysLearning Jun 27 '21 at 21:39
It solved column mapping problem. Thanks. But table mapping problem is still alive. – Mohammad Mirmostafa Jun 28 '21 at 06:51
"But table mapping problem is still alive". do you get any error? – Elyas Esna Jun 28 '21 at 08:27
Yes. "Could not scaffold the primary key for 'biz.ProductMerchantsImages'. The following columns in the primary key could not be scaffolded: path_locator." "Unable to generate entity type for table 'biz.ProductMerchantsImages' since its primary key could not be scaffolded." – Mohammad Mirmostafa Jun 29 '21 at 02:33

How can I map Sql File Table in Entity Framework Core

0 Answers0