StreamJockey

Search for SQL in your databases with Red Gate SQL Search

Find fragments of SQL text within stored procedures, functions, views and moreQuickly navigate to objects wherever they happen to be on your serversFind all references to an object Integrates with SSMS

via www.red-gate.com

We have been very satisfied users of the RedGate SQL Toolbelt for years. Every few months a need to search the entire database comes up but until now we have not had a good tool to use.

WCF Client Proxy to Use List instead of Array

If you want your client to make use of the .NET List type instead of the default Array use the /ct flag as shown below:

C:\MTI\Symphony\FrontEnd\Symphony.WindowsClient>svcutil http://localhost:9000/ /r:C:\Windows\Microsoft.NET\Framework\v2.0.50727\System.dll /ct:System.Collections.Generic.List`1
Microsoft (R) Service Model Metadata Tool
[Microsoft (R) Windows (R) Communication Foundation, Version 3.0.4506.648]
Copyright (c) Microsoft Corporation.  All rights reserved.

Attempting to download metadata from 'http://localhost:9000/' using WS-Metadata Exchange or DISCO.
Generating files...
C:\MTI\Symphony\FrontEnd\Symphony.WindowsClient\MailService.cs
C:\MTI\Symphony\FrontEnd\Symphony.WindowsClient\output.config

C:\MTI\Symphony\FrontEnd\Symphony.WindowsClient>

Using an enum type with WCF services

An example data contract and service contract/interface that makes use of the enum type.

using System;
using System.Runtime.Serialization;

namespace RocxSoft.DataContracts
{
    /// <summary>
    /// RefundStatus Data Contract
    /// </summary>
    [DataContract(Name = "RefundStatus", Namespace = "http://rocxsoft.datacontracts/2008/06")]
    public enum RefundStatus
    {
        [EnumMember()]
        FileInvalid = 0,
        [EnumMember()]
        FileRegistered = 1,
        [EnumMember()]
        FilePending = 2
    }
}

using System;
using System.ServiceModel;
using RocxSoft.DataContracts;

namespace RocxSoft.ServiceContracts
{
    /// <summary>
    /// Refund Service Contract
    /// </summary>
    [ServiceContract(Namespace = "http://rocxsoft.servicecontracts/2008/06")]
    [ServiceKnownType(typeof(RefundStatus)]
    public interface IRefund
    {
        [OperationContract(Name = "Status")]
        RefundStatus Status(Guid refundId);
        ...
    }
}