'Search String' all table

Declare @SearchStr nvarchar(100) SET @SearchStr='Search String' BEGIN CREATE TABLE #Results (ColumnName nvarchar(370), ColumnValue nvarchar(3630)) SET NOCOUNT ON DECLARE @TableName nvarchar(256), @ColumnName nvarchar(128), @SearchStr2 nvarchar(110) SET @TableName = '' SET @SearchStr2 = QUOTENAME('%' + @SearchStr + '%','''') WHILE @TableName IS NOT NULL BEGIN SET @ColumnName = '' SET @TableName = ( SELECT MIN(QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME)) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME) > @TableName AND OBJECTPROPERTY( OBJECT_ID(QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME)), 'IsMSShipped') = 0) WHILE (@TableName IS NOT NULL) AND (@ColumnName IS NOT NULL) BEGIN SET @ColumnName = ( SELECT MIN(QUOTENAME(COLUMN_NAME)) FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = PARSENAME(@TableName, 2) AND TABLE_NAME = PARSENAME(@TableName, 1) AND DATA_TYPE IN ('char', 'varchar', 'nchar', 'nvarchar') AND QUOTENAME(COLUMN_NAME) > @ColumnName) IF @ColumnName IS NOT NULL BEGIN INSERT INTO #Results EXEC ( 'SELECT ''' + @TableName + '.' + @ColumnName + ''', LEFT(' + @ColumnName + ', 3630) FROM ' + @TableName + ' (NOLOCK) ' + ' WHERE ' + @ColumnName + ' LIKE ' + @SearchStr2 ) END END END SELECT ColumnName, ColumnValue FROM #Results END

How can we create Proxy for the WCF Service?

How can we create Proxy for the WCF Service?

We can create proxy using the tool svcutil.exe after creating the service.
We can use the following command at command line.
svcutil.exe *.wsdl *.xsd /language:C# /out:SampleProxy.cs /config:app.config

What are the types of contract available in WCF?

What are the types of contract available in WCF?

a)Service Contract:Describes what operations the client can perform.
b)Operation Contract : defines the method inside Interface of Service.
c)Data Contract:Defines what data types are passed

WCF data contracts provide a mapping function between .NET CLR types that are defined in code and XML Schemas Definitions defined by the W3C organization (www.w3c.org/) that are used for communication outside
the service.

d)Message Contract:Defines wheather a service can interact directly with messages

Message contracts describe the structure of SOAP messages sent to and from a service and enable you to inspect and control most of the details in the SOAP header and body. Whereas data contracts enable interoperability through the XML Schema Definition (XSD) standard, message contracts enable you to interoperate with any system that communicates through SOAP. Using message contracts gives you complete control over the SOAP message sent to and from a service by providing access to the SOAP headers and bodies directly. This allows use of simple or complex types to define the exact content of the SOAP parts.

WCF Implementation Details

WCF Implementation Details
--------------------------------------
=> SOA Architecture Basics
=> Web services Basics
=> WCF Basics (SOAP, WSDL, UDDI)
=> WCF Features
=> WCF Basic Terminology
1) ABCs of WCF( address , binding , contract)
address -> HTTP,TCP,Peer network,IPC (Inter-Process Communication over named pipes),MSMQ
binding -> BasicHttpBinding,WsHttpBinding,NetTcpBinding,NetNamedPipesBinding,NetMsmqBindingcontract->Service contracts,Data contracts,Fault contracts,Message contracts, Operations

hosting
--------
Self-hosting,IIS Server,WAS (Windows Activation Service) Server.
2) Service Contracts and Operation Contracts
3) Data Contracts
4) Messag Contracts
5) WCF Layers ( Service Model, Messaging)
6) WCF Programming Model
7) Endpoint
8) WCF Architecture
(a)Contracts- Data contract,Message Contract, Service Contract,Policy and binding
b)Service runtime-Error behavior,metadata behavior,transaction behavior,TCP Channel
c)Messaging- WS Security Channel,HTTP Channel,TCP Channel
d)Activation and hosting - Windows Activation Service, .EXE,Windows service, COM+

9) Host Architecture ( IIS hosting, Self-hosting, WAS hosting)
10) Instance Management -> Per call -> Per session(Allowed, required, NotAllowed), -> Singleton
11) Service Throttling
=> WCF Simple Examples:
1) New -> Project -> WCF Service Application
2) New -> Project -> Class Library -> add reference - > System.ServiceModel
3) New -> Project -> WCF -> WCF Service Library
4) New -> Web site -> WCF Service

=> WCF Adavanced Examples:
1) Sessions
2) Using Data Sets and Database Connectivity
3) Transactions
4) Handling Complex data types
5) Security (Confidentiality ,Integrity,Authentication,Authorization)
5.1) Transaport level -> Using X509 Certificates
5.2) Message Security - > Using X509 Certificates
5.3) Message Security - > UserName and Password (ASP.NET Membership)
5.4) Message Security - > UserName and Password (Custom)
X 5.5) Message Security - > Issued Token
6) Input Data Validation
7) Ordering Input Parameters
8) Method Overloading using "Name" attribute
9) Interoperability (Consuming WCF Service with Java Client)
10) Tracing & Logging
=> N-Tier application with WCF and DataSets in Visual Studio 2008
=> Interoperability with dotnet client on another machine with Certificate security
=> WSSF

Advantage and disadvantage of LINQ?

Advantage and disadvantage of LINQ?
Adv.
Allow the developers to query data without having to write data store specific code.
It helps in Memory Collection query easily.
DisAdv.:
One disadvantage I see is that it adds another layer of code, and my understanding is that it has slower performance than using stored procedures and ADO.Net. It also seems that debugging could be a challenge, especially for more complex queries, and that these might end up being moved to a stored proc anyway.

What is three major points in WCF?

What is three major points in WCF?
We Should remember ABC.
Address --- Specifies the location of the service which will be like http://Myserver/MyService.Clients will use this location to communicate with our service.

Binding --- Specifies how the two paries will communicate in term of transport and encoding and protocols

Contract --- Specifies the interface between client and the server.It's a simple interface with some attribute.

What are the main components of WCF?

What are the main components of WCF?
The main components of WCF are
1. Service class
2. Hosting environment
3. End point