Database and Data Access Layer in C#/ (first of many projects)

Project Type


Software/Database Programming and Integration in C#/[url removed, login to view]



2 weeks

Project Description


We are looking for a programmer to create our database solution, including tables, stored procedures, and data access code in C#/.NET 2.0 to interact with the database.

We are developing a customer-facing application in .NET; we have already-implemented logic, but no database integration.

We will provide stored procedures and table descriptions once a bid is accepted.

Important: This is one of many similar .NET projects that we have

, if the project goes well then more work will be available.

Payment bonus


We are looking for a high quality product and will consider up to a 25% bonus for excellent work.

This bonus is completely at our discretion and will be paid if we are very happy with the work.

Guidelines to make us very happy:

- Finish work before the deadline.

- Have no obvious errors/bugs in the deliverables and high quality, safe, well documented code.

- Provide us with good communication - make sure we know what is going on!

Project details


Project is in ASP.NET 2.0/C# (definitely no VB)

MS SQL required (preferably MS SQL 2005)

Should initially work with SQL Express Edition

Database layer should be [url removed, login to view]

Roughly 10 tables w/ 3-10 fields each, and roughly 30 stored procedures to code, plus C# wrappers for each sproc.

Project requestor (us) has 7 years of software experience at a major US software developer.



Data tables to represent the domain

A description of the data model

Full stored procedures (sprocs) to access the tables

Full database creation scripts for tables, sprocs and everything else necessary to run them

A working .mdf sample that we can import into SQL Express

C# data layer in [url removed, login to view] to bridge our C# business logic objects to the database (for programmatic access)

Working C# example application that demonstrates every data request in the data layer

Source code and data files for all of the above

A short design-time description of what will be built, BEFORE coding starts

Example of what we want for a single data type


The table Birds should contain a representation for each data field in the C# Bird object, e.g. Id, name, # of wings, etc.

There should be a sproc which will return a single Bird (by id/by name etc), or return all Birds if none is specified.

(There should be other sprocs to write data as well but they aren't covered in this example).

In C#, there should be [url removed, login to view] logic to connect to the database, read the Birds object, handle any errors, and load the data

into the C# Bird business object (which we have provided).

Finally, the sample application should have a call to test loading data from the database into the object.

When this is done, we should be able to write code like the following:

Bird Bird = new Bird();

[url removed, login to view]([url removed, login to view]); // this is the wrapper function which you will write

string strName = Bird.m_strName; // Use data in object

Legal requirements


Note: The full contract will replace <ourcompany> with our full company name once we agree to work together.

Project contents are defined as any material or knowledge including but not limited to: source code, data modeling, documents, data files, and communication between programmer(s) and <ourcompanyname>.

All work done on this project becomes the intellectual and legal property of <ourcompanyname> (a <ourstate> Limited Liability Company in the United States).

All work on this project is to be Copyright 2008 <ourcompanyname>.

Absolutely no project contents may be shared with any outside parties, unless at the specific request of <ourcompany>.

No project contents may be used on any other projects except for future projects for <ourcompany>.

Open source modules may be used in the software; however, ALL open source modules must be submitted for review and approval to <ourcompany> before use.

Open source development tools may be used if the use does not conflict with the tool's license.

Other Requirements


Before coding, we require approval of the coder's proposed plan for the tables, sprocs, and data layer.

The database and stored procedures should be completed before the data access layer.

The code should be as bug-free as possible; at a minimum, all of the tests in the sample application should work without errors.

Technical requirements


The implementation can use [url removed, login to view] datasource controls (such as datareader/dataset), but we don't want to use any data display adapters such as GridView or ListView.

We only need programmatic access to the data from C#.

The source code should have adequate block-level documentation, e.g. explaining what a stored procedure/table does, or explaining non-obvious logic.

All calls to the data access layer should be protected by try/catch/finally statements.

C# variable names should have the following notation:

Hungarian notation for basic types


string strMyString;

int nMyInt;

bool fMyFlag;

member variables have m_ prefix

PascalNotation for class names

camelNotation for variable names


MyClass myObject = new MyClass();

myObject.m_strMemberString = "assigning to member string";

Skills: .NET, ASP

See more: sql data access layer, data access layer, database access layer, data access sprocs, data access layer sql express 2008, sample projects access database, database data layer, sql database wrapper, create data access layer, data access layer stored procedures, net pascalnotation, project name use data access layer, type project data layer project, w.s. development, write legal documents, wrapper programming, wrapper application, working for first data, working at the limited, what is vb net used for, what is the use of vb net, what is sql coding, what is net programming, what is ms project plan, what is in programming

About the Employer:
( 5 reviews ) CEDAR PARK, United States

Project ID: #232548

36 freelancers are bidding on average $542 for this job


Please check my PMB

$750 USD in 25 days
(63 Reviews)

kindly check PM

$750 USD in 14 days
(52 Reviews)

Check PM for details

$750 USD in 14 days
(13 Reviews)

Hi, I'm expirienced .Net and MS SQL developer and support specialist (have 5 years expirience). I will be glad to take part and create this job for you. Regards, Vitali

$600 USD in 10 days
(1 Review)

I can do this for you using C# (1.1 or 2.0) with any database and you will see my work.

$550 USD in 12 days
(42 Reviews)

Please see the PMB

$750 USD in 15 days
(15 Reviews)

dear vanillia , We have looked through your information and are interested in your [login to view URL] to give us one opportunity. We have a strong team in webapps' [login to view URL] we assure to comply with your deadline. More

$680 USD in 14 days
(2 Reviews)

Please view the PM

$750 USD in 14 days
(3 Reviews)

Hello Sir, I will provide you the best, please check your PM for works done by me using Regards,

$650 USD in 14 days
(6 Reviews)

Check PM for details

$500 USD in 20 days
(5 Reviews)

Please, check PM

$250 USD in 14 days
(2 Reviews)

Sir We are ready to start this job see PM for more details thanks.

$700 USD in 20 days
(3 Reviews)

Hello,I have extensive experience in .net and sql server.I can do this work with all your specification and [login to view URL] you.

$300 USD in 10 days
(4 Reviews)

Hello, Please see PM. Regards,

$300 USD in 3 days
(1 Review)

Please see PM. Thanks.

$700 USD in 15 days
(2 Reviews)

Hi Please refer to PM -Thanks

$477 USD in 11 days
(1 Review)

The best way to do a Data Access Class is using Pattern Designs I suggest: [login to view URL] but we can discuss it. Anyway the best practice is to do a templ More

$500 USD in 15 days
(1 Review)

Hello, we are a small tema of .NET developers. We are all MS certified professionals in various fields. We are interested to work on your project and we will do our best in order to complete your requirements. We have More

$500 USD in 14 days
(1 Review)

Please Check PM

$500 USD in 15 days
(0 Reviews)

hi there, i have a lot experience with [login to view URL], please see my resume please let me help you do it thanks

$500 USD in 10 days
(0 Reviews)