Generated SQL Scripts/Linq-to-Entities Queries

SQL Code


Listed below are quick descriptions of the SQL Stored Procedure, or Ad-Hoc DQL, or Linq-to-Entities queries AspCoreGen 2.0 MVC generates. When you choose to generate stored procedures, these scripts are directly generated in the database. Otherwise, when you choose dynamic linq-to-entities or Ad-Hoc SQL, SQL scripts dynamically built by the generated linq-to-entities are generated in class files added to the web application.

One of each of the following objects listed below may be generated per table in your database.

Generated Script/Linq-To-Entities Query
(Sample Code below are Stored Procedures)
Quick Description
1. Select All

  - Sample Code

Retrieves all records from a table.
2. Select All By a Foreign Key

  - Sample Code

Retrieves all records from a table filtered by a foreign key. Generated for each foreign key in the table.
3. Select All Dynamic Where

  - Sample Code

Retrieves all records from a table filtered by one or more fields. Used for search.
4. Select a Record by Primary Key

  - Sample Code

Retrieves a record from a table filtered by the primary key.
5. Select Drop Down List Data

  - Sample Code

Retrieves the primary key and another field. Used for DropDownList web controls.
6. Select, Skip, and Take

  - Sample Code

Retrieves a specified amount of records. Fetches records from a specific pointer, while skipping some records.
7. Select, Skip, and Take By a Foreign Key

  - Sample Code

Retrieves a specified amount of records from a table filtered by a foreign key. Fetches records from a specific pointer, while skipping some records. Generated for each foreign key in the table.
8. Select, Skip, and Take Dynamic Where

  - Sample Code

Retrieves a specified amount of records from a table filtered by one or more fields. Fetches records from a specific pointer, while skipping some records. Used for search.
9. Select Totals

  - Sample Code

Retrieves aggregate sum of fields with money data type. Only generated for tables with money data type field.
10. Insert

  - Sample Code

Inserts one new record in table.
11. Update

  - Sample Code

Updates an existing record by primary key.
12. Delete

  - Sample Code

Deletes an existing record by primary key.
13. Get Record Count

  - Sample Code

Gets the number of records from a table.
14. Get Record Count by Foreign Key

  - Sample Code

Gets the number of records from a table filtered by a foreign key. Generated for each foreign key in the table.
15. Get Record Count Dynamic Where

  - Sample Code

Gets the number of records from a table filtered by one or more fields. Used for search.
* Please see notes.