I'm working to create a c# application, and in a portion of the application; I'm looking to bring in a .csv to a data table; and then basically loop through each row and query a database to see if the data exists.

I'm testing a LINQ query; but I can't seem to get it to run and display anything. I have the following code setup to run below:

I have the database added and the connection tests succesfully; I have the classes setup. I've been following some courses on pluralsight to test; and I'm not sure what exactly I am doing wrong or missing.

Also as a note; the table name is actually ERP.PartTran, and not PartTran, but I wasn't succesful in setting that up for the db context; could that be why?

EDIT: Code added; images removed

```
public class EpiDB : DbContext
        {
            public DbSet<Tran> PartTran { get; set; }
        }

        public class Tran
        {
            public int TranNum { get; set; }
            public string TranReference { get; set; }
            public string PartNum { get; set; }

        }

```

```
        private static void QueryPartTran()
        {
            var db = new EpiDB();
            int tranref = 4650374; //lookup number
            var query = from Tran in db.PartTran
                        where Tran.TranNum == tranref
                        orderby Tran.TranNum
                        select Tran;

            foreach (var Tran in query)
            {
                Debug.Print(Tran.PartNum);
            }
        }

```