I am using a component from a company called Devart. This component produces a data model very much like Entity Framework except it is for SQLite. I have my data models and data context, etc very similar to the way Entity Framework works.

I created a Windows .NetFramework DLL Class Library that I will use to handle many of my database related activities. Within this DLL I have my data models and data context which of course contain all of my table class types etc.

Inside my DLL I can write the following code:

   public dbSales.tbl_Customers GetCustomer_byCustomerID(int _customerID)
   {
          dbSales.tbl_Customers selectedCustomer = (from dbContext.tbl_Customers 
                                                    where i.CustID == _customerID 
                                                     Select i).FirstOrDefault();
   }

Then in my other program I want to reference the DLL and that method to retrieve data. I do not know how to expose the types for my tables so that I can do the following: my DLL contains a class called DataHelper.

(The code is written in expanded form for clarity)

DataHandler.DataHelper.tbl_Customers selectedCustomer = new DataHandler.DataHelper.tbl_Customers();
selectedCustomer = DataHandler.DataHelper.GetCustomer_byCustomerID(45);

I do not know how to expose the type: tbl_Customers. It is simply my ignorance. The only work around I have found is to do the following using var. I like to be able to specify my types though and do not like using var. The following works:

var selectedCustomer = DataHandler.DataHelper.GetCustomer_byCustomerID(45);

I’ve tried making different things public such as the model, or the context, etc. But still it is as if I am only exposing methods and properties. I am simply ignorant about types and how to work with them. I honestly would like to find a good book that explains types and how to work with them.

If anyone can provide assistance with this, it would be greatly appreciated.

Source: Windows Questions