Connect to a SQL Database and Use the LINQ to SQL Designer

DotNetKicks.com — Tue, 20 Nov 2007 04:05:05 GMT

You've been kicked (a good thing) - Trackback from DotNetKicks.com

re: Connect to a SQL Database and Use the LINQ to SQL Designer

Mark Dykun — Tue, 20 Nov 2007 04:26:53 GMT

Charlie, the first statement seems strange. You need a database you can connect to and also SQL Express. In my experience I have not required SQL Express to use LINQ to SQL. Am I in error on this?

Mark

re: Connect to a SQL Database and Use the LINQ to SQL Designer

Charlie Calvert — Tue, 20 Nov 2007 09:15:12 GMT

Mark,

Thanks for your comment. I did not mean to imply that MS SQL Server would not work with LINQ to SQL. It certainly does. I've rewritten the first paragraph to make it clear that you can use either MS SQL Server or SQL Express, but that this post focuses on using SQL Express.

- Charlie

re: Connect to a SQL Database and Use the LINQ to SQL Designer

Robert — Tue, 20 Nov 2007 17:24:19 GMT

Charlie,

Thanks for the brief presentation of linq.

I have not tried the VS 2008 yet.

However, I have some question regarding the linq and linq to sql designer.

What will happen if someone changes the underlying table structure (column data types, column names,...).

A runtime error will be raised?

Is there any possibility of automatic updates and synchronization in the linq designer ?

Robert

Understanding the DataContext

Charlie Calvert's Community Blog — Tue, 11 Dec 2007 09:48:21 GMT

In an earlier post I showed how LINQ developers can connect to a database and write a simple query. This

Understanding the DataContext

Noticias externas — Tue, 11 Dec 2007 10:47:15 GMT

In an earlier post I showed how LINQ developers can connect to a database and write a simple query. This

re: Connect to a SQL Database and Use the LINQ to SQL Designer

S Saxon — Wed, 12 Dec 2007 03:01:41 GMT

Very informative for me, I'm very new to C# and Linq. Thanks, Sid

re: Connect to a SQL Database and Use the LINQ to SQL Designer

Charlie Calvert — Wed, 12 Dec 2007 23:31:57 GMT

Robert,

If the metadata for a table changes, then you can delete it from the designer and drag it on again to regenerate the code. If you think you will need to do this kind of thing often, then you can use the command line tool called SqlMetal, which will generate the code automatically. The classes SQLMetal and the SQL Designer create are all declared to be partial so that any code you write to customize the behavior of the autogenerated code will not be overwritten.

- Charlie

re: Connect to a SQL Database and Use the LINQ to SQL Designer

Pablo — Mon, 17 Dec 2007 11:06:47 GMT

I can't find where in the code the application actually reads APP.CONFIG.

How can I use a custom configuration file?

I saw that the Settings class saves the connection string in a hard-coded attribute: how can I change that?

Can you point me to a URL where I can learn 'LINQ in depth'?

Thanks a lot,

Pablo.

re: Connect to a SQL Database and Use the LINQ to SQL Designer

eve — Wed, 02 Jan 2008 04:30:22 GMT

hi, i would like to ask that do u know the code of using visual C# in window Forms application connection to SQL server (database)? Because i'm not using Console Application to connection to database.

re: Connect to a SQL Database and Use the LINQ to SQL Designer

billy bob — Sun, 02 Mar 2008 01:42:05 GMT

Exactly the info I wanted to get started - thanks!

There's good follow-up info on usage here (among a lot of other places):

http://weblogs.asp.net/scottgu/archive/2007/05/19/using-linq-to-sql-part-1.aspx

For anyone who's interested.

re: Connect to a SQL Database and Use the LINQ to SQL Designer

billy bob — Sun, 02 Mar 2008 05:41:33 GMT

A question:

I successfully carried out the steps you gave, but I'm wondering exactly where the database *is*. I don't see it in bin\debug.

More generally, I'm wondering how deployment works. I want my app to carry its own little sqlexpress db with it, and populate itself from data in files on whatever computer it's running on.

re: Connect to a SQL Database and Use the LINQ to SQL Designer

Charlie Calvert — Wed, 19 Mar 2008 07:45:37 GMT

Pablo,

The DataContext that is created by the LINQ to SQL Designer (aka the Object Relational Designer) has code for reading your config file. This code will be executed if you use the default constructor for the DataContext If you prefer to pass in your own connection string, you can use the second constructor for the DataContext, which takes a connection string as a parameter:

DataClasses1DataContext db =

new DataClasses1DataContext(MyConnectionString);

The samples that ship with the product, such as the Northwind sample, show how to use this second parameter, and how to construct a connection string that will work with it.

- Charlie

re: Connect to a SQL Database and Use the LINQ to SQL Designer

Charlie Calvert — Wed, 19 Mar 2008 07:49:02 GMT

Billy Bob,

Unless you explicitly ask Visual Studio to copy it someplace else, the database will stay where it was when you browsed for it as shown above in Figure 2. In other words, the database *is* Northwnd.mdf, and it stays in the Data directory that is part of the samples.

- Charlie

Visual Linq query builder for Linq to Sql: VLinq

Mitsu's blog — Wed, 02 Apr 2008 12:29:33 GMT

Hi all, After almost one year of work and organization, I am very happy to share this project with you:

Visual Linq query builder pour Linq to Sql: VLinq

Mitsuru FURUTA - Microsoft FRANCE — Wed, 02 Apr 2008 13:03:15 GMT

Bonjour à tous, Après quasiment un an de travail et d'organisation, je suis très heureux de partager

Visual Linq query builder for Linq to Sql

The3Factory — Wed, 02 Apr 2008 16:18:34 GMT

Visual Linq query builder for Linq to Sql

Visual Linq query builder for Linq to Sql: VLinq

Vincent Yang — Wed, 02 Apr 2008 23:24:59 GMT

Ref:http://blogs.msdn.com/mitsu/archive/2008/04/02/visual-linq-query-builder-for-linq-to-sql-vlinq....

Lexapro anxiety.

Lexapro. — Tue, 26 Aug 2008 05:39:49 GMT

Lexapro side effects. Lexapro anxiety. Lexapro. Lexapro study.