entities framework

Question

I Have the following code that I use. However, I'm trying to use the Table Name to retrieve the data and the entities.

        SalesInvoiceList = (from p in entities.SalesCards
                            select new SalesInvoice
                            {
                                ID = p.ID,
                                InvoiceNo = p.InvoiceNo,
                                DateTime = p.DateTime,
                                ContactName = p.CustomerCard.ContactName,
                                CompanyName = p.CustomerCard.CompanyName
                            }).ToList();

I want to be able to do the following or something similar

        SalesInvoiceList = (from p in "DBO.SALESCARD"
                            select new SalesInvoice
                            {
                                ID = p.ID,
                                InvoiceNo = p.InvoiceNo,
                                DateTime = p.DateTime,
                                ContactName = p.CustomerCard.ContactName,
                                CompanyName = p.CustomerCard.CompanyName
                            }).ToList();

What is the best way to do that?

Thanks

Answer 1

Not sure if i am understanding what you want to do correctly but if i am this should be a easy solution to what you are trying to do.

  public List<SalesInvoice> GetSalesInvoices()
    {
       var _db = new yourDbContext();

    var query = _db.TableThatHasSalesInvoices;

    return query.ToList(); 
    }

Answer 2

You can always use EF just to map some query to your object

Db.Database.SqlQuery<SalesInvoice>("SELECT ID, InvoiceNo, DateTime, ContactName, CompanyName FROM dbo.[SALESCARD]");