title: how to automatically create a class compatible with the access table?
body: <p>i want to use Linq to connect to a access2007 database (i don't want to use ado.net).</p>
  
  <p>i saw some examples but all of them make a class of the object i want to import from the database for example </p>
  
  <pre><code> public class Company
   {
       public string Name
       { get; set; }
  
       public List ListEmp
       { get; set; }
   }
  
  var EmpDetails = from comp in ListCompany
                            select new
                            {
                                Emp = (from emp in comp.ListEmp
                                       select new { Company = comp.Name, emp })
                            };
  </code></pre>
  
  <p>thats is easy when u have a small database , but i have a database with 30 attribute in a table so it will be hard to make a class specifically for the object from the table </p>
  
  <p>so is there a way easier like automatically create an object compatible with the objects from the table </p>
  
  <p>if i wasn't clear please tell me so i could clarify it </p>
  
  <p>thanks</p>