Black Hole In Dot Net

You can allow the feature Always Encrypted of the SQL Server 2016 is through writing the sequence, and after that, all data-access is secured, no further programming required. As this is an association sequence establishment, it’s allowed in every ORM out there out of the box. That’s of course not the issue. The issue is including more power over this feature to the designer composing rule which focuses SQL Server 2016.

Starting in Dot Net 4.6, the SqlClient API provides a way to specify when and when not to secure using SQL Server 2016. This is done through an establishing in SqlCommand’s constructor: you can specify a SqlCommandColumnEncryptionSetting value which gives you power over when to secure and when not to secure, which could significantly improve efficiency if you just partially secure your catalog.

There’s something odd, though: Although SqlCommand has a residence for this, ColumnEncryptionSetting, it’s read-only. Its support varying is set through the constructor. What is the reason behind the issue? Nevertheless, your code is developing SqlCommand circumstances straight, you can’t set the establishing for a given SqlCommand instance: if you use DbProviderFactory, and most ORMs do, or if you use CreateCommand() on the associated object, you can’t set the setting. You can only set it if you straight use the constructor.

The problem

Looking at this, somewhat really developed SqlCommand API, it can be wondered that there’s a problem with this API, where can the reviews be given so they can fix it. They couldn’t be responsive to that. With an item you buy from a resource, you can do to that vendor’s assistance direction, ask them what they think should be done to get this settled and you gradually achieve a summary, but here, there is basically no clue.

With .NET core, the most growth regarding Dot Net within Microsoft depends on upon that, and a lot of air time is given to that on GitHub, blog posts etc. But .NET complete, e.g. v4.6.2, where do you go with a problem like this? Connect? Email someone within Microsoft , expecting they’ll direct it to some individual that won’t remove it right away and look at it? About, Link, there will be a lack: no way in terrible am invest another second of your energy on the earth in that low-quality program. Not only does the .NET group does not respond to any problems there, they still have some beginning problems there which are decades of age and no-one concerns to response them. It’s like composing the problem into some written text information file and never look at it again, the same outcome.

About emailing someone within Microsoft: that might perform, but it also might not. It can be known that some individuals within Microsoft organization and it can be pretty sure that they’ll at least look at the e-mail, but it’s an exotic way to provide feedback: here we have a mega-corporation that creates immeasurable money each 30 days, says to be a designer targeted organization and you have to e-mail your query to some worker and desire to get answers? How screwed up is that!

Now, my technological problem with SqlCommand is not something everyone will run into. That’s also not the factor. The factor is: if there’s a problem with the .NET BCL/API, there should be a specific direction to the groups operating on this codebase to provide them reviews, review problems and get factors set. Nowadays there’s none. Oh of course, if factors relevant to .NET Primary pop up, we can begin a problem on GitHub and begin the discussion there, but this isn’t relevant to .NET Core: SqlClient on .NET core doesn’t contain any security relevant code , so this matter is out of the opportunity for .NET core.

Microsoft seriously has to get factors set in this place. We .NET designers now have no way to provide reviews to them regarding APIs we have to perform with every day. It’s not maintainable nor efficient. They don’t need the current e-mail deal with of the SqlClient group, they need a publicly available program where they can data file problems and Microsoft organization can react quickly to them so they can tell their customers and customers why factors are the way they are. Which is how we do factors in the ISV world: give assistance to our spending customers easily and completely so they can help their customers easily and completely.

You know, as experts. You can also learn .net through the .net training institutes in Pune to make your profession in this field.

For .NET training and placement reviews, please do visit CRB Tech Reviews

Related Articles:

Why Microsoft’s Dot Net Core Is The Future Of Its Development Platform?

Best 13 Free .NET Development Tools