This is a simple implementation of Bank ATM application using ADO.NET and Microsoft SQL Server Management System.
ADO.NET : The .NET platform defines several namespaces that allow you to interact with relational database systems. Collectively speaking, these namespaces are known as ADO.NET.
ADO.NET provides consistent access to data sources such as SQL Server and XML, and to data sources exposed through OLE DB and ODBC. Data-sharing consumer applications can use ADO.NET to connect to these data sources and retrieve, handle, and update the data that they contain.
Microsoft SQL Server Management System : It is an integrated environment for managing any SQL infrastructure. In this project, we used SSMS to access, configure, manage, administer, and develop all components of the SQL Server.
- Deposit
- Withdrawal
- Check Balance
- Transfer
N/B : All the operations done in this ATM are saved!
| Card Number | Pin |
|---|---|
| 1020304050 | 1234 |
| 1121314151 | 1030 |
| 1222324052 | 1935 |
Follow the following steps to successfully run and use this application.
- Paste your system's server name on the Connection String
- Open the ATM_DAL project
- Open the Database Folder
- Open the CreateAtmDB.cs class
- Edit the connection string and paste your system server name in the Data Source value of the ConnectionString variable.
string connectionString = (@"Data Source = (Your Server Name); Integrated Security = True; Connect Timeout = 30; Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False");- Save
- Install the SqlClient Data provider on the ATM_DAL Assembly
- Open ATM_DAL project
- Right Click on Dependencies and select Manage NuGet packages
- Browse Microsoft.Data.SqlClient and install.
- Connect the newly created Database
- Open ATM_DAL project
- Open Database folder
- Open AtmDbContext.cs
- Edit the connection string and pass your newly created Database connection string to the AtmDbContext Constructor.
public AtmDbContext() : this(@"(paste your newly created database Connection String here)")
{
}
- Save
- Run the program
- Technology: C# and ADO.NET
- Data Provider: SqlClient
- SQL Environment: Microsoft SSMS
- Console App Framework: .NET7
- Project Type: Class Library
- Class Library Framework: .Net standard 2.0
- IDE: Visual Studio (Version 2022)
- Paradigm or pattern of programming: Object-Oriented Programming (OOP)
NOTE: We appreciated the use of ADO.NET to interact with the relational database with the help of SqlClient data provider. This repo is subject to future modifications.