Cancelled

Database and Data Access Layer in C#/[url removed, login to view] (first of many projects)

Project Type

--------------

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

Timeframe

------------

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 [url removed, login to view] 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.

Deliverables

----------------

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

e.g.

string strMyString;

int nMyInt;

bool fMyFlag;

member variables have m_ prefix

PascalNotation for class names

camelNotation for variable names

E.g.

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, sample projects access database, database data layer, sql database wrapper, create data access layer, net pascalnotation, wrapper programming, wrapper application, working first data, working limited, net used, programming used, programmer need know, programmer know, vb creation, variables programming, variable programming, up string, types programming errors, types programming, test data creation, table contents design

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

Project ID: #232548

36 freelancers are bidding on average $542 for this job

meetesh

Please check my PMB

$750 USD in 25 days
(63 Reviews)
7.9
HeoQue

kindly check PM

$750 USD in 14 days
(52 Reviews)
6.7
teckit

Check PM for details

$750 USD in 14 days
(13 Reviews)
6.1
GoodFellow3

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)
5.8
MMaghawry

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)
5.5
value4u

Please see the PMB

$750 USD in 15 days
(15 Reviews)
5.1
Kingsky

dear vanillia , We have looked through your information and are interested in your project.Eager to give us one opportunity. We have a strong team in webapps' development.So we assure to comply with your deadline. More

$680 USD in 14 days
(2 Reviews)
4.3
softtechprovider

Please view the PM

$750 USD in 14 days
(3 Reviews)
4.2
rajneeshag

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

$650 USD in 14 days
(6 Reviews)
3.7
foxonfly

Check PM for details

$500 USD in 20 days
(5 Reviews)
3.4
Balu13

Please, check PM

$250 USD in 14 days
(2 Reviews)
3.4
livesolutions

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

$700 USD in 20 days
(3 Reviews)
3.4
hfreelancer

Hello,I have extensive experience in .net and sql server.I can do this work with all your specification and requirement.Thank you.

$300 USD in 10 days
(4 Reviews)
3.1
mbedoya

Hello, Please see PM. Regards,

$300 USD in 3 days
(1 Review)
3.0
Xyris

Please see PM. Thanks.

$700 USD in 15 days
(2 Reviews)
2.8
durga27han15

Hi Please refer to PM -Thanks

$477 USD in 11 days
(1 Review)
2.7
nzalles

The best way to do a Data Access Class is using Pattern Designs I suggest: http://java.sun.com/blueprints/corej2eepatterns/Patterns/DataAccessObject.html but we can discuss it. Anyway the best practice is to do a templ More

$500 USD in 15 days
(1 Review)
1.3
milenp

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)
0.0
vishalthakkar

Please Check PM

$500 USD in 15 days
(0 Reviews)
0.0
emprisestar

hi there, i have a lot experience with MS.NET, please see my resume please let me help you do it thanks

$500 USD in 10 days
(0 Reviews)
0.0