SQL Store Procedure Call Function In .NET Core Console Application

In this blog, we look at a cross-platform SQL store procedure call function in a .NET Core console application.

Introduction

 

In this function, the SQL procedure table reads a procedure call method in the .NET Core application for the basic console write to get the input value to the search result. The SQL procedure calls to select the statement from the database.

 

 Create Table 

CREATE TABLE wincurd (
Username nchar(10),
Passwords nchar(10)
);

 SQL Procedure

CREATE PROCEDURE  procselect  @username nchar(10)
AS
     select * from wincurd where username=@username
go

Basic string console values get functionality:

string val;
Console.Write("Enter value: ");
val = Console.ReadLine();
string a = Convert.ToString(val);
Console.WriteLine("Your input: {0}", a);

SQL Connection string functionality:

SqlConnection dc = new SqlConnection("Data Source=.;Initial Catalog=databasename;Integrated Security=True");

Command Execution Functionality

using(SqlCommand cmd = new SqlCommand("procselect", dc)) {
    cmd.CommandType = CommandType.StoredProcedure;
    cmd.Parameters.AddWithValue("@username", a.ToString());
    dc.Open();
    SqlDataReader dr;
    dr = cmd.ExecuteReader();
    if (!dr.Read()) {
        Console.Write("Record not found ");
    } else {
        string b = Convert.ToString(val);
        b = dr[1].ToString();
        Console.WriteLine("Your PASSWORD: {0}", b.ToString());
        Console.ReadLine();
    }
    dc.Close();
}

Sample Output:

 

 

Conclusion

 

The function console writes to read the value process to SQL connection string executed in the command type functionality and the parameter parses the value of string SQL connection that's open to execute the SQL reader. If data is not available, the console white line message shows. Otherwise, it reads your connection array of values.