Database and Data Access Layer in C#/ASP.net/SQL (first of many projects) (877200)

已完成 已发布的 Mar 2, 2008 货到付款
已完成 货到付款

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.

## Deliverables

Project Type

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

Software/Database Programming and Integration in C#/[login to view URL]

Timeframe

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

2 weeks

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 [login to view URL]

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 [login to view URL] 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 [login to view URL] 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();

[login to view URL]([login to view URL]); // 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 [login to view URL] 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";

.NET ASP C# 编程 工程 MySQL PHP 软件构架 软件测试 SQL

项目ID: #3767689

关于项目

45个方案 远程项目 活跃的Mar 5, 2008

授予:

billdoornz

See private message.

$255 USD 在38天内
(7条评论)
4.6

有45名威客正在参与此工作的竞标,均价$210/小时

jared23

See private message.

$212.5 USD 在38天内
(289条评论)
7.6
gkalish

See private message.

$255 USD 在38天内
(294条评论)
6.9
suthernsoftware

See private message.

$191.25 USD 在38天内
(60条评论)
6.6
brightsolnslx

See private message.

$170 USD 在38天内
(299条评论)
6.4
shortwire

See private message.

$170 USD 在38天内
(82条评论)
5.8
techbdvw

See private message.

$255 USD 在38天内
(15条评论)
5.4
ceevee06

See private message.

$255 USD 在38天内
(38条评论)
5.8
suryavijayvw

See private message.

$255 USD 在38天内
(129条评论)
5.7
zeesoft

See private message.

$255 USD 在38天内
(197条评论)
6.0
wessamfshaaban

See private message.

$255 USD 在38天内
(10条评论)
4.9
octobersoftvw

See private message.

$255 USD 在38天内
(63条评论)
5.0
gorazz

See private message.

$212.5 USD 在38天内
(49条评论)
5.0
czetxinc

See private message.

$170 USD 在38天内
(8条评论)
4.8
sidmand

See private message.

$233.75 USD 在38天内
(12条评论)
4.4
netmanivw

See private message.

$212.5 USD 在38天内
(13条评论)
4.2
CodeFine

See private message.

$212.5 USD 在38天内
(34条评论)
4.0
vw1744148vw

See private message.

$255 USD 在38天内
(15条评论)
4.1
techcom

See private message.

$255 USD 在38天内
(10条评论)
3.4
jeffetc

See private message.

$212.5 USD 在38天内
(7条评论)
3.3
invinciblesoft

See private message.

$85 USD 在38天内
(11条评论)
4.1