tecnocrata

select 
o.name,c.name 
from sys.columns c
inner join sys.objects  o on c.object_id=o.object_id
where c.name Like '%bus_no%'
order by o.name,c.column_id

-- for query tables use sys.tables
-- for query stored procedures use sys.procedures

tecnocrata

<DockPanel LastChildFill="True">
            <ProgressBar x:Name="pgrBar" Visibility="Hidden" DockPanel.Dock="Bottom"  IsIndeterminate="True" Height="20"></ProgressBar>
            <WebBrowser Name="webControl" />
</DockPanel>

tecnocrata

//http://stackoverflow.com/questions/336633/how-to-detect-windows-64-bit-platform-with-net

bool is64BitProcess = (IntPtr.Size == 8);
bool is64BitOperatingSystem = is64BitProcess || InternalCheckIsWow64();

[DllImport("kernel32.dll", SetLastError = true, CallingConvention = CallingConvention.Winapi)]
[return: MarshalAs(UnmanagedType.Bool)]
private static extern bool IsWow64Process(
    [In] IntPtr hProcess,
    [Out] out bool wow64Process

tecnocrata

--Recibiendo PageIndex y PageSize

SELECT TOP (PageSize) 
[Extent1].[Id] AS [Id], 
[Extent1].[Capacidad] AS [Capacidad], 
[Extent1].[Ubicacion] AS [Ubicacion] 
FROM ( SELECT [Extent1].[Id] AS [Id], [Extent1].[Capacidad] AS [Capacidad], [Extent1].[Ubicacion] AS [Ubicacion], row_number() OVER (ORDER BY [Extent1].[Id] ASC) AS [row_number] 
FROM [dbo].[Mesa] AS [Extent1] 
)　 AS [Extent1] 
WHERE [Extent1].[row_number] > PageSize*(PageIndex-1) 

tecnocrata

First you can start by removing the StartupUri attribute from the App.Xaml file so that it looks like this...

<Application x:Class="SingleInstance.App"
             xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
             xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml">
</Application>

After that, you can go to the App.xaml.cs file and change it so it looks like this...

public partial class App 

tecnocrata

//Ambas soluciones estan propuestas por Jorge Fioranelli: jorge.fioranelli@gmail.com


public interface IStep
{
    event EventHandler<StepEventArgs> Started;
    event EventHandler<StepEventArgs> Finished;
    void Execute();
}

tecnocrata

//PriorityManagement-by-RoutingMode>1:XXX>2:YYY

        private string ResolveNamePattern(string name)
        {
            var globalpattern = "(?<PName>.*)-by-(?<Criteria>.*)-(?<Conditions>>.*)";
            if (!Regex.IsMatch(name, globalpattern, RegexOptions.IgnoreCase)) return name;
            var globalregex = new Regex(globalpattern, RegexOptions.IgnoreCase);
            var parameterName = globalregex.Match(name).Groups["PName"].Value;
            var criteria = globalregex.Match(name).Groups["Criteria"].Value;

tecnocrata

private string CommentSelection(string selected)
        {
            var result = string.Empty;
            try
            {
                var lineMatches = Regex.Matches(selected, ".*", RegexOptions.Multiline);
                foreach (var lineMatch in lineMatches)
                {
                    if (string.IsNullOrEmpty(lineMatch.ToString())) continue;
                    result = result + @"//" + lineMatch.ToString();

tecnocrata

Changed database context to 'master'.
Changed database context to 'MyDataBase'.
Running pre-deploy script.
Changed database context to 'MyDataBase'.
Warning: The Microsoft .NET Framework assembly 'system.enterpriseservices, version=2.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a, processorarchitecture=amd64.' you are registering is not fully tested in the SQL Server hosted environment and is not supported. In the future, if you upgrade or service this assembly or the .NET Framework, your CLR integration routine may stop working. Please refer SQL Server Books Online for more details.
Warning: The Microsoft .NET Framework assembly 'system.directoryservices, version=2.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a, processorarchitecture=msil.' you are registering is not fully tested in the SQL Server hosted environment and is not supported. In the future, if you upgrade or service this assembly or the .NET Framework, your CLR integration routine may stop working. Please refer SQL Server Books 

tecnocrata

<system.diagnostics>
  <sources>
    <source name="System.ServiceModel" switchValue="Information, ActivityTracing" propagateActivity="true" >
      <listeners>
        <add name="xml"/>
      </listeners>
    </source>
    <source name="System.ServiceModel.MessageLogging">
      <listeners>
        <add name="xml"/>