LINQ and WCF Services

Riddhi Valecha

10y890LINQ

Hi all... I have queries about LINQ ..

I have one application and 3 databases -
1st database - for developers
2nd database - for testing team
3rd database - for users (production)..

In normal 3-tire architecture, if the database credentials changes, then we change the connection string in web.config file.

But, in LINQ, Once the .dbml file is included, it makes datacontextclass itself...

SO, in future, what to do so that only the connection string is changed and rest all code remains the same ??

Also - please guide on - how to use WCF Services with LINQ-to-SQL - i.e. all LINQ Queries in WCF Services so that the portal runs smoothly and faster in IIS Server.

Please guide !

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Riddhi Valecha10y ago
hi.. in wcf service, my webconfig file is -

           bindingConfiguration="BasicHttpBinding_Service1" contract="ServiceReference1.Service1"
        name="BasicHttpBinding_Service1" />


-------
My Query is-
Localhost now runs perfectly..

But, once I publish the website and host in server (other machine - 1.1.1.1), then endpoint issue arises.

I want a solution such that -
1. endpoint address must be a specific URL
2. No need to change it on repeated basis. Once fixed in webconfig file, it must work everywhere.

I tried the following -

        bindingConfiguration="BasicHttpBinding_Service1" contract="ServiceReference1.Service1"
        name="BasicHttpBinding_Service1" />

        bindingConfiguration="BasicHttpBinding_Service1" contract="ServiceReference1.Service1"
        name="BasicHttpBinding_Service1" />
-------
but none worked...

Please guide
Riddhi Valecha10y ago
Hi... After adding service reference , I am getting 2 methods -

wcf1.ServiceReference1.Service1Client client = new Service1Client();
client.DoWork();
client.DoWorkAsync();

-----

In short - I get two methods -

DoWork();
DoWorkAsync();

where as , in Service.cs file, I have written only one method -

public void DoWork()
{}
------------
Which one to use and why ??

PLease guide
Riddhi Valecha10y ago
Hi...

I have a sample table - Tbl_Employees -
ID Name Dept Post Total Reports
A1 Ramesh Database Executive 6
A2 Mahesh Network Manager 7
A3 Alpesh S/w Developer
Sr. Manager
9

I want to bind this data in gridview -

var q = from emp in Empdatacontext .tbl_Employees select emp ; // This is my LINQ Query.

I have written this is wcf Service.

Now, give me a method such that its return type is List / IEnurable / etc and I can bind this to gridview.
Manas Mohapatra10y ago
For .dbml file you need change the connection string your *.config file.

Follow below links:

http://www.codeproject.com/Articles/24561/Integrating-LINQ-to-SQL-queries-within-a-WCF-Servi

http://www.codeproject.com/Articles/28031/WCF-and-LINQ

http://weblogs.asp.net/zeeshanhirani/using-linq-to-sql-with-wcf-service

ID	Name	Dept	Post	Total Reports
A1	Ramesh	Database	Executive	6
A2	Mahesh	Network	Manager	7
A3	Alpesh	S/w Developer	Sr. Manager	9