mirmostafa

"Watch": {
      "commandName": "Executable",
      "executablePath": "dotnet.exe",
      "workingDirectory": "$(ProjectDir)",
      "commandLineArgs": "watch run",
      "launchBrowser": true,
      "launchUrl": "https://localhost:5001;http://localhost:5000",
      "environmentVariables": {
        "ASPNETCORE_ENVIRONMENT": "Development",
        "ASPNETCORE_HOSTINGSTARTUPASSEMBLIES": "Microsoft.AspNetCore.Mvc.Razor.RuntimeCompilation"

mirmostafa

<Project Sdk="Microsoft.NET.Sdk">

	<PropertyGroup>
		<OutputType>Exe</OutputType>
		<TargetFramework>net6.0</TargetFramework>
		<Nullable>enable</Nullable>
		<LangVersion>preview</LangVersion>
	</PropertyGroup>

	<ItemGroup>

mirmostafa

public void ConfigureServices(IServiceCollection services)
       {
          
          //....

           services.AddDbContextPool<S2ReadDbContext>(options =>
           {
               options.UseQueryTrackingBehavior(QueryTrackingBehavior.NoTracking);
               options.UseSqlServer(Configuration.GetConnectionString("S2ReadConnection"));
               options.EnableSensitiveDataLogging();

mirmostafa

        public virtual ValueTask DisposeAsync()
        {
            try
            {
                Dispose();
                return default;
            }
            catch (Exception exc)
            {
                return new ValueTask(Task.FromException(exc));

mirmostafa

class Person {
    public Person (string first, string last) => (this.First, this.Last) = (first, last);
}

public static class Extensions {
    public static void Deconstruct(this Person p, out string first, out string last) => (first, last) = (p.First, p.Last);
}

mirmostafa

var options = new DbContextOptionsBuilder<MyDbContext>
					.UseInMemoryDatabase(Guid.NewGuid().ToString())
					.Options;
var context = new MyDbContext(options);
context.Database.EnsureCreated();

mirmostafa

            var dbResult = await this._readDbContext.ProductCategories.FromSqlInterpolated($@"
    SELECT TOP 1 *
    FROM [biz].[ProductCategories] t
    WHERE NOT EXISTS (SELECT 1
                       FROM [biz].[ProductCategories]
                       WHERE ParentProductCategoryId = t.ProductCategoryId)
    AND t.ProductCategoryId = {parameters.CategoryId} AND MerchantId = {merchantId}")
                            .AsNoTracking().FirstOrDefaultAsync();

mirmostafa

        public static IWebHostBuilder CreateWebHostBuilder(string[] args) =>
                WebHost.CreateDefaultBuilder(args)
                        .ConfigureLogging(logging =>
                         {
                             logging.ClearProviders();
                             logging.AddDebug().AddConsole();
                             logging.AddFilter("", LogLevel.Information)
                                    .AddFilter("Microsoft.AspNetCore.Routing.EndpointMiddleware", LogLevel.Warning)
                                    .AddFilter("Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker", LogLevel.Warning)
                                    .AddFilter("Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor", LogLevel.Warning);

mirmostafa

	<PropertyGroup>
		<Nullable>enable</Nullable>
		<TargetFramework>net6.0</TargetFramework>
		<LangVersion>Preview</LangVersion>
		<EnablePreviewFeatures>true</EnablePreviewFeatures>
	</PropertyGroup>

mirmostafa

dotnet tool install --global dotnet-ef