DataSharp_Library 1.0.2

start from here 😃

What is Datasharp-Library

DataSharp is a nuget package that aims to help developers to easily connect and perform CRUD operations on SQL databases integrated into their C # applications.

Usage

Run the following commands in order to this package in your C# application:

• Package Manager: Install-Package DataSharp_Library -Version 1.0.2

• NET CLI: dotnet add package DataSharp_Library --version 1.0.2

• Paket CLI: paket add DataSharp_Library --version 1.0.2

• NOTE: For projects that support PackageReference, copy this XML node into the project file to reference the package:

• <PackageReference Include="DataSharp_Library" Version="1.0.2" />

Connect to Database

using DataSharp_Library.Builders;
using DataSharp_Library.Models;
using DataSharp_Library.Utilities;

Database database = new DatabaseBuilder()
                .DataSourceProvider(Provider.SQLSERVER)
                .ConnectionString(@"<REPLACE_CONNECTION_STRING>")
                .Build();

Get Database Connection

using DataSharp_Library.Builders;
using DataSharp_Library.Models;
using DataSharp_Library.Utilities;

Database database = new DatabaseBuilder()
                .DataSourceProvider(Provider.SQLSERVER)
                .ConnectionString(@"<REPLACE_CONNECTION_STRING>")
                .Build();

SqlConnection connection = (SqlConnection) database.Connect();

Operations

Insert

String query = "INSERT INTO developer(id, name, nickname, level) VALUES (?, ?, ?, ?)";

database.InsertData(query, 2, "John Doe", "johndoey", 8);

SELECT

String query = "SELECT * FROM developer";

ArrayList developers = new ArrayList();

database.retrieveData(query, developers);

**MORE FEATURES COMING SOON!