
Image from Pexels
Tagged articles - ASP.NET Core
Found 52 articles tagged with ASP.NET Core
17
Jan
2021
Mocking view mapped DbSets with XUnit in EF Core
.NET218 titlesWriting unit tests for view bounded entities in EF Core
0
Using in-memory DbContext is a great way to mock your actual DbContext in unit tests. You basically initialize the instance of your DbContext and seed some random data before you assert the result of your repository method.
Now the problem occurs if you are mapping database view to an entity...read more
19
Dec
2020
Setting up SQL Server IDistributedCache with migration in ASP.NET Core
.NET218 titlesEmbedding SQL Server caching in a project with EFCore migration
0
Caching data using Microsoft SQL Server may not be the most popular way of caching data because of the performance comparing to caching data to Redis, but it is maybe the most convenient way to keep your state of the application outside the process itself. Beside, if you are already using SQL Server database, you can just move the caching infrastructure to a separate schema inside the same database and keep using it until requirements are met for cache storage of better performance (like Redis for example).
This makes infrastructure not so complex and less dependent, again until the requirements for something faster are met.
...read more
11
Dec
2020
Representing available string values for parameters as list in Swagger ASP.NET Core
.NET218 titlesValid values as list in Swagger UI in ASP.NET Core
0
Swagger is a great way do describe your RESTful API. In ASP.NET it is pretty easy to wire up your OpenAPI documentation with your service facade with Swashbuckle NuGet package.
In .NET 5, WebApi project template comes with already built in support for OpenAPI via Swashbuckle package and you can get it already setup in your pipeline and dependency injection with an easy tick in new WebApi project in Visual Studio.
...read more
24
Nov
2020
Running multiple queries at the same time in EF Core
.NET218 titlesOvercoming the limitation of EF Core query execution
0
Since the time of ADO in .NET one of the limitations was that one connection can execute single command at the time. Same limitation Entity Framework inherited and you can execute single command at the time per instance of your DbContext.
Typical dependency injection lifetime of DbContext is scoped, which means you can execute one command at the time as the DbContext is instantiated per HTTP request in ASP.NET Core application.
...read more
17
Nov
2020
Accessing multiple databases from the same DbContext in EF Core
.NET218 titles Multiple database access from the same DbContext in Entity Framework Core 5
0
It is not uncommon to have a requirement to access tables or views in different databases in the same query. In order to be able to do your joins on tables or views in different databases you need to do it in the same connection instance which is bound to DbContext, therefore this access as to be accomplished from the same DbContext instance.
Let try to see what is the obstacle of doing tis with EF Core in a sample project which will access two databases in order to execute query and return records from the database...read more
06
Sep
2020
Seeding data in EF Core using SQL scripts
.NET218 titlesAnother way of seeding data in EF Core
0
Not so while ago I wrote an article on Seeding data with Entity Framework Core using migrations. This approach relies on EF Core migrations to ensure seeding of specific data is done only once using __EFMigrationsHistory table to track structural migrations as well as data seeding migrations.
In large number of cases this approach works just fine and you do not need to do any adjustments or add any additional tables, just use migrations mechanism out of the box...read more
30
Jul
2020
Basic authentication with Swagger and ASP.NET Core
.NET218 titlesSetting up basic authentication in ASP.NET Core Web API projects
0
Basic authentication is not so popular authentication method nowadays. There is a valid reason for that and that is mainly the way credentials are used to authenticate to access the resources...read more
21
Jul
2020
Seeding data with Entity Framework Core using migrations
.NET218 titlesUsing EF Core migrations to seed the data
0
As much as it is important for testing the functionality of the application, data seeding can also be used to pre-load some values like lookups not only to development and test environment but also to populate these values in production as well.
Seeding of data can be done in several ways and in this article I will go through two ways of seeding data. Both of them have their pros and cons and it is up to you to pick the way you want to have your data pre-seeded in your application database.
...read more
21
Jun
2020
Dealing with default API versions in Swagger UI
.NET218 titlesFixing additional routes in Swagger API when using default versions
0
Having your REST API versioned is important for evolving of the service over time. Especially if your service is exposed t multiple 3rd party clients...read more
19
Apr
2020
Combining multiple Swagger API endpoints in a single UI
.NET218 titlesMultiple REST API microservices endpoints in a single Swagger UI
0
Shifting from traditional monolithic application architecture to micorservices can solve bunch of problems and issues monolith application application design approach introduces, but on the other hand it has it's own drawbacks, although number of drawbacks compared to number of problems it solves is a lot greater so it makes sense to take a path in process of moving from monolithic to micorservices.
On of the steps to move to micorservices is to physically have your services running as individual processes. This also means that in case of REST API type of applications you will have multiple instances and each of these instances will have it's own endpoints and documentation for them...read more
12
Mar
2020
Mocking HttpClient in unit tests with Moq and Xunit when using IHttpClientFactory
.NET218 titlesUnit testing IHttpClientFactory by mocking HttpClient in .NET Core C#
0
.NET Core has done a great job by introducing interface for most of classes which makes them easy to write unit tests around them. However, there are a lot of classes that re commonly used which are not refactored in .NET Core...read more
02
Mar
2020
Overwriting configuration values with environment variable in ASP.NET Core
.NET218 titlesUsing environment specific variables to overwrite configuration values in ASP.NET Core
0
It is obvious that no matter what is the size and complexity of your application, configuration values on your local development machine and the environment where the application is going to run will be different. To avoid any hard-coding and recompilation of your code, the most common practice is to store application and environment specific values to configuration files.
Although ASP.NET Core provides great out of the box solution for having multiple configuration files depending on the environment (Use multiple environments in ASP.NET Core), there are still things that should not reside in the configuration files.
...read more
01
Mar
2020
Custom SignalR hub authorization in ASP.NET Core
.NET218 titlesASP.NET Core SignalR hub authorization
0
SignalR is number one choice for real-time communication between server and client. It implements several transports for communication between server and client...read more
09
Jan
2020
Mocking System.IO filesystem in unit tests in ASP.NET Core
.NET218 titlesTestable filesystem operations in ASP.NET Core and C#
0
Working with file system operations like creating or deleting files and directories if quite often part of applications flow. Both .NET and .NET Core come with great out of the box classes and methods to achieve this.
These classes and methods are part of System.IO name space, but unfortunately both .NET and .NET Core implementations are the same and they use static classes and method to manipulate files and directories on the host file system.
...read more
15
Oct
2019
Increase service resilience using Polly and retry pattern in ASP.NET Core
.NET218 titlesRetry pattern in ASP.NET Core with Polly
0
Whether you are doing micro-services or mid-size monolith applications that do not have to be too distributed, there is a big chance that you will depend on some external HTTP service. Whether it is REST, SOAP or any other type of the response, your application flow depends on it's response.
Sure using queues and event-based communication between services or components will definitely increase the resilience of the application and make more error-proof, it adds additional complexity to the whole solution and sometimes that can be an overhead depending on the application type or the infrastructure you might be limited with.
...read more
.NET
17
Jan
2021
Mocking view mapped DbSets with XUnit in EF Core
Writing unit tests for view bounded entities in EF Core
19
Dec
2020
Setting up SQL Server IDistributedCache with migration in ASP.NET Core
Embedding SQL Server caching in a project with EFCore migration
11
Dec
2020
Representing available string values for parameters as list in Swagger ASP.NET Core
Valid values as list in Swagger UI in ASP.NET Core
24
Nov
2020
Running multiple queries at the same time in EF Core
Overcoming the limitation of EF Core query execution
17
Nov
2020
Accessing multiple databases from the same DbContext in EF Core
Multiple database access from the same DbContext in Entity Framework Core 5
11
Sep
2020
Building and using advanced .NET Core CLI global tools
Handling commands, arguments and options in .NET CLI global tool application
JavaScript
28
Oct
2018
HTML5 localStorage with expiry with vanilla JavaScript
Using HTML5 localStorage with expiry
8
May
2018
Monitoring DOM changes with JavaScript
Handling DOM changes with plain JavaScript
9
May
2017
Non blocking CSS load on the page
Load external CSS files in an async manner
16
Mar
2017
Serialize html form to JSON without using JQuery
Transform user input from HTML form fields to JSON
17
Jan
2016
Copy text value to clipboard using jQuery
Simple sample of using jQuery to copy value to clipboard
11
Jan
2016
Resize image on the client side with JQuery
Reducing the upload sie by resizing image on the client side
SQL/T-SQL
23
May
2020
Identifying opened connections for the specific application in SQL Server
Connection listing queries in SQL Server
3
May
2018
Reading JSON data in T-SQL on SQL Server
Extracting values from JSON string on SQL Server using T-SQL
28
Apr
2016
Create XML/HTML with T-SQL
Generating XML/HTML output in SQL Server
24
Nov
2015
IP address to octets split in TSQL
Split IP addresse into octets in SQL Server
20
Jul
2015
Getting first and last second of the current year, month and day
Using minimum and maximum date time in SQL query
13
Apr
2015
Dealing with duplicate rows in SQL Server
Finding and cleaning up duplicate rows in SQL Server tables
Umbraco CMS
2
Mar
2018
Minify HTML output of your pages
Minification of HTML output using ASP.NET IHttpModule
18
Apr
2015
Generate sitemap.xml on the fly in Umbraco CMS
Simple sitemap.xml Umbraco handler
2
Mar
2015
Accessing UmbracoHelper in HttpHandler request
Working with UmbracoHelper and IPublishedContent in HttpHandler
14
Sep
2014
Same page language switching in Umbraco
Land on the same page in different language in Umbraco using Relations
4
Sep
2014
Getting cropped image the smart way
The way to get cropped image URL with option to load original image too
27
Aug
2014
Fastest way to return JSON result from a controller
Resturn JSON in MVC controller action