/evolutility-asp.net

Lightweight CRUD framework for heavy lifting using ASP.net and MS-SQL Server.

Primary LanguageC#GNU Affero General Public License v3.0AGPL-3.0

This repository is not maintained anymore.

Evolutility-ASP.net

Evolutility is a generic web user interface for CRUD (Create, Read, Update, Delete) applications running on ASP.net, and SQL Server or MySQL.

It is entirely metadata driven, and can adapt to different database structures. It may behave like an address book, a task list, a photo album, or anything you may want to build. It is ideal to quickly build functional components for database web applications or web site administration pages.

With Evolutility the user interface (e.g. fields titles, positions, visual groups, CSS classes) and its database mapping (e.g. tables, columns, stored procedures) are not defined in the code but in external metadata (stored as XML files or in the database). Evolutility web control can be nested into any ASP.net page. It will generate at run-time all necessary web forms, manage user interaction, and database CRUD (create, read, update, delete) operations automatically.

Demos: To Do list, AddressBook, Wine Cellar, Restaurants list.

Documentation

Hosted at SourceForge since 2008.

Pages generated at run-time

View

Displays all fields for viewing, 1 record at a time.

view

Edit

Displays all fields for editing, 1 record at a time.

view

List

Displays the most important fields for multiple rows of records.

view

Charts

Draws a few charts of the data.

view

Search

Query by example form for searching records.

view

Advanced Search

Form for advanced queries such as "phone number start by 415" or "for categories Finances and Business"...

view

Export

Export of selections in standard formats (Excel, HTML, CSV, XML, or SQL), one or several records at the same time.

view

Mass Update

Update for multiple records at once.

view

Selections

List of canned queries.

view

Installation

To run the Evolutility sample applications:

  • Copy the directory "Evolutility__Web" (which contains the web site) to your web server.
  • Attach the database (located in the "Evolutility__Web/App_Data" directory of the web site). You may also create a new database and run the SQL scripts (located in "Resources/SQL/").
  • If necessary, change the database connection string in the "appSettings" section of the Web.config file (or in specific ASPX page).

Default login/password:

  • For the multi-users demos, use John/John or Mary/Mary as your login/password.
  • For EvoDico, use EVOL/LOVE as your login/password.

More about installing Evolutility.

Other implementations of Evolutility

Evolutility-UI-React - Model-driven Web UI for CRUD using React.

Evolutility-UI-jQuery - Model-driven Web UI for CRUD using jQuery and Backbone (for REST or localStorage).

Evolutility-Server-Node - RESTful Micro-ORM for CRUD and more, written in Javascript, using Node.js, Express, and Postgres.

License

Evolutility-ASP.net is released under the AGPLv3 license.

Copyright (c) 2020 Olivier Giulieri.