DotNetBrightener.WebApi.GenericCRUD 2024.0.14.6-preview-1911302

This is a prerelease version of DotNetBrightener.WebApi.GenericCRUD.
There is a newer version of this package available.
See the version list below for details.
dotnet add package DotNetBrightener.WebApi.GenericCRUD --version 2024.0.14.6-preview-1911302
                    
NuGet\Install-Package DotNetBrightener.WebApi.GenericCRUD -Version 2024.0.14.6-preview-1911302
                    
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="DotNetBrightener.WebApi.GenericCRUD" Version="2024.0.14.6-preview-1911302" />
                    
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="DotNetBrightener.WebApi.GenericCRUD" Version="2024.0.14.6-preview-1911302" />
                    
Directory.Packages.props
<PackageReference Include="DotNetBrightener.WebApi.GenericCRUD" />
                    
Project file
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.
paket add DotNetBrightener.WebApi.GenericCRUD --version 2024.0.14.6-preview-1911302
                    
#r "nuget: DotNetBrightener.WebApi.GenericCRUD, 2024.0.14.6-preview-1911302"
                    
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
#:package DotNetBrightener.WebApi.GenericCRUD@2024.0.14.6-preview-1911302
                    
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package.
#addin nuget:?package=DotNetBrightener.WebApi.GenericCRUD&version=2024.0.14.6-preview-1911302&prerelease
                    
Install as a Cake Addin
#tool nuget:?package=DotNetBrightener.WebApi.GenericCRUD&version=2024.0.14.6-preview-1911302&prerelease
                    
Install as a Cake Tool

Centralized CRUD WebAPI in ASP.NET Core Applications

© 2024 DotNet Brightener. admin@dotnetbrightener.com

Instruction

Most applications rely on CRUD operations. This library provides core CRUD functionalities, exposing them as WebAPI controllers, utilizing DotNetBrightener.DataAccess.Abstractions library, which facilitates the database access layer performing the CRUD operations.

Implement in your project

Let's say in your project, you have the following class defined:

public class ProductDocument : BaseEntityWithAuditInfo
{
    [MaxLength(255)]
    public string FileName { get; set; }
 
    [MaxLength(1024)]
    public string Description { get; set; }
 
    [MaxLength(2048)]
    public string FileUrl { get; set; }
 
    public Guid? FileGuid { get; set; }
 
    public int? DisplayOrder { get; set; }
 
    [DataType(DataType.Currency)]
    public decimal? Price { get; set; }
}

You will need to create a DataService interface and implementation class like the following:

public partial interface IProductDocumentDataService : IBaseDataService<ProductDocument> { }
 
public partial class ProductDocumentDataService : BaseDataService<ProductDocument>, IProductDocumentDataService {
    
    public ProductDocumentDataService(IRepository repository)
        : base(repository)
    {
    }
}

The IBaseDataService<> interface and BaseDataService<> base class are defined in DotNetBrightener.DataAccess.Abstractions library. They provided CRUD operation already so you will not need to write CRUD operation yourself. The implementation is highly customizable, so you can change the logic based on your application's need.

You can then create a controller as followed:


[ApiController]
[Route("api/[controller]")]
public partial class ProductDocumentController : BaseCRUDController<ProductDocument>
{
    public ProductDocumentController(
            IProductDocumentDataService dataService,
            IHttpContextAccessor httpContextAccessor)
        : base(dataService, httpContextAccessor)
    {
    }
}

In Startup.cs or Program.cs, register your DataService interface and implementation class to the ServiceCollection as followed:

builder.Services.AddScoped<IProductDocumentDataService, ProductDocumentDataService>();

If you use CORS, you will need to add the following to the ConfigureServices method in Startup.cs:


    services.AddCors(options =>
    {
        options.AddPolicy("CorsPolicy",
                            builder =>
                            {
                                // other configurations for your CORS policy builder

                                // builder.AllowAnyMethod()
                                //        .AllowAnyHeader();

                                  
                                // This is required for the headers that returned from the paged list API to be exposed to the consumers
                                builder.AddPagedDataSetExposedHeaders();
                            });
    });

Now your API is available. Check out the next section for the available APIs and what to expect.

Available CRUD APIs

The following API for CRUD will be available when you implement the CRUD controllers.

GET /api/[entity]

  • Retrieve list of records of the entity type, and satisfies the filter, if provided

This API accepts the following query string parameters:

Parameter Type Description
columns string[], separate by commas The columns / fields of the entity to retrieve
pageSize number The number of records to return in one page, default is 20
pageIndex number The index of the page to return, default is 0
orderBy string The column to sort the result by, in ascending order. If the value starts with a hyphen (-) and followed by the column name, the result is sorted in descending order. This parameter impacts how the data is returned.
{column_name} any The filter expressions to filter the result by the column_name. Eg: createdBy=user* will filter the result to return the records that have CreatedBy value starts with user. Or, summary=contains(value3)&createdDate=<=2023-12-01, will filter the records that have summary value contains value3 in the string, and createdDate is before 01 Dec 2023.<br/><br/>See the tables below for more detail.

column_name is case-sensitive. You will need to obtain the correct name of the column from the response body.

There is no OR operator supported at the moment, because the nature of HTTP query strings combined by & operator. Therefore, only AND operator can be supported.

You can use custom queries for the {column_name} parameter with different operators. Here's a table explaining how to use them:

The follow operators are supported in most of all data types, string, int, long, float, double

Operator Symbol Example Usage Description
Equals eq (default) id=eq(100) or id=100 Filters records where the id value matches the one on the right side of the query or in the parentheses.
Not Equals ne id=ne_100 <br /> id=ne(100)<br/> id=!(100) Filters the records where the id value doesn't not equal the value on the right operand or in the parentheses.
In in summary=in(valuea,valueb) Filters the records where the summary is in the values defined in the parentheses.
Not In notin<br /> !in summary=notin(valuea,valueb)<br />summary=!in(valuea,valueb) Filters the records where the summary IS NOT in the values defined in the parentheses.

The following operators are supported for string data type.

Operator Symbol Example Usage Description
Contains contains<br/>like<br/>*keyword* summary=contains(value)<br />summary=like(value)<br />summary=*value* Filters the records where the summary contains the value in the parentheses.
Not Contains notcontains<br/>notlike<br/>!contains<br />!like summary=!contains(value)<br />summary=!like(value) Filters the records where the summary DOES NOT contains the value in the parentheses.
Starts With startsWith<br />sw<br/>keyword* summary=startsWith(value)<br/>summary=sw(value)<br/>summary=value* Filters the records where the summary starts with the value in the parentheses or on the right side of the query.
Not Starts With !startsWith<br />!sw summary=!startsWith(value)<br/>summary=!sw(value) Filters the records where the summary DOES NOT start with the value in the parentheses.
Ends With endsWith<br/>ew<br/>*keyword summary=endsWith(value)<br />summary=ew(value)<br/>summary=*value Filters the records where the summary ends with the value in the parentheses or on the right side of the query.
Not Ends With !endsWith<br/>!ew summary=!endsWith(value)<br />summary=!ew(value) Filters the records where the summary DOES NOT end with the value in the parentheses.

The following operators are supported for int, float, double, decimal, datetime and datetimeoffset data type.

Operator Symbol Example Usage Description
Greater Than<br />After (for datetime types) > id=>(10)<br />displayIndex=>(200)<br />expirationDate=>(2023-12-01) -
Greater Than or Equals<br />On or After (for datetime type) >= id=>=(10)<br />displayIndex=>=(200)<br />expirationDate=>=(2023-12-01) -
Less Than<br />Before (for datetime types) < id=<(10)<br />displayIndex=<(200)<br />invoiceDate=<(2023-12-01) -
Less Than or Equals<br />Before or On (for datetime types) <= id=<=(10)<br />displayIndex=<=(200)<br />invoiceDate=<=(2023-12-01) -

The response of the API also has the headers as followed that help you identify the total items available, the result count, requested page size and requested page index. See the below table for details.

Header Description
X-Total-Count The total number of items available based on the filter defined in the request
X-Result-Count The number of items returned in the current page
X-Page-Size The requested page size
X-Page-Index The requested page index

GET /api/[entity]/[id]

  • Get the record of the entity type by id

This API accepts the following query string parameters

Parameter Type Description
columns string[], separate by commas The columns / fields of the entity to retrieve

POST /api/[entity]

  • Create a new record of the entity type

PUT /api/[entity]/{id}

  • Update entity by id

The body of the request can be part of the entity. Only the provided fields in the body will be updated to the entity specified by the id

DELETE /api/[entity]/{id}

  • Delete entity by id

PUT /api/[entity]/{id}/undelete

  • Restore the deleted record of the entity by id
Product Compatible and additional computed target framework versions.
.NET net8.0 is compatible.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed.  net9.0 was computed.  net9.0-android was computed.  net9.0-browser was computed.  net9.0-ios was computed.  net9.0-maccatalyst was computed.  net9.0-macos was computed.  net9.0-tvos was computed.  net9.0-windows was computed.  net10.0 was computed.  net10.0-android was computed.  net10.0-browser was computed.  net10.0-ios was computed.  net10.0-maccatalyst was computed.  net10.0-macos was computed.  net10.0-tvos was computed.  net10.0-windows was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (1)

Showing the top 1 NuGet packages that depend on DotNetBrightener.WebApi.GenericCRUD:

Package Downloads
DotNetBrightener.LocaleManagement

Package Description

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last Updated
2025.0.6-preview-406 0 9/2/2025
2025.0.6-preview-401 0 9/2/2025
2025.0.6-preview-400 0 9/2/2025
2025.0.6-preview-369 168 8/27/2025
2025.0.6-preview-368 168 8/27/2025
2025.0.6-preview-334 152 8/18/2025
2025.0.6-preview-333 73 7/27/2025
2025.0.6-preview-332 446 7/24/2025
2025.0.6-preview-331 444 7/24/2025
2025.0.6-preview-328 446 7/24/2025
2025.0.6-preview-327 283 7/21/2025
2025.0.6-preview-326 281 7/21/2025
2025.0.6-preview-325 191 7/20/2025
2025.0.6-preview-324 188 7/20/2025
2025.0.6-preview-322 192 7/20/2025
2025.0.6-preview-321 192 7/19/2025
2025.0.6-preview-320 189 7/19/2025
2025.0.6-preview-319 121 7/17/2025
2025.0.6-preview-317 117 7/17/2025
2025.0.6-preview-316 119 7/17/2025
2025.0.6-preview-315 114 7/17/2025
2025.0.6-preview-314 123 7/17/2025
2025.0.6-preview-313 138 7/17/2025
2025.0.6-preview-312 136 7/16/2025
2025.0.5 150 7/10/2025
2025.0.5-preview-307 74 7/5/2025
2025.0.4 80 7/5/2025
2025.0.4-preview-305 85 7/4/2025
2025.0.4-preview-304 140 7/1/2025
2025.0.4-preview-299 120 5/31/2025
2025.0.4-preview-298 97 5/30/2025
2025.0.4-preview-296 132 5/30/2025
2025.0.4-preview-295 147 5/29/2025
2025.0.4-preview-293 146 5/26/2025
2025.0.4-preview-292 151 5/26/2025
2025.0.3 140 2/10/2025
2025.0.3-preview-288 116 2/10/2025
2025.0.2 135 1/21/2025
2025.0.2-preview-278 92 1/21/2025
2025.0.2-preview-277 116 12/16/2024
2025.0.1-rc-243301701 341 11/25/2024
2024.0.14.6 136 11/25/2024
2024.0.14.6-rc-243031001 165 10/29/2024
2024.0.14.6-rc-243030701 109 10/29/2024
2024.0.14.6-rc-242840501 109 10/10/2024
2024.0.14.6-rc-242820305 106 10/8/2024
2024.0.14.6-rc-242771401 204 10/3/2024
2024.0.14.6-rc-242770501 100 10/3/2024
2024.0.14.6-rc-242770201 121 10/3/2024
2024.0.14.6-rc-242761801 105 10/2/2024
2024.0.14.6-rc-242761601 116 10/2/2024
2024.0.14.6-rc-242761501 104 10/2/2024
2024.0.14.6-rc-242761401 107 10/2/2024
2024.0.14.6-rc-242760701 119 10/2/2024
2024.0.14.6-rc-242751002 101 10/1/2024
2024.0.14.6-rc-242750901 109 10/1/2024
2024.0.14.6-rc-242750502 116 10/1/2024
2024.0.14.6-rc-242750201 102 10/1/2024
2024.0.14.6-rc-242741501 95 9/30/2024
2024.0.14.6-rc-242730701 116 9/29/2024
2024.0.14.6-preview-2730501 100 9/29/2024
2024.0.14.6-preview-2701501 113 9/26/2024
2024.0.14.6-preview-2620901 137 9/18/2024
2024.0.14.6-preview-2570701 100 9/13/2024
2024.0.14.6-preview-2510703 150 9/7/2024
2024.0.14.6-preview-2480501 120 9/4/2024
2024.0.14.6-preview-2430401 136 8/30/2024
2024.0.14.6-preview-242730701 94 9/29/2024
2024.0.14.6-preview-2421703 114 8/29/2024
2024.0.14.6-preview-2421701 103 8/29/2024
2024.0.14.6-preview-2420901 108 8/29/2024
2024.0.14.6-preview-2390101 125 8/26/2024
2024.0.14.6-preview-2381603 113 8/25/2024
2024.0.14.6-preview-2341601 134 8/21/2024
2024.0.14.6-preview-2321602 123 8/20/2024
2024.0.14.6-preview-2190801 159 8/6/2024
2024.0.14.6-preview-2041501 105 7/22/2024
2024.0.14.6-preview-1920603 169 7/10/2024
2024.0.14.6-preview-1920301 122 7/10/2024
2024.0.14.6-preview-1911302 131 7/9/2024
2024.0.14.6-preview-1901001 132 7/8/2024
2024.0.14.6-preview-1900901 115 7/8/2024
2024.0.14.6-preview-1900801 115 7/8/2024
2024.0.14.6-preview-1860304 120 7/4/2024
2024.0.14.5 188 7/1/2024
2024.0.14.5-preview-1811601 120 6/29/2024
2024.0.14.5-preview-1810501 144 6/29/2024
2024.0.14.5-preview-180132 108 6/28/2024
2024.0.14.5-preview-180131 120 6/28/2024
2024.0.14.5-preview-180121 102 6/28/2024
2024.0.14.4 151 6/27/2024
2024.0.14.4-preview-7 125 6/27/2024
2024.0.14.3 138 6/21/2024
2024.0.14.1 150 6/6/2024
2024.0.14.1-preview 102 6/6/2024
2024.0.13.8-preview 115 6/6/2024
2024.0.13.1-preview-0146 112 6/6/2024
2024.0.12.15803-preview-03 108 6/6/2024
2024.0.12.15608 149 6/4/2024
2024.0.12.15515 218 6/3/2024
2024.0.12.15220 138 5/31/2024
2024.0.12.15220-alpha31-240... 95 5/31/2024
2024.0.12.14911 201 5/28/2024
2024.0.12.14910-alpha28-240... 118 5/28/2024
2024.0.12.14823 155 5/27/2024
2024.0.12.14522-alpha7-2405... 122 5/24/2024
2024.0.12.14514-alpha6-2405... 124 5/24/2024
2024.0.12.14511 161 5/24/2024
2024.0.12.14314 163 5/22/2024
2024.0.12.14114 160 5/20/2024
2024.0.12.12815 188 5/7/2024
2024.0.12.12814 167 5/7/2024
2024.0.12.12721 173 5/6/2024
2024.0.12.12702 168 5/5/2024
2024.0.12.12622 176 5/5/2024
2024.0.12.12514 167 5/4/2024
2024.0.12.12512 152 5/4/2024
2024.0.12.12510 175 5/4/2024
2024.0.12.12420 148 5/3/2024
2024.0.12.12319 114 5/2/2024
2024.0.12.12319-rc-2405021801 83 5/2/2024
2024.0.12.12318 118 5/2/2024
2024.0.12.12215 149 5/1/2024
2024.0.12.12011 161 4/29/2024
2024.0.12.11720 171 4/26/2024
2024.0.12.11719 151 4/26/2024
2024.0.12.11621 167 4/25/2024
2024.0.12.11523 137 4/24/2024
2024.0.12.11522 133 4/24/2024
2024.0.12.11417 171 4/23/2024
2024.0.12.11400 144 4/22/2024
2024.0.12.11316 166 4/22/2024
2024.0.11.10220 137 4/11/2024
2024.0.11.10120 145 4/10/2024
2024.0.11.10119 133 4/10/2024
2024.0.11.10115 140 4/10/2024
2024.0.11.9914 183 4/8/2024
2024.0.11.9901 171 4/7/2024
2024.0.11.9823 154 4/7/2024
2024.0.11.9401 169 4/2/2024
2024.0.11.9301 168 4/1/2024
2024.0.11.9206 153 3/31/2024
2024.0.11.9205 160 3/31/2024
2024.0.11.8200 176 3/21/2024
2024.0.11.8122 142 3/21/2024
2024.0.11.8120 151 3/21/2024
2024.0.11.7320 198 3/13/2024
2024.0.11.7316 178 3/13/2024
2024.0.11.7310 153 3/13/2024
2024.0.11 147 3/13/2024
2024.0.10 192 3/3/2024
2024.0.9 158 2/27/2024
2024.0.8 215 2/1/2024
2024.0.7 156 1/26/2024
2024.0.6 154 1/25/2024
2024.0.5 150 1/24/2024
2024.0.4 142 1/24/2024
2024.0.3 156 1/22/2024
2024.0.2 219 1/10/2024
2024.0.1 193 1/9/2024
2024.0.1-alpha-3 133 1/9/2024
2024.0.1-alpha-2 142 1/9/2024
2024.0.1-alpha-1 149 1/3/2024
2024.0.0 225 12/26/2023
2023.0.27 183 12/21/2023
2023.0.26 149 12/21/2023
2023.0.25 182 12/11/2023
2023.0.24 162 12/8/2023
2023.0.23 147 12/6/2023
2023.0.21 167 12/4/2023
2023.0.20 202 11/27/2023
2023.0.19 149 11/20/2023
2023.0.18 187 10/25/2023
2023.0.17 233 10/22/2023
2023.0.16 191 10/16/2023
2023.0.16-alpha-1 123 10/16/2023
2023.0.15 186 10/14/2023
2023.0.14 159 10/14/2023
2023.0.13 171 10/14/2023
2023.0.12 167 10/14/2023
2023.0.11 164 10/10/2023
2023.0.10 180 10/9/2023
2023.0.9 202 8/16/2023
2023.0.8 187 8/15/2023
2023.0.8-alpha-2 256 5/31/2023
2023.0.7 201 5/12/2023
2023.0.6 349 5/10/2023
2023.0.5 199 5/7/2023
2023.0.4 223 4/22/2023
2023.0.3 265 4/19/2023
2023.0.2 267 4/6/2023
2023.0.1 270 3/13/2023
2022.11.0 393 11/21/2022
2022.10.2 393 11/9/2022
2022.10.1 407 10/28/2022