Entity Framework Core - Knowledge Base (KB)

WPF and EF6 mark model entity as having chnages

Background:... I have a wpf 4.5 application that is built with MVVM (MVVM-Light) and Enitity Framework 6 db first. ...I have several viewmodels that have a list/details set up with a list of objects in a listbox and a details grid that displays and allow...

EF6 Code First : Entity with multiple relationships

I am creating a new database using EF code-first which contain the following classes: ...Address, Contact, Account, Customer (a sub-class of Account), and SalesOrder. ...The Address class is the one giving me problems at the moment, it can have no foreig...

SQL server view return different results in Entity Framework

I have a sql view in SQl server:...SELECT dbo.job.idJob, SUM(dbo.tracking.iQty) AS TotalOrdered, dbo.tracking.idProduct FROM dbo.tracking INNER JOIN dbo.job ON dbo.tracking.idJob = dbo.job.idJob GROUP BY dbo.trac...

Calling a function within Entity Framework Select

A property from my object (...oJobs...) is as follows:... Private _brandlist As List(Of DAL.Brand) Public Property PostBrandList() As List(Of DAL.Brand) Get Return _brandlist End Get Set(ByVal value As List(Of DA...

How do I create an Entity Framework DbSet with data from 2 tables

Before I start my question, I will point out that this is for an assignment in a programming course I am doing, and I'm afraid the code needs to be in VB....Scenario: We are writing an app to help manage a veterinary clinic. There is a legacy MySQL databa...

Entity Framework Core Linq query doesn't translate to correct SQL statements

So I am debugging our application which uses Entity Framework Core 2.1.14. I created my entities from database first by scaffolding. Database is MySQL 5.7.29, the SQL data provider for EF Core is Oracle's MySql.Data.EntityFrameworkCore 8.0.19....Example: ...