C#

Timothy_1982 wrote:

to speed up the time of loading. But i'm just testing it out, now i saw it makes almost no difference.

Timothy_1982 wrote:

by using NGEN, u can precompile your assemblies to use, does that help the speed of loading the application?

Timothy_1982 wrote:

I'm using an installer for install my project on client pc. So then i have to add a function to execute NGEN in a custom action in my installer?

Matt Casto wrote:

would it be possible to read the file using WinAPI?

FileStream fs = New FileStream("filepath", FileMode.Open, FileAccess.Read, FileShare.ReadWrite);
StreamReader sr = New StreamReader(fs);

using (SqlConnection connection = new SqlConnection(connectString))
{
    connection.Open();

    // Start a local transaction.
    SqlTransaction sqlTran = connection.BeginTransaction();

    // Enlist the command in the current transaction.
    SqlCommand command = connection.CreateCommand();
    command.Transaction = sqlTran;

    try
    {
        command.CommandText =
          "INSERT INTO Production.ScrapReason(Name) VALUES('Wrong size')";
        command.ExecuteNonQuery();
        command.CommandText =
          "INSERT INTO Production.ScrapReason(Name) VALUES('Wrong color')";
        command.ExecuteNonQuery();
        sqlTran.Commit();
        Console.WriteLine("Both records were written to database.");
    }
    catch (Exception ex)
    {
        Console.WriteLine(ex.Message);
        Console.WriteLine("Neither record was written to database.");
        sqlTran.Rollback();
    }
}

using (TransactionScope scope = new TransactionScope()) 
{
    using (SqlConnection connection = new SqlConnection(connectString))
    {
        connection.Open();

        SqlCommand command = connection.CreateCommand();
        try
        {
            command.CommandText =
              "INSERT INTO Production.ScrapReason(Name) VALUES('Wrong size')";
            command.ExecuteNonQuery();
            command.CommandText =
              "INSERT INTO Production.ScrapReason(Name) VALUES('Wrong color')";
            command.ExecuteNonQuery();
            scope.Complete();
        }
        catch (Exception ex)
        {
            Console.WriteLine(ex.Message);
            Console.WriteLine("Neither record was written to database.");
        }
    }
}