How do you specify a SQL database to a DataContext?

[NewsBot]

I feel like my mind is thicker than cement, because I just can not see how to specify a SQL Server 2005 database on a server, to a DataContext object.* I want to run a stored procedure I've written in one of the databases, so I've created a LINQ to SQL Class object in my VS 2008 project and then dragged my SP onto the design surface.* It went ahead and generated the strongly typed DataContext class, which is cool and all that, but every example I find describing accessing a SQL Server database using the DataContext class, or some drived class like my new strongly typed DataContext class, always shows the .MDF file as being on the local machine!* That certainly is not the case here, where the SQL database sits on our Windows 2003 server, but my .dbml and related files sit on my development machine.* I am certain I don't have direct access to the SQL .MDF file on the server, so I don't know what I'm supposed to use when calling the strongly typed DataContext class's constructor.* So, how do I specify that .MDF file on the server that I don't have access to?

 

I'm working on putting this code into a WCF service I'm writing, so once I'm done developing it on my machine I'll deploy it to the server, and at that time I'll want to change the connection strong to point to the .MDF file, because it will by then be local to the server.* So how do I configure it so that I can change how the WCF service will access it when I'm testing it on my PC and deploying it to the server?

 

 

More...

 

View All Our Microsoft Related Feeds