I am using Simple.Data to query the DB. but this particular DB is imported from Access DB.
some of the filed names has space, -, / in it.
Policy Number
FTZ?
Prod/Co
Covg - Years
is it possible to use Simple.Data? how do you name your object so Simple.Data will know which field to query.
public class item {
public string "Policy Number" {get; set;}
public string "FTZ?" {get; set;}
...
}
You can just leave out non-alphanumeric characters in your identifiers, and Simple.Data will still find the matching columns.
e.g.
Item item = db.Items.FindByPolicyNumber(pnum);