C#

[ServiceContract]
    public interface IServiceWhitewagon
    {

        [OperationContract]
        List<CompanyForView> GetCompany();
    }

public class ServiceWhitewagon : IServiceWhitewagon
   {
       public ServiceWhitewagon()
       {

       }

  public List<CompanyForView> GetCompany()
       {
           WhitewagonEntities db = new WhitewagonEntities();
           return
               (from company in db.Company
                select new CompanyForView
                {
                    idCompany = company.idCompany,
                    name = company.name,
                    phone = company.phone,
                    adress = company.adress
                }
                ).ToList();
       }
   }

[DataContract]
    public class CompanyForView
    {
        [DataMember]
        public int idCompany { get; set; }

        [DataMember]
        public string name { get; set; }

        [DataMember]
        public string adress { get; set; }

        [DataMember]
        public string phone { get; set; }
    }

public class CompanyDataStore : ItemDataStore<Company>
    {
        public CompanyDataStore()
        {
            items = zamowieniaServices.GetCompany(null).GetCompanyResult.Select(k => new Company
            {
                idCompany = k.idCompany,
                name = k.name,
                phone = k.phone,
                adress = k.adress
            }).ToList();
        }
    }

public abstract class ItemDataStore<T> : IDataStore<T>
    {
        public List<T> items;

        public IServiceWhitewagon zamowieniaServices { get; set; }

        public ItemDataStore()
        {
            zamowieniaServices = DependencyService.Get<ServiceReferenceWhitewagon.IServiceWhitewagon>();
        }
    }

items = new List<Company>()
           {
              new Company{idCompany=1,name="Klient 1"},
              new Company{idCompany=2,name="Klient 2"},

           };

"^(?=.*SELECT.*FROM)(?!.*(?:CREATE|DROP|UPDATE|INSERT|ALTER|DELETE|ATTACH|DETACH|TRUNCATE)).*$"

PROCEDURE [dbo].[GetAlertsForApp]
(
@appShortName nvarchar(16)
)
AS
BEGIN
SET NOCOUNT ON;
declare @appID int = (SELECT ID FROM dbo.Applications WITH(NOLOCK) WHERE AppShortName = @appShortName);
select [ID],[AlertName],[AlertTitle],[AlertMsg],[AlertStartDate],[AlertExpireDate],[AlertType],[AlertClassLevel]
,[AlertApps],[ActionName],[ControllerName],[DateAdded],[AddedByUMSUserID]
FROM [dbo].[Alerts] WITH(NOLOCK)
WHERE (UPPER(AlertApps) LIKE '%' + UPPER(@appShortName) + '%' OR UPPER(AlertApps) = 'ALL')
AND AlertExpireDate IS NULL OR AlertExpireDate > GETDATE() ;
END