-5
I would like to know what types of connections a given application developed in C# can have with the SQL Server database. Among all, which is the most efficient?
1 answer
1
In theory you can have as many as you want to create. You can create one, you can buy from third party suppliers or get some open source project.
The most efficient, until proven otherwise is the native, which makes direct access to the SQL Server client (SQLNCLI).
Many people use OLEDB, but I read something about abandoning the support for it, I don’t know how it is. ADO is one of the most used nowadays. You can also use ODBC, but I wouldn’t do this.
It is becoming more and more common, though I find it an exaggeration, the use of Orms such as Entity Framework, Nhibernate and even Dapper.
Each of them adds layers to the other.
Browser other questions tagged c# sql-server
You are not signed in. Login or sign up in order to post.
@Leonardo If you don’t have any parameters or requirements and just want to experiment, take a look at what is most popular and have the strongest community - I say this because I don’t know if you master English - in ptbr it is a little harder to find some resources. Drapper is a "micro-ORM" (and if I’m not mistaken, the OS uses it), if you want to "play around", take a look at it. EF and Nhibernate apparently have a more pronounced learning curve.
– nmindz