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
Follow doPersistence
Other Useful Business Software
Build Securely on AWS with Proven Frameworks
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.
Rate This Project
Login To Rate This Project
User Reviews
Be the first to post a review of doPersistence!