Hello all,

I would like someone to help me with Data Access and business logic layer coding using LINQ, C# 3.5 and ASP.NET

I will send the following to short-listed candidates.

1. SQL Server 2005 database as .bak file
2. c# 3.5 project (VS 2008)
3. a pdf document with detailed requirements

What I would like you to do:

1. Write LINQ, C# code for data access layer.
2. The code should be clean.
3. Good naming conventions, code comments should be followed.
4. The code will involve complex joins, subqueries etc. So strong experience in SQL Server database development and Linq is required.
5. The project is based on VS 2008, C# 3.5

I expect atleast 50-70 methods in this data access layer. Some of them easy and simple and some of them complex joins and queries.

I would like to welcome bids from experience developers please? I would like to see your previous work. This is urgent project so need someone who can turn this around quickly and make some quick money.

Looking forward to your bid and previous project experience.

No PHP/mySQL recommendation please. This is ASP.NET project.Update: Thanks for your bids and messages. But I can't select a programmer without knowing whether they have done Linq work before and it seems to be difficult to prove they have worked on Linq. So I have uploaded a simple database design and SQL script. I would like two methods:

Method 1: I would like to return all users and the roles they belong too.

Method 2: For a given user I would like to return user details and the roles they belong too.

This task is very simple and won't take more then 10-15 minutes for someone who knows what they are doing.

Whoever shows this task in c# project will win this project. This will be based on best source code provided. Also if I like your task and select you as a programmer I will pay $5 for the task you have done.

Hope the database is understandable without description. If you have any queries then please let me know.

This is just the first project. I have ongoing work which could easily earn $1000 a month.Attached file: UserRoles.JPG
File info: DB DiagramAttached file: UserRoles.sql
File info: SQL Script