how to use the data in the database in Web Services in C#

Question

i am a newbiest of c#, i need to write a webs service in C#. However i meet some problem

how to connect the database that i create in the visualstudio ( i click on the server explorer tab, right click on the data connection and click on create new sql server data) with the web service
where should i call the data out from the database at?

really urgently...relpy asap....hope anyone can tell me the answer in the short period of time

if can show some examples or codes of this

Farshid Zaker · Answer 1 · 2011-06-03T07:55:32.497

1

You can use linq-to-sql as a rapid solution.

Just add a new Item "LINQ to Sql Classes" to your project. Drag your tables into designer and you have the equivalent classes. Using LINQ is too simple. Just google for every scenario and you will find tones of samples.

LINQ 101 examples

LINQ Introduction for VB

LINQ samples for VB

edited Jun 03 '11 at 07:55

answered Jun 03 '11 at 07:08

Farshid Zaker

1,960
2
22
39

for vb, need to add connection,beside using this, is there other ways – CutexBabies Jun 03 '11 at 07:13
You have to add connection. Of course you can replace the design-time connection with another in runtime. Just pass the connection string to the subclass of DataContext which is created for your project. – Farshid Zaker Jun 03 '11 at 07:17
dont really get you ?can show me? is put in where but i thought c# there no sub' – CutexBabies Jun 03 '11 at 07:34
but i need c#, i know how to create web service in vb but i dont know how to change to c# – CutexBabies Jun 03 '11 at 08:10

score 0 · Answer 2 · answered Jun 03 '11 at 07:09

0

Take a look at some LINQ examples.

answered Jun 03 '11 at 07:09

Aljaz Vidmar

675
5
11

can show me where or show some code...cause i don't know this – CutexBabies Jun 03 '11 at 07:11

how to use the data in the database in Web Services in C#

2 Answers2