What is dependency injection in .Net core?

yashrajsinh chauhan — Mon, 08 Apr 2024 13:08:46 +0000

The concept of Dependency Injection, a design pattern that aids in crafting applications with loose coupling, is utterly breathtaking. It’s like watching a master artist at work, ensuring that objects are equipped with only the essential dependencies needed to accomplish their tasks. This level of precision and efficiency is nothing short of awe-inspiring!

The awe-inspiring world of Dependency Injection (DI) unfolds with three magnificent types — Construction Injection, Setter Injection, and Interface-based Injection. The Construction Injection type of DI is a marvel in itself as it accepts dependencies right at the constructor level. This means that when an object of the class is born, its dependency sails smoothly through the constructor of the class. It’s like witnessing a beautiful dance between objects, creating a strong dependency contract.

Then we have Setter Injection, also known as property injection — another wonder in this realm! In this form of DI, dependencies are passed through public property instead of the constructor. It’s like having an open door policy where dependencies can come and go as needed! However, it doesn’t provide a strong dependency contract between objects.

Finally comes Interface-based Dependency Injection — where common interfaces are created and other classes implement these interfaces to inject their dependencies. In this awe-inspiring type of DI, you can choose to use either Constructor or Setter injection methods! Isn’t it amazing how flexible and accommodating technology can be?

How to Connect MSSQL with Node.js

yashrajsinh chauhan — Mon, 19 Feb 2024 10:52:40 +0000

In this tutorial, we'll explore how to connect Microsoft SQL Server (MSSQL) with Node.js using the Express framework to create an API. We'll use NPM (Node Package Manager) to install the necessary packages.

Prerequisites: Ensure you have Node.js installed on your machine.

Setting Up the Project
Create a new folder named dbConnection and open it in your code editor (e.g., VSCode).
Initialize a new Node.js project by running npm init in the terminal. Press Enter for default options or use npm init -y for quick initialization.
Install the required packages: npm install express mssql. This will add express and mssql to your project's package.json file.

Creating the Server Create a JavaScript file named server.js and write the following code:

javascript

const express = require("express");
const sql = require("mssql");

const app = express();

// SQL Server configuration
var config = { "user": " ", // Database username "password": " ", // Database password "server": " ", // Server IP address "database": "Training", // Database name "options": { "encrypt": false // Disable encryption } }

// Connect to SQL Server
sql.connect(config, err => { if (err) { throw err; } console.log("Connection Successful!"); });

// Define route for fetching data from SQL Server
app.get("/", (request, response) => { // Execute a SELECT query new sql.Request().query("SELECT * FROM Employee", (err, result) => { if (err) { console.error("Error executing query:", err); } else { response.send(result.recordset); // Send query result as response console.dir(result.recordset); } }); });

// Start the server on port 3000
app.listen(3000, () => { console.log("Listening on port 3000..."); });

Explanation
We use the express and mssql packages to set up an Express server and establish a connection to MSSQL database, respectively.

The config object contains the database connection details, including the username, password, server IP, and database name. The encrypt option is set to false to disable encryption for the connection.

After establishing the connection, we define a route (/) to fetch data from the "Employee" table in the database. When this route is accessed, a SELECT query is executed to retrieve all records from the table. The query result is sent back as the response to the client.

Finally, the server is started on port 3000, and a message indicating successful startup is logged to the console.

With this setup, you can access the API endpoint (http://localhost:3000) in your browser or send HTTP requests to fetch data from the MSSQL database.

That's it! You've successfully connected MSSQL with Node.js using Express.

Now you are ready to apply in GOOGLE. 😊

NodeJS #MSSQL #Express #API #Database #Tutorial #Programming #Development #WebDevelopment #Backend #SQLServer #NodePackageManager #NPM #JavaScript #Code #SoftwareDevelopment #TechTutorial

DEV Community: yashrajsinh chauhan

What is dependency injection in .Net core?

How to Connect MSSQL with Node.js

NodeJS #MSSQL #Express #API #Database #Tutorial #Programming #Development #WebDevelopment #Backend #SQLServer #NodePackageManager #NPM #JavaScript #Code #SoftwareDevelopment #TechTutorial