Kunal Mehta

My name is Kunal, and I'm a senior software engineer at SOROCO. I work with multiple technologies including Python, C#, Python, Pandas. For the database part, we're using Postgres. In the past, I've worked with various technologies such as C#.NET Core and Angular for the front end, and I've also used React. I've worked in Fintech and healthcare domains. In the past, I worked at Ola Financial Services and in the health domain. I've completed my post-graduation diploma in advanced computing from CDEC Pune, and I've done my bachelor's in computer science from the Technological Institute of Textile and Science, Bhiwani. That is all pretty much about me. That is all. Thank you.

We can use select max(salary) from employees where salary is greater than (select max(salary) from employees).

So entity framework provides in-built functions that we can use. In the in-built file, it internally uses SQL queries. And, it's an entity-based framework. Like, every class, every table is considered as an entity, and its columns in tables are considered the variables. It simplifies the problem very efficiently. Like, database tables are considered as real-world entities. This is how it simplifies data access and manipulation. Data access provides various functions for data access, and it also provides methods like save and update directly. We can use these methods directly, and data will be updated directly. And, suppose we are using a database today, MySQL, and in the future, if we want to upgrade to a different database, then there will be less change as compared to others if we are not using entity framework. Then there will be more changes. But with entity framework, there will be very much less change if we are changing any databases.

First thing, that we need is, we have to add the serialize, serializable attribute over the.NET object that we want to serialize. After that, we can use the in-built JSON library, that we can use, and it we can use JSON serialize, and that will serialize the.NET object to JSON format.

So if you want to have a continuous deployment using Azure DevOps, then first thing required is a version control system. Version control system like Git, GitHub, or another version control system. After we have a version control system, we can have multiple other steps. So we have to set up a pipeline, and in the pipeline, multiple steps will be executed as soon as there is a change in code. And whenever there is a change in code, the changes will go from the version control system. After that, we can set up a pipeline to run whenever changes are there. If changes act as an event, whenever there is an event, this chain, the pipeline will run. In the pipeline, we can add multiple steps like checking the linting, checking the formats, and having automated automation testing. And after all these steps are successful, then we have to set up a CI server. In the CI server, the code will be built whenever there is a code push. So after everything is built successfully, testing is successful, and linting and format check is successful, that build will be deployed to the server. This is how a SCA side CD pipeline will work, and this is continuous deployment using Azure DevOps.

To implement a system that maintains consistent data across multiple distributed systems, we can have a master-slave architecture where one node will be the master node and other nodes will be slave nodes. As soon as there is a change in data, there is a data insert in the master node, the data will be copied over to the slave nodes. And this is how the data consistency will be maintained over all the nodes in a distributed database.

The main problem with this code is, like, just we are just adding 2 numbers and as JavaScript is not type safe, so there can be possibility that num 1 is string and num 2 is integer. So it will concatenate as a string. It will not add up 2 numbers. So this is 1 problem. So we have to make it type safe. And, also, like, we are only console logging the result. We are not adding those numbers into a variable and not returning the variable. So this is also a problem. To solve this, we have to make it type safe. And if you want to return something, we want to add something, then we will have to add into a number, save into a variable, and then return from this function.

We are doing group by order ID, and we are also checking if it has some order quantity greater than 100. So only those rows will be included when the order ID count is some of the order ID is greater than 100. This is the main issue.

The secure authentication module that we can set up is using C# is JWT token. So every time there is a request for login, a JWT token will be created, and that will be sent to the sender in the response of login. And in further requests, this JWT token will be sent to every request, and this will be verified. So this is how the secure authentication will work. And it works with all the secure frameworks like OAuth and OpenID also.

If you want a full-fledged system for microservice-based architecture, then we should have a proper monitoring. Also, monitoring for performance and everything, how it is performing. Also, we should have a proper logging system. Because if we have good logging and monitoring, then we have a fault-tolerant system.