El TecnoBaúl de Kiquenet

Kiquenet boring stories

Archive for 24 junio 2014

Video creation in .NET C#

Posted by kiquenet en 24 junio 2014

AVI file library






Posted in .NET | Etiquetado: , , , , | Leave a Comment »


Posted by kiquenet en 24 junio 2014









Posted in .NET | Etiquetado: , , , , | Leave a Comment »

Scheduled Tasks

Posted by kiquenet en 24 junio 2014

Task Scheduler – Automated Emails – Windows Service – SendEmail.exe





Quartz Enterprise Scheduler.NET


Conversion Date – SqlServer

SqlServerCrontab (NContrab)


In Sql Server (Jobs)

USE msdb

    sj.job_id                 AS JobId,
    sj.name                   AS JobName,
    run_date                  AS RunDate,
    run_time                  AS Runtime,
    run_duration              AS RunDuration,
        CONVERT(CHAR(8), run_date, 112) + ‘ ‘ +
        STUFF(STUFF(RIGHT(‘000000’ + CONVERT(VARCHAR(8), run_time), 6), 5, 0, ‘:’), 3, 0, ‘:’)
        AS DateTime)              AS StartedAt,                   
            (CASE LEN(run_duration)
                WHEN 1
                THEN run_duration
                WHEN 2
                THEN run_duration
                WHEN 3
                THEN (CAST(Left(right(run_duration,3),1) as int)*60)
                    + (right(run_duration,2))
                WHEN 4
                THEN (CAST(Left(right(run_duration,4),2) AS int)*60)
                    + (right(run_duration,2))
                WHEN 5
                THEN (CAST(Left(right(run_duration,5),1) AS int)*3600)
                    + (CAST(Left(right(run_duration,4),2) AS int)*60)
                    + right(run_duration,2)
                WHEN 6
                THEN (CAST(Left(right(run_duration,6),2) AS int)*3600)
                    + (CAST(Left(right(run_duration,4),2) AS int)*60)
                    + right(run_duration,2)
              END ),
                CONVERT(CHAR(8), run_date, 112) + ‘ ‘ +
                STUFF(STUFF(RIGHT(‘000000’ + CONVERT(VARCHAR(8), run_time), 6), 5, 0, ‘:’), 3, 0, ‘:’)
            AS DateTime)))
        ,120))                    AS CompletedAt 
    FROM   msdb.dbo.sysjobhistory sjh WITH (nolock)
        INNER JOIN msdb.dbo.sysjobs sj WITH (nolock)
               ON sjh.job_id = sj.job_id
WHERE  sjh.step_id = 0
ORDER  BY run_date DESC,
          run_time DESC




Posted in .NET | Etiquetado: , , , , | Leave a Comment »

Customizing Code Coverage in Visual Studio 11

Posted by kiquenet en 24 junio 2014

1. The .runsettings file

Advanced VS 11 code coverage settings are specified in a .runsettings file. This is the configuration file used by VS 11 unit testing tools.

Some of you, who have used VS 2010, may be familiar with .testsettings file. You may be wondering why the same file was not used for VS 11. The reason for this was that the .testsettings file applies only to the MSTest based unit tests of VS 2010. The VS 11 unit testing tools not only apply for MSTest, but also 3rd party unit testing adapters such as NUnit and xUnit.net. Using a .testsettings file will not work with these. Hence a different settings file, the .runsettings, was used.

To customize code coverage, you will need to add .runsettings file to your solution. There isn’t a built-in template for this right now. You would need to add it as an xml file and edit its contents:

1. Right click Solution -> Add New Item -> XML File -> Save file as CodeCoverage.runsettings (the extension of .runsettings is important).

2. Copy the sample runsettings content given later in this blog into your file.

3. Edit it to customize code coverage, as explained in next section.

4. Set it as the default setting file to be used via Test -> Test Settings -> Select Test Settings File

After this, the specified settings should be used whenever you analyze code coverage.


2. Common customization scenarios

2.1. Customizing the set of binaries analyzed for code coverage

Here, we want include / exclude specific binaries from code coverage. Using the runsettings file, there are two approaches to do this:

Customize by exclusion

Here we include everything, and exclude what we don’t need – an opt-out approach. This may be useful if the code of interest changes often and new binaries get introduced frequently: you would like these new binaries to be automatically included for code coverage when they are loaded. There are some known binaries that you don’t want coverage, like some test automation code. These are excluded.

Here, leave the includes as empty to include all assemblies. Specify the assemblies to be excluded thru by their name / path.



<!– Do not specify any includes. This will attempt to include all binaries –>



<!– Exclude modules that aren’t to be processed, by their name / path –>





Customize by inclusion

Here we include exactly what we need, and exclude everything else – an opt-in approach. This may be useful if the code of interest is present in well-known binaries; you just want these binaries to be covered.

Here explicitly include the binaries of interest. Leave the excludes as empty to exclude everything.



<!– Include modules of interest, by their name / path –>




<!—- Do not specify any excludes. Anything not included will get excluded –>



Note that while both inclusions and exclusions can be used together, it can make things very confusing. So it is preferable to use one mechanism to customize.

2.2. Specifying symbol search paths

Code coverage requires symbols (PDB) for binaries to be instrumented. For binaries built by your solution, symbols are generally present alongside the binary and code coverage automatically works. In some cases, you may be referencing binaries external to your solution, but still need code coverage for these external binaries. In such cases, you can specify the symbol search path to look for symbols as part of the runsettings file.




A set of local and remote paths can be specified here. Note however that symbol resolution can take time, especially when using a remote build share with a lot of binaries. Best would be to avoid this by copying symbols alongside the binary, and not specify any search paths.

3. Sample .runsettings file

Below is a sample runsettings file. When creating a new runsettings, start with this, and customize it as needed.

<?xml version="1.0" encoding="utf-8"?>




<DataCollector friendlyName="Code Coverage"uri="datacollector://Microsoft/CodeCoverage/2.0"assemblyQualifiedName="Microsoft.VisualStudio.Coverage.DynamicCoverageDataCollector, Microsoft.VisualStudio.TraceCollector, Version=, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">





About include/exclude lists:

Empty "Include" clauses imply all; empty "Exclude" clauses imply none.

Each element in the list is a regular expression (ECMAScript syntax).

An item must first match at least one entry in the include list to be included.

Included items must then not match any entries in the exclude list to remain included.

It is considered an error to exclude all items from instrumentation as no data would be collected.














Additional paths to search for symbol files. Symbols must be found for modules to be instrumented.

If symbols are alongside the binaries, they are automatically picked up. Otherwise specify the here.

Note that searching for symbols increases code coverage runtime. So keep this small and local.


  <Path>C:\Users\User\Documents\Visual Studio 11\Projects\ProjectX\bin\Debug</Path>




























<Source>.*\\microsoft sdks\\.*</Source>


























4. Specifying runsettings file while running unit tests

Unit tests can be run in different contexts. The below specifies how runsettings are specified in each case.

4.1. In Visual Studio IDE

Select setting file to be used via Test -> Test Settings -> Select Test Settings File. Then invoke ‘Analyze Code Coverage’.


4.2. In command line

The tool vstest.console.exe is the way to run unit tests from command line. It is the successor of MSTest – and can run not only the MSTest based tests, but also tests of third party unit adapters (like NUnit, xUnit.net, etc).

To run tests with the runsettings file here:

1. Launch the Visual Studio Native Tools command prompt.

2. Run:

> vstest.console.exe TestAssembly.dll /EnableCodeCoverage /settings:CodeCoverage.runsettings

4.3. In Build

Here, there is a TFS Build Definition, as part of which unit tests are run and overall code coverage is measured. If there is a .runsettings file customizing code coverage, the same runsettings file can be used in the Build as well.

Below are the steps to do it.

1. Edit the build definition. Go to Process tab, and edit test run details.


2. Make sure the test runner is ‘Visual Studio Test Runner’. Set Options to ‘Custom’. Hit Browse to choose the settings file.


3. Pick the settings file and save the definition.



Posted in VisualStudio | Etiquetado: , , | Leave a Comment »