Software/Database Programming and Integration in C#/[url removed, login to view]
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.
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 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.
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
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.
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.
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
member variables have m_ prefix
PascalNotation for class names
camelNotation for variable names
MyClass myObject = new MyClass();
myObject.m_strMemberString = "assigning to member string";
36 freelancers are bidding on average $542 for this job
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