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

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";