C# Programming Basics

Retrieving/Setting Read Timeout

• Retrieve the timeout value in milliseconds from myHttpClient: int timeout = myHttpClient.Timeout.Milliseconds;
• Set a timeout of 1000 milliseconds: myHttpClient.Timeout = TimeSpan.FromMilliseconds(1000);

StreamWriter Initialization

• Use a using statement to ensure the StreamWriter is disposed of properly:

using (StreamWriter writer = new StreamWriter("filePath.txt"))
{
    writer.WriteLine("Your text here");
}

Retrieving Stream Readability

• Check if the stream (stream) is readable: if (stream.CanRead)
• Perform read operations if the stream is readable.

Importing Classes for SQL Server Access

• Use the System.Data and System.Data.SqlClient namespaces to access MS SQL Server.

Thread Instantiation

• Create a new thread: Thread thread = new Thread(new ThreadStart(MethodName));
• Start the thread: thread.Start();

Database-Specific Syntax

• This section outlines database-specific syntax for connecting to a database. Specific commands and setups based on the database system being used (e.g., SQL Server) will be included.

Connecting to a Database

• connectionString is used to specify the connection details to a database (e.g., server name, database name, user credentials, and password).

string connectionString = "Data Source=ServerName;Initial Catalog=DatabaseName;User ID=Username;Password=Password;";
using (SqlConnection connection = new SqlConnection(connectionString))
{
    connection.Open();
    // Perform database operations
}

SQL Command Syntax

• 1. Insert: Example INSERT query and parameter handling:

string query = "INSERT INTO TableName (Column1, Column2) VALUES (@Value1, @Value2)";
using (SqlCommand cmd = new SqlCommand(query, connection))
{
    cmd.Parameters.AddWithValue("@Value1", value1);
    cmd.Parameters.AddWithValue("@Value2", value2);
    cmd.ExecuteNonQuery();
}

• 2. Update: Example UPDATE query and parameter handling:

string query = "UPDATE TableName SET Column1 = @Value WHERE Column2 = @Condition";
using (SqlCommand cmd = new SqlCommand(query, connection))
{
    cmd.Parameters.AddWithValue("@Value", value);
    cmd.Parameters.AddWithValue("@Condition", condition);
    cmd.ExecuteNonQuery();
}

• 3. Delete: Example DELETE query and parameter handling:

string query = "DELETE FROM TableName WHERE Column = @Condition";
using (SqlCommand cmd = new SqlCommand(query, connection))
{
    cmd.Parameters.AddWithValue("@Condition", condition);
    cmd.ExecuteNonQuery();
}

• 4. Select: Example SELECT query and result handling (using a SqlDataReader):

string query = "SELECT * FROM TableName WHERE Column = @Condition";
using (SqlCommand cmd = new SqlCommand(query, connection))
{
    cmd.Parameters.AddWithValue("@Condition", condition);
    using (SqlDataReader reader = cmd.ExecuteReader())
    {
        while (reader.Read())
        {
           // Process each row
        }
    }
}

SQL Parameter Instantiation

• Create a parameter object: SqlParameter parameter = new SqlParameter("@ParamName", SqlDbType.Int);
• Assign a value to the parameter: parameter.Value = 123;

Dequeue/Enqueue in Queue

• Create a queue: Queue<int> queue = new Queue<int>();
• Enqueue an item: queue.Enqueue(10);
• Dequeue an item: int item = queue.Dequeue();

Stack Instantiation

• Create a stack: Stack<int> stack = new Stack<int>();

Pushing and Popping Items onto a Stack

• stack.Push(10); // Pushes 10 onto the stack
• int item = stack.Pop(); // Pops and retrieves an item from the stack

Calling Stored Procedures

• Execute a stored procedure similar to SQL commands:

string storedProc = "StoredProcedureName";
using (SqlCommand cmd = new SqlCommand(storedProc, connection))
{
    cmd.CommandType = CommandType.StoredProcedure;
	cmd.Parameters.AddWithValue("@ParamName", paramValue);
	cmd.ExecuteNonQuery();
}

Thread and Exception Handling

• Assigning Thread:

Thread thread = new Thread(() =>
{
   // Code to run in the thread
});
thread.Start();

• Try/Catch Block:

try
{
    // Code that might throw an exception
}
catch (Exception ex)
{
    Console.WriteLine($"Error: {ex.Message}");
}

SQL Server Database Management

• Deleting a database: DROP DATABASE DatabaseName;
• Creating a database: CREATE DATABASE DatabaseName;

Test your knowledge on essential C# programming concepts, including timeout settings, file writing, stream operations, and SQL Server access. The quiz covers various practices for managing threads and database-specific syntax. Enhance your coding skills with this comprehensive assessment.