C# LINQ Custom Provider to SQL

I want to use a custom LINQ provider to replace 'Parameter' object functionality that I've had in my Repository queries until now. These parameter objects took the following kind of form: PersonParameters { Id { get; set; } LastName { get; set; } FirstName { get; set; } } This object gets passed into the repository's Query(PersonParameters) method which in turn get forwarded it on to the DAL which would build an SQL query. The recordset output from this query got passed to an ObjectBuilder that constructs a Person objects which satisfy the parameters. I want to change these Query(PersonParameters) methods to return an IQueryable<T> to give me the flexibility of LINQ to replace the Parameter objects that build the SQL query. What I'm looking for is someone to create a QueryProvider that will take a Dictionary<string, string> that will map the incoming predicate's arguments to a database field. For example, if the following classes existed: Animal { string Name { get; set; } int NumberOfLegs { get; set; } Species Species { get; set; } } Species { string Name { get; set; } } Repository<Animal> { IQueryable<Animal> Query(); } I'd be able to write a query that looked like this: var animalRepository = new Repository<Animal>(); var query = [login to view URL]().Where(T=>T.NumberOfLegs=4 && [login to view URL] == "Lion").OrderBy(T=>[login to view URL]); I want a QueryProvider that will generate SQL with properties mapped to custom SQL field names. For example consider the following interface: IQueryMap { string TableName { get; } string[] TablesFields { get; } Dictionary<string, string> Mappings { get; } } An object that inherits this interface could be created with the following properties set: TableName = "AllTheAnimals"; TablesFields = new string[] { "id", "animalName", "animalsNumberOfLegs", "theAnimalSpeciesName", "amountOfFur" }; Mappings = new Dictionary<string,string>(); [login to view URL]("Name", "animalName"); [login to view URL]("NumberOfLegs", "animalsNumberOfLegs"); [login to view URL]("Species.Name", "theAnimalSpeciesName"); If this object were passed into the provider along with the query from above it would generate SQL that looks like this: SELECT animalName, animalsNumberOfLegs, theAnimalSpeciesName, amountOfFur FROM AllTheAnimals t0 WHERE [login to view URL] = 4 AND [login to view URL] = "Lion" ORDER BY [login to view URL] So essentially I want to create my own mapping objects that will be passed into the QueryProvider that map the LINQ query to SQL field names. I will then create the objects manually from the QueryProvider recordset enumerator. I've been referring to a microsoft tutorial here: [login to view URL] but have gotten confused by Expressions, ExpressionVisitors, etc etc etc etc I'll send through interfaces that I'm programming against for your reference. Many thanks