ADO.NET/SQL Server pattern library

Softison ([login to view URL]) is currently developing a tool for automatic code generation, named Panda ([login to view URL]). This tool, completely implemented in C#, will be available as a stand-alone IDE and as a Visual Studio .NET add-in. Such a tool is made up of a generic code generation engine and a suite of specific pattern libraries (about, for instance, [login to view URL], Windows user interface, ASP.NET pages, Design by Contract, Aspect-Oriented Programming, etc.). Some pattern libraries are already available in the sample solutions included in the Panda IDE installation ([login to view URL]), as well as a white paper about the underlying technology. One of these pattern libraries (see \Samples\Soccer\[login to view URL] and \Samples\Soccer\[login to view URL]) is able to generate a data access layer (both [login to view URL] code and SQL Server 2005 stored procedures), but it requires some extensions. ## Deliverables The extensions required by the above-mentioned library follow (the associated issue id used in the Panda Web site is stated in square brackets): 1) A hierarchy of C# classes for adding filters to SQL queries (involving both [login to view URL] code and stored procedures) [844]. 2) A C# class for adding sorting parameters to SQL queries (involving both [login to view URL] code and stored procedures) [861]. 3) An extension to the currently generated scripts which create a SQL Server database, by including constraints for referential integrity [706]. 4) Minor enhancements [710, 850, 855, 680, 708]. As a consequence, the skills required for this work are [login to view URL], SQL Server 2005 and C#. Moreover, the generated [login to view URL] code and SQL Server 2005 stored procedures have to follow database best-practices, with regard to coding style, design quality and performance. Such a pattern library is generated by a Panda IDE solution. The programming language is Panda (a proprietary but simple language), which, in turn, makes use of C# for implementing code generation algorithms. The coding conventions to be followed can be deduced by the sample solutions included in the Panda IDE installation. The starting version of the Panda IDE solution will be provided to the chosen coder. The deliverable of this work is the final version of this solution, which must include one or more unit testing projects that prove that all implemented patterns behave correctly. Due to the characteristics of this work, full specifications cannot be provided. We expect that, as well implementing the pattern library, the chosen coder will be able to suggest design solutions; we are also available to extend the Panda IDE, the Panda language or the predefined patterns if it is useful for a better implementation of the pattern library. All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). If the Panda code generation tool will be successful, many other works on pattern libraries will ensue (including the evolution of this library). ## Platform Microsoft Windows XP or Vista. Microsoft .NET Framework 2.0. Microsoft SQL Server (the Express Edition is sufficient).