SqlClient VS FastEndpoints

I will be using Dapper - a simple object mapper for .Net along with Microsoft.Data.Sql.

See the link https://github.com/dotnet/SqlClient/issues/1656

Where I'm having trouble is with this android device connecting to the local sql database at that store. I initially tried connecting directly to the db but ran into this error SQL Server pre-login handshake failed Android 5,6,8.1 · Issue #1656 · dotnet/SqlClient (github.com) - which the only workaround seems to be a dodgy way of turning off security (the DangerousClassProvider class at the bottom of the page). This does actually work but doesn't seem the best way.

I was doing some simple internal tooling with EF. You know the deal, toss in a new row into a table to do something or other, simple CRUD stuff. I was making it in WASM just for the sake of trying out the framework. Turns out this is a thing: https://github.com/dotnet/SqlClient/issues/599 , which prevents EF from running. The wiki page being referenced is gone though, so I don't know the reason why it'd be incompatible. To me it doesn't make that much sense, since a console application would be functionally the same, just outside a browser.

Is any of the columns varchar(max) or similar type? There is a known issue in SqlClient package affecting async reading of such columns.

Code samples for Json.net which as of version 13.0.2 now supports DateOnly and TimeOnly. Three code samples are used to show interactions with Bogus and Microsoft.Data.SqlClient which is most likely used to work with json data.

If you're connecting to SQL Server, connection pooling can be a common cause of apparent memory leaks. If you're opening and closing hundreds of connections, the pool may not be disposing of the connections quickly enough. Or you might be running into issues like this one. You might want to look at SqlConnection.ClearAllPools or SqlConnection.ClearPool or simply disabling connection pooling entirely in the connection string.

Really frustrating to see the amount of effort that went in to gaming those benchmarks when catastrophic performance issues in core Microsoft-authored libraries go unfixed for years. https://github.com/dotnet/SqlClient/issues/593

Until you trip over this https://github.com/dotnet/SqlClient/issues/593

Bonus Time! In addition to the Microsoft-supported methods above, many community frameworks exist for building APIs with .NET. FastEndpoints is an option I found recently that seems very promising. With performance benchmarks that put them on par with Minimal API, they are firmly ahead of Controller-based APIs.

Have you had a look at FastEndpoints yet? Any thoughts?

And yet, all Microsoft's demos for the upcoming changes for Blazor in .NET 8 (like SSR) has been a public facing recipe site (e.g. https://www.youtube.com/watch?v=QD2-DwuOfKM). I'd say this is a very similar use case as the Microsoft Store.

I love .NET and ASP.NET Core, but I use it purely for backend. And even there, I use 3rd party libraries like Fast Endpoints (https://fast-endpoints.com/). Microsoft keeps bringing in new technologies and effectively abandoning the ones that fall out of favour (look at the progression from MVC -> Razor Pages -> Blazor). I do not blame the Microsoft Store team for not trusting the .NET team to not simply abandon Blazor as well somewhere down the line and instead opt for other technologies for the front-end.

I also find a very similar framework in .NET "Fast Endpoints"

I gave it a go and I was impressed how easy and fast it was to set it all up. Since I'm not a big fan of REPR pattern almost all my projects are using CQRS pattern with a help of MediatR ](https://github.com/jbogard/MediatR) I immediately started going over something similar that Fast Endpoints offer which is a command bus.

Ive personally been using FastEndpoints which is a community built thing on top of minimal apis - https://fast-endpoints.com/

I've just started to use a similar thing, and it's so much better than controllers - https://fast-endpoints.com/

Sort of minimal but check out FastEndpoint. https://fast-endpoints.com/