Ecosyste.ms: Packages
An open API service providing package, version and dependency metadata of many open source software ecosystems and registries.
nuget.org : ezcrud
Provides a simple CRUD functionality to your entity models. Example: var childUsers = new Users().SelectWhereOrderBy("Age <= 17"); How to implement: - Add EZCRUD reference to your model library. - Inherit Model_RecordBase for each model. - Set EZCRUD's connection string ("DBAccess.DBSettings.ConnectionString = <your connection string>" in your Startup.cs Now all of your models have CRUD functionality! Available methods: - <yourModel>.AddRecord(); // adds the current model instance as a new record in the database - <yourModel>.UpdateRecord(); // updates the database table with the matching ID - <yourModel>.DeleteRecord(); // deletes the database table with the matching ID - <yourModel>.SelectAll(); // returns all records, of the current model type, from the database. Equivalent to: SELECT * FROM <yourModelType> - <yourModel>.SelectWhereOrderBy(optional sWhere/sOrderBy); // returns an arbitrary set of records that matches the provided where phrase Equivalent to: SELECT * FROM <Table> WHERE <sWhere> ORDER BY <sOrderBy> - <yourModel>.LoadRecord(id); // loads the record from the database table with the matching id and populates the current model instance using the retreived data. - <yourModel>.LoadRecordWhere(sWhere); // loads the record from the database table that meets the where phrase criteria and populates the current model instance using the retreived data.
Registry
- JSON
purl: pkg:nuget/ezcrud
Keywords: dapper, database, sql, sqlserver, tsql, crud, entity, model, db, ezdb, ez, ezcrud, blazor, blazorsql
License: MIT
Latest release: almost 4 years ago
First release: almost 4 years ago
Downloads: 5,111 total
Last synced: about 1 month ago