doPersistence is a C# dll that persists any object to any database. Will save directly to tables with dynamic Sql or it will map to stored procedures (store, load, delete, list).

For single objects add a class attribute:
[Persistable("Customer", "CustomerId", true)]
public class Customer { ...

For list objects, inherit from a generic list:
public class CustomerList : PersistentList<Customer>

Bulk storage is extremely fast with data pagination available on loads. ~10,000 objects/second. ~2,000 objects/second if loaded one row at a time.

See website for example code. Or download zip file for working copy.

Features

  • Persists any object to the database
  • All data types supported
  • SqlServer plugin is complete (Oracle, Access, MySql to do)
  • If using dynamic Sql, properties/columns must be the same name
  • If using stored procedures, column name and data types can be different
  • Generic List provides interface to result sets with data pagination and bulk copy

Project Activity

See All Activity >

Follow doPersistence

doPersistence Web Site

Other Useful Business Software
Build Securely on AWS with Proven Frameworks Icon
Build Securely on AWS with Proven Frameworks

Lay a foundation for success with Tested Reference Architectures developed by Fortinet’s experts. Learn more in this white paper.

Moving to the cloud brings new challenges. How can you manage a larger attack surface while ensuring great network performance? Turn to Fortinet’s Tested Reference Architectures, blueprints for designing and securing cloud environments built by cybersecurity experts. Learn more and explore use cases in this white paper.
Download Now
Rate This Project
Login To Rate This Project

User Reviews

Be the first to post a review of doPersistence!

Additional Project Details

Operating Systems

Windows

Intended Audience

Advanced End Users, Architects, Developers, Security Professionals

Programming Language

C#

Database Environment

ADO.NET, Project is a database abstraction layer (API), Project is a relational object mapper, SQL-based

Related Categories

C# Front-Ends, C# Frameworks, C# Object-Relational Mapping (ORM) Software

Registered

2012-05-10