/*
 * DisplayName : Access Column name
 * DataObjectField(true) : Is Identity
 * Must be Same Order Table
 * Must be similar types.
 * if you want to update you must define one DataObjectField
 * Table Name can be getted via class Display Name attribute. If you don't have a D.N.A. code will use class name. Sturct is working only struct name.
*/

public struct Users
{
  [DisplayName("ID"), DataObjectField(true)]
  public int id { get; set; }

  [DisplayName("Name")]
  public string Name { get; set; }

  [DisplayName("Surname")]
  public string Surname { get; set; }

  [DisplayName("Age")]
  public int PersonAge { get; set; }
}

// OR

[DisplayName("Users")]
public class MyUsers
{
  [DisplayName("ID"), DataObjectField(true)]
  public int id { get; set; }

  [DisplayName("Name")]
  public string Name { get; set; }

  [DisplayName("Surname")]
  public string Surname { get; set; }

  [DisplayName("Age")]
  public int PersonAge { get; set; }
}
 
 

//Set the path.
AccesWorker.DatabasePath = Server.MapPath("~/DB/test.mdb");

//AccesWorker.Provider = "Else Microsoft.JET.OLEDB.4.0";

        // Fill class without identity.
var newuser = new Users()
{
  Name = "Jhon",
  Surname = "Doe",
  PersonAge = 32
};

var InsertedID = AccesWorker.Insert(newuser);

       // Fill Class with identity
var updateuser = new Users()
{
  id = InsertedID,
  Name = "New Jhon",
  Surname = "Doe",
  PersonAge = 33
};

AccesWorker.Update(updateuser);

// Get All
  IEnumerable<Users> allDatas = AccesWorker.List(new Users()).Cast<Users>();

// Get 5
  IEnumerable<Users> top5 = AccesWorker.List(new Users(), 5).Cast<Users>();

// Get First
  Users getfirst = AccesWorker.List(new Users(), 1).Cast<Users>().FirstOrDefault();