Question Develop a Linq query

[ammar.dev]

Hello,
I have a database in Access with this architecture:

and I need with Linq to calculate and return the total price of a candidate’s training knowing that only the candidate who has attended at least 5 trainings gets a 20% discount.

how to get this result with linq?

 

[NoUserHere]

It would also be nice to see what you have tried and show us where you are stuck?

Can you also explain why it needs to use Linq?

Can you show how you wrote your select statement?

 

[jmcilhinney]

I don't think that what you're asking for is possible. I'm not aware of the existence of a LINQ provider for Access. LINQ to SQL is a dedicated SQL Server provider. LINQ to Entities is the provider for Entity Framework and EF support exists for various databases but I'm not aware that Access is one of them. LINQ to DataSet can be used if you have already retrieved the data from the database into a DataTable but that is information that you should have provided. Likewise, LINQ to Objects can be used if you have already retrieved the data into a collection of objects of a dedicated type.

So, why do you think you NEED to do this with LINQ and why do you think it should be possible with an Access database?

 

[NoUserHere]

I don't think that what you're asking for is possible.

See top two answers : Query Microsoft Access MDB Database using LINQ and C#

 

[jmcilhinney]

See top two answers : Query Microsoft Access MDB Database using LINQ and C#

Based on that, the answer is to use that third-party Jet EF provider and learn how EF works. Once you know how EF works, you know how to write a LINQ to Entities query, so that it is an Access database becomes irrelevant.