c# – Encrypting Data with interception of SQL instructions generated by Entity Framework

WPF Application, C#, MS SQL Server, Entity Framework 6. I need to encrypt all data from user input, and do it apart from business logic. I’ve come to interception of SQL Queries generated by transferring LINQ expressions to SQL, and changing data from them to encrypted, in order to store only encrypted data. I’d like to know if it even possible, and how… And how to decrypt them back and show user only plaintext. I can’t change this method – i.e. i MUST intercept queries. Yet another thing – i must use methods from System.Security.Cryptography.
I have read https://docs.microsoft.com/en-us/ef/ef6/fundamentals/logging-and-interception this article – we use EF version of 4.1, this will not work. I had even checked through source code of EF6 on Github to check if i can override SaveChanges() method

i use database first in entity framework in visual studio but when I click ” update model from database ” changes do not apply

i use database first in entity framework in visual studio but when I click ” update model from database ” then I see the message ” using this text template can potentially harm your computer . do not run it if you obtained it from an unstructed source” I click Ok ; but model dont update from database

planning – What’s a good framework for a hackathon-style game development session?

I have a couple of buddies (3-4) that like programming. We thought it’d be fun to get together for a weekend and see what we can cobble together in that time. None of us have much experience with game development, but most of us study CS or something related to it.

What would be a good framework (or whatever it’s called) to quickly build something in a weekend? It doesn’t need to be fancy at all, but should preferably still involve mostly programming. Most of us have worked with a bunch of different languages, so we don’t have much of a preference in that regard.

What’s the difference between NIST vs. OSI Security Architecture framework?

I’m trying to identify a framework that can help my team identify the possible security attacks / vulnerabilities and the possible mitigations for those attacks / vulnerabilities of a software. The idea is to identify those in all the softwares we have. Although the team has experience none of us have ever done security assessment. We are looking for a framework that can help us. What I would like to know is the difference between NIST vs. OSI Security Architecture framework.

windows server – Problemas con Framework

Hoy les vengo a preguntar una cuestión sobre el Framework 4.7.2.
Igual es una preguntar estúpida pero sería de agradecer alguna aclaración al problema que tengo y es el siguiente: ¿Se podría utilizar en un Windows Server 2003 el Framework 4.7.2? En caso afirmativo, podrían guiarme a cómo instalarlo?

He estado buscando información al respecto y he descubierto que lo “mínimo” que acepta el Framework 4.7.2 es Windows Server 2008 R2 Service Pack 1 (x64).

Gracias por la ayuda, un saludo

development process – How to choose the proper backend framework for my webapp

As said in the title I’m searching an help choosing the best framework for my webapp.

My application is an editor that helps user “editing” a 20-30MB multidimensional array.

It is easy to do that, the problem is everytime the user do a single edit the array must be synced with the server without sending 20MB of json text each time.

For example:

I developed something in past using blazor and the result was really “MEH”. So, I decided to start from scratch, choose a good framework and learn all I should learn.

So, here we come to the final question. There are a lot of frameworks and I really don’t know where to start, what to choose. As a newbie I’m totally lost and I don’t want to waste time learning something that doesn’t really fit for my project.

.net – Entity Framework ThenInclude doesn’t include properties of the grandchild

Entity Framework ThenInclude doesn’t include any properties of the grandchild. When I try to access the property “Total” of the “GrandChild” I get an error “CS1061 ‘ICollection’ does not contain a definition for ‘Total’ and no accessible extension method ‘Total'”. The intellosense doesn’t work with “GrandChild” at all. It works fine with the “Child”, but not with the “GrandChild”. When I make the request from Postman I can see that Entity includes “GrandChild” and it has property “Total” for sure (and all other properties).

var products = dbf.Products
                .Include(a=>a.Child)
                .ThenInclude(b => b.GrandChild)          
                .Where(c => c.ProId >72200);

            foreach(var p in products)
            {
               p.Child.GrandChild.Total// I get error here

            }

object oriented design – Is there a framework for software architecture specifications?

As software developers naturally understand code, I got into the practice of writing the specs as a simple node.js app. Coupled with a simple explanation in the comments, this has worked fairly well. This seems to eliminate a lot of confusion one usually gets with specs written in plain English.

The way I do it is to have folders for actors, such as web app and server, a module with constants(command names sent to/from the actors, system-wide events such as a lost network connection), and an integrator that simulates part of the interaction between the components.
The actors emit events along with a payload and in the integrator, the correct actors listen for these events.
The meat of the project can be found in the unit tests where a specific interaction between the components is studied and detailed.

Here are a few examples of the reverse process. Gitlet was written in order to get a better understanding of git. This simple node.js app is a simple blockchain abstraction with the same goal.

There are some cross-cutting concerns that are universal, such as WebSockets, HTTP requests, disk i/o, and many more. I would like to formalize this work process in a framework but would avoid reinventing the wheel if any work has already been done.

Here are my questions:

  1. What is your opinion of this methodology? Would you use it?

  2. Do you know of any related work?

Thanks!