blog-code-samples
Sample projects and code from my blog posts (by kashifsoofi)
SqlClient
Microsoft.Data.SqlClient provides database connectivity to SQL Server for .NET applications. (by dotnet)
blog-code-samples | SqlClient | |
---|---|---|
3 | 24 | |
7 | 805 | |
- | 0.9% | |
8.9 | 9.1 | |
3 months ago | 4 days ago | |
Go | C# | |
- | MIT License |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
blog-code-samples
Posts with mentions or reviews of blog-code-samples.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-08-19.
-
Integration Test MySQL with testcontainers-dotnet
Source for Integration Test MySQL (testcontainers-dotnet) workflow is in integration-test-mysql-testcontainers-dotnet.yml.
-
REST API with Go, Chi, MySQL and sqlx
I will start by copying the content of https://github.com/kashifsoofi/blog-code-samples/tree/main/movies-api-with-go-chi-and-memory-store, placing it in a new folder movies-api-with-go-chi-and-mysql and updating module name in go.mod to match the new folder and updating in source files where its used. This will usually be the root of your git repo and will not be as elaborate as this.
-
REST API with ASP.NET Core 7 and SQL Server
Source code for the demo application is hosted on GitHub in blog-code-samples repository.
SqlClient
Posts with mentions or reviews of SqlClient.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-05-31.
-
REST API with ASP.NET Core 7 and SQL Server
I will be using Dapper - a simple object mapper for .Net along with Microsoft.Data.Sql.
- System.AccessViolationException in PS 7.3.3 for SqlServer module 22.0.59
-
SQL Server Connection Error with Microsoft.Data.SqlClient
See the link https://github.com/dotnet/SqlClient/issues/1656
-
Best way for Android .NET MAUI App to retrieve data from remote SQL Server?
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.
-
When A .NET Developer Learns Blazor
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.
-
Co-op Student, Looking for clarification on an issue I am having at my co-op
Is any of the columns varchar(max) or similar type? There is a known issue in SqlClient package affecting async reading of such columns.
-
Learn DateOnly & TimeOnly
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.
-
Is there a way to find out how much memory specific variables are using? Google isn't helping
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.
-
How fast is ASP.NET Core?
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
-
How fast is really ASP.NET Core?
Until you trip over this https://github.com/dotnet/SqlClient/issues/593
What are some alternatives?
When comparing blog-code-samples and SqlClient you can also consider the following projects:
migrate - Database migrations. CLI and Golang library.
FastEndpoints - A light-weight REST API development framework for ASP.NET 6 and newer.