ansaurus

Question

I am stuck in connecting SQL Server.. please help

Answer 1

+2 A:

To create tables you should use SQL Management Studio (an Express edition is available).

To easily interact with these tables in Visual Studio, right click on your project, go Add New Item -> Data -> LINQ to SQL Classes (call it DB.dbml or Base.dbml or something similar).

Now go View on the top menu -> Server Explorer.

Right Click on Data Connections -> Add Connection -> Microsoft SQL Server -> Put your Server Name (probably YOUR-PC\SQLEXPRESS), Select your database.

Now you can drag tables onto the dbml workspace.

Now build, and you can reference your tables in code like this:

DBDataContext db = new DBDataContext();
Car[] cars = db.Cars.Where(c => c.Make = "Ford").ToArray();

You might need to enable TCP/IP and Named Pipes for your SQL Server Express using the SQL Configuration Manager (Google for more details).

Graphain 2010-07-12 07:14:23

@Graphain than you for your reply.. one more query.Now that i have downloaded SQL Management Studio and installed.. i have got now an option for sql management in the folder MS SQL SERVER 2005.The thing is i even created my server login with respect to my PC name.Which is the file in the database in which i should type the create table statements? There is this option on left saying Master and model under Database hierarchy which again then consists this table and all.So which file to choose among them to write? Thank you very much.Even if there is any good book which can help me!

Nagaraj Tantri 2010-07-12 08:29:30

You need to make a new database. Master is the default database that holds information about the others. Don't edit this one. Just right-click create new database.

Graphain 2010-07-12 08:42:24

Thanks a lot :)

Nagaraj Tantri 2010-07-12 09:51:00

is this same as creating a schema? i mean if i had to manually type CREATE SCHEMA where can i do it? or infact how can i?

Nagaraj Tantri 2010-07-12 11:10:17

I think we're talking the same thing. It lets you make a database then you can make tables/views/stored procedures. Alternatively you can click New Query at the top left and write manual SQL

Graphain 2010-07-13 00:27:56

yeah okay.. thanks a ton :)

Nagaraj Tantri 2010-07-13 04:58:48

@Graphain i have two authentication's. one which is windows and another SQL server. since i am creating a web enabled database which one should i choose to create a DB? and The other problem is If i select SQL server authentication it ask's me login name n password, in which case i m doing this project on my PC. not connected to any internet or anything. so what should i do? please if you could help.. i tried google but mostly people have written in blog saying ask the login name n passwd to the guy who installed it,But i installed it and there wasn't any option at start to create any login

Nagaraj Tantri 2010-07-13 07:48:56

I would use windows authentication for now for the lot. You aren't going to have web people access your db, they're going to access your pages which access the db. Later you cant think about create accounts for each web app or whatever that have limited roles. You aren't at that stage yet.

Graphain 2010-07-14 00:53:22

@Graphain okay thank you :)

Nagaraj Tantri 2010-07-14 05:07:57

@Nagaraj Minor correction: later you can** think about roles (that is you can easily change your connection string later).

Graphain 2010-07-14 05:27:20

ansaurus

tags:

views:

answers:

I am stuck in connecting SQL Server.. please help

related questions