Building a .Net Data Access Layer

A Dot Net access layer can be built in many ways. Developers have many choices to develop a dot net data access layer that come within the Microsoft Visual Studio. Orasis Software introduces a visual dot net access layer builder that uses 100% pure Microsoft technologies, integrates seamlessly with Visual Studio and focuses only the on database access tier development. The only fully fledged round trip visual toolset that focuses on the creation of a dot Net access layer, the maintenance and benchmarking as well as the tuning aspect of it. In addition it allows automated unit testing of every method that it creates with full display of the object graphs that are used and/or returned. It is the only tool that allows deep object graph mapping to multiple levels, as long as all nested classes provide a default constructor. A realistic and architecturally sound dot net access layer uses data model objects that are defined based on the business requirements and not the actual database tables. Orasis with the ability to open your DLLs within the IDE and select object graphs that you want to associate with your queries allows true and pure mapping from relational data to object models. In many cases developers want to simply have a data model that satisfies the results of a query but not a table. In this case is a custom object does not exist in your libraries, Orasis Mapping Studio creates it for you and adds to a different Object Models DLL.
See your entire custom and managed data domain in one place. Orasis is the only development environment that allows you to see all of your database access mappings in your dot net access layer as well all of the data types that are used in all mappings. Now you can review a universe of dot Net data types, some external (coming from your libraries) and some created by Orasis (managed) with every mapping using one. Every time you create a new data access mapping, you can select an existing data access type or have Orasis create one for you or even better bring in one from your own DLLs. Use a state of the art Query designer to build your parameterized queries. Orasis allows you to graphically build parameterized queries that you can use to map your data access classes. The designer also allows developers to simply benchmark their queries and see the performance before even proceeding with the Mapping Wizard. At any time a database administrator can help you optimize your query and make it faster. Benchmark your SQL and your data access code in one place. Do not spawn query object language constructs that map a table to a class all over your code with slow SQL, reflected value sets and unknown timing results. Use a tool that builds straight open and free of any dependence ADO.Net code and manage all of its aspects in one place.	Use the Build in Unit tester and see the time results before you decide to use it or further optimize it. The ability to select every class in your dot net access layer and execute any method with a click of the button comes with a huge value that makes this tool a must have for every developer that writes database access code. First of all, who wants to hand write ADO.Net, we are sure that you as a developer you have better things to do. In addition who wants to keep testing code in synch, or even write it? Orasis Mapping Studio makes this history. Simply click select, input values and execute.