DbPipeline.NET

DbPipeline.NET

APP DESCRIPTION:

Download this app named DbPipeline.NET.

The DbPipeline.NET OR-Mapper library was created out of frustration of the shortcomings of Entity Framework in handling stateless web applications and hiding of SQL from skilled developers.
The DbPipeline.NET Database Interface Library shields you, the programmer, from having to learn and work with all the ADO.NET or Entity Framework database objects at a low level, and encapsulates all this power into objects with many additional capabilities and features that are not offered in the standard ADO.NET or Entity Framework.

Our goal when designing the DbPipeline.NET™ Library was to create an easy to use database access layer set of classes using 100% managed code so that VB.NET and C#.NET programmers can use it to build database applications (Client/Server, Web, and 3-tier) without having to be consumed with the programming involved with the retrieval, handling, management and storage in memory of the data while it is being worked on, and updating of the data.

Features

• Can work directly with SQL Server or any OLE-DB database driver (Oracle, DB2, etc.).
• Classes provided are intuitive and easy to understand how to use.
• Gracefully handles stateless disconnected ASP.NET web applications by letting developer manage changes across multiple post-backs. Just make your changes to the DbPipeline objects during each postback, and when you're ready to save all the changes, simply provide a live connection to the database to the DbPipline object and execute the Update method.
• Fully support the use of the DbPipeline.NET Library for VB.NET as well as C#.NET programmers.
• TRUST and EMPOWER the programmer. Provide programmers with the power and capabilities of the library, but do not limit or block them from directly sending some SQL to the database, if they deem it necessary. In other words, extend their SQL Knowledge, do not try to replace it!
• Dramatically decrease the amount of coding and time required to create typical database interactive applications.
• Provide a uniform, fast, convenient interface for working with databases, regardless of whether you are developing a WinForms Desktop application, ASP.NET website, Windows Service Application, or a Windows Presentation Foundation (WPF) application.
• Provide functionality that saves the programmer from having to work at such a low level with the ADO.NET Framework classes, such as SqlConnection, SqlDataAdapter, SqlDataReader, SqlTransaction, SqlCommand, SqlParameter, and all the equivalent classes for the OLE-DB interface.
• Provide a programming platform that minimizes the dependence of any particular back-end database, where none of the interaction with the ADO.NET classes above will need to be coded by the programmer, making it much easier to scale an application from one database platform to another (from SQL Server to Oracle, for example).
• Design optimized for performance using 100% C# managed code. Keeping the performance optimized was a key value preserved throughout the design of this library. Managing the row buffer data as a collection of CLR objects keeps the memory footprint to a minimum and allows blazingly fast access.
• Strongly typed interface to table columns, fully taking advantage of IntelliSense in Visual Studio for auto-syntax completion (eliminates errors typing column names).
• Code Generator included for automatically generating the entity classes (in VB.NET or C#.NET) needed for the strongly typed interface to the DataPipeline buffer classes.
• Library is run-time royalty free and full source code is available with absolutely no fees for distributing applications that use the DbPipeline.NET library.
• Expose database records read from the database as bindable, sortable, observable collection of CLR objects. These collections (lists) can be directly bound to data grids and directly support grid editing and sorting of records without any additional custom programming.
• Handle NULL values automatically by using Nullable CLR data types.
• Facility for building Parameterized SQL for best practices (prevents SQL Injection attacks and performs much faster than dynamic SQL because the query signatures are cached by SQL Server).
• You can use any custom SQL statement needed to populate data into a DataPipeline buffer objects, allowing for complex JOIN or SUBQUERY statements needed for generating reports, record list windows.
• The DataPipeline object is Serializable, so the object, including all of its data, can be stored in a Session variable for an ASP.NET web application as the user works with the data records.
• Logical units of work (transactions) fully supported via BeginTransaction, CommitTransaction, and RollbackTransaction methods.
• Ability to run Stored Procedures that don't return results, retrieve data from Stored Procedures that do return results, and even retrieve OUTPUT parmater values returned by Stored Procedures.
• Ability to run any SQL statement that does not return a result set by using the RunSQLStatement method of the DbConnection class.
• Ability to run any SQL statement that returns a single row, single column result of any data type desired, and retrieve the result.
• Ability to read and write documents (files of any type) to SQL Server image columns.
• Results in up to 75% reduction in coding required for typical database I/O operations

Audience

Developers, Architects

Programming Language

C#, Visual Basic .NET, ASP.NET

Database Environment

SQL-based, ADO.NET

Free download Web app or web tool DbPipeline.NET from RedcoolMedia.net