How could I use table names from SQL using EF core if they named different ?

Question

0.00/5 (No votes)

See more:

In SQL Server named two Tables like this :
1-FXXL$Purchase Line
2- FXXL$Purchase Header

when i build a Modles then Dbcontext and trying to call those Tables with different form or name because i can't leave space or write '$' it won't call and the value is always null . i tried many forms but it doesn't work so far

i have two Lists of those classes :

What I have tried:

public WebshopDbContext(DbContextOptions<WebshopDbContext> dbContextOptions) : base (dbContextOptions)
       {

       }
       public List<FXXLPurchase_Header> FXXLPurchase_Header { get; set; }
       public List<FXXL_Purchase_Line> FXXLPurchase_Line { get; set; }

Posted 12-Sep-19 22:39pm

Abdalla Ben Omran

Updated 12-Sep-19 22:53pm

Add a Solution

2 solutions

Solution 1

Maybe this information will be useful:
Entity Framework Code First with SQL Server Synonyms - Stack Overflow[^]
Using Synonyms - SQL Server | Microsoft Docs[^]
sql server - SQL query tables aliases - Stack Overflow[^]

Posted 12-Sep-19 22:47pm

RickZeeland

Updated 12-Sep-19 22:50pm

v2

Comments

[no name] 13-Sep-19 6:00am

thanks for your help .

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Accepted Answer · 2019-09-12T22:54:00

Solution 2

I don't get you...

During the process of creating models, you have to use classes with friendly names:

C#

[Table("FXXL$Purchase Line")]
public class PurchaseLine
{
   //members here
}

Then you have to use the name of class:

C#

public List<PurchaseLine> FXXLPurchaseLine{ get; set; }

See: Code First Data Annotations - EF6 | Microsoft Docs[^]

Posted 12-Sep-19 22:54pm

Maciej Los

Comments

Simon_Whale 13-Sep-19 5:50am

Exactly what I would of said and have done many times

[no name] 13-Sep-19 6:01am

did you get the same problem once ? didn't get you very well .

Simon_Whale 13-Sep-19 6:27am

Yes I have and regularly use where I need to have the class name different to the actual table name. You can also use the [Table] attribute when you need to include schema's in your database design

[no name] 13-Sep-19 6:53am

Thanks for info Simon. i got you

Maciej Los 13-Sep-19 6:05am

Thank you, Simon.

[no name] 13-Sep-19 5:59am

Thanks for your help .
i have got two mistakes once was Public "DbSet" instead of list and what have you gave me from [Table("FXXL$Purchase Line")] it has helped me .

Maciej Los 13-Sep-19 6:05am

You're very welcome.

How could I use table names from SQL using EF core if they named different ?

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

How could I use table names from SQL using EF core if they named different ?

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us