dotnet tool install --global dotnet-outdated
dotnet tool update --global dotnet-outdated
dotnet tool install --global dotnet-outdated
dotnet tool update --global dotnet-outdated
git://github.com/[username]/[repositoryname].git
git@github.com:[username]/[repositoryname].git
origin/master
git clone https://github.com/jquery/jquery.git
git clone [URL][directory name]
git remote add [alias][URL]
git remote add origin https://github.com/jquery/jquery.git
git remote
git remote [alias] -rm
git branch -r
git branch -a
git fetch [alias][alias/branch name]
pull [alias][remote branch name ]
git branch --set-upstream [local brnach][alias/branch name]
git push -u [alias][branch name ]
git tag [tag name]
git tag
USE master
EXEC sp_addlinkedserver
'SQL2',
N'SQL Server'
sp_addlinkedsrvlogin @useself='false ', @rmtsrvname = 'SQL2',
@rmtuser = 'sa',
@rmtpassword = 'pass#'
select * from sql2.faxManager.dbo.tblErja
begin distributed tran
select * from sql2.faxManager.dbo.tblErja
commit tran
SET XACT_ABORT ON
System.InvalidOperationException: The configured execution strategy ‘SqlServerRetryingExecutionStrategy’ does not support user initiated transactions. Use the execution strategy returned by ‘DbContext.Database.CreateExecutionStrategy()’ to execute all the operations in the transaction as a retriable unit.
public async Task<IActionResult> UpdateProduct([FromBody]CatalogItem productToUpdate) { var strategy = _catalogContext.Database.CreateExecutionStrategy(); await strategy.ExecuteAsync(async () => { using (var transaction = _catalogContext.Database.BeginTransaction()) { _catalogContext.CatalogItems.Update(productToUpdate); await _catalogContext.SaveChangesAsync(); transaction.Commit(); } }); }
public class ResilientTransaction { private readonly DbContext _context; private ResilientTransaction(DbContext context) => _context = context ?? throw new ArgumentNullException(nameof(context)); public static ResilientTransaction New(DbContext context) => new(context); public async Task ExecuteAsync(Func<Task> action) { var strategy = _context.Database.CreateExecutionStrategy(); await strategy.ExecuteAsync(async () => { await using var transaction = await _context.Database.BeginTransactionAsync(); await action(); await transaction.CommitAsync(); }); } } // How to use it await ResilientTransaction.New(_dbContext).ExecuteAsync(async () => { // ... await _dbContext.SaveChangesAsync(); });
There are two MySQL providers for Entity Framework Core:
- The official one from MySQL: MySql.Data.EntityFrameworkCore. As of now, the latest version is 8.0.19, and works with Entity Framework Core 2.1 (and probably also 2.2). Since EF Core 3.0 is a major version with breaking changes, you cannot use it with this provider.
- The Pomelo provider: Pomelo.EntityFrameworkCore.MySql. There is a 3.1 version of this provider.
In other words, if you want to use EF Core 3.0/3.1 with MySQL, at this point you need to use the Pomelo provider (or wait for the official MySQL one to get released).
In this section, I’m going to cover how you can use SignalR outside of a Hub. In most asp.net core applications, you will likely want to communicate with the connect clients from within your application but outside of a Hub. You can accomplish this by using the HubContext.
For example, an ASP.NET Core MVC Controller or any other class that is instantiated by ASP.NET Core’s Dependency Injection.
The HubContext allows you to send messages to your connected clients. It has many of the same features to communicate with clients as when you are inside of a Hub.
If you are used to manipulate HTML forms, you probably know that each checkbox is a separate variable (or maybe an ngModel with AngularJS). Demo
Sometimes, it could be usefull to manipulate all these checkboxes as a unique array.
angular.checkboxes
module lets you turn your list of checkboxes into a unique destination array, providing :
SQL Server 2014 DML Triggers are often a point of contention between Developers and DBAs, between those who customize a database application and those who provides it. They are often the first database objects investigated when the performance degrades. They seem easy to write, but writing efficient Trigger, though complex have a very important characteristic: they allow solving problems that cannot be managed in any other application layer. Therefore, if you cannot work without them, in this article you will learn tricks and best practices for writing and managing them efficiently.
....
Becoming a software architect isn't something that simply happens overnight or with a promotion. It's a role , not a rank . It's an evolutionary process where you'll gradually gain the experience and confidence that you need to undertake the role.
Right click on the folder -> Properties -> Security tab -> Click at Edit button -> Enter `IIS AppPool\DefaultAppPool` user (IIS AppPool\<app_pool_name>) -> Click at Check names -> OK -> Then give it `write` or other permissions.