<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://blogs.msdn.com/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Connect to a SQL Database and Use the LINQ to SQL Designer</title><link>http://blogs.msdn.com/b/charlie/archive/2007/11/19/connect-to-a-sql-database-and-use-the-sql-designer.aspx</link><description>To begin working with LINQ to SQL in Visual Studio 2008 you will need a database that you can query and a copy of MS SQL Server or SQL Express. In this post, I'm going to focus on SQL Express since it is free and since it gets installed by default when</description><dc:language>en</dc:language><generator>Telligent Evolution Platform Developer Build (Build: 5.6.50428.7875)</generator><item><title>re: Connect to a SQL Database and Use the LINQ to SQL Designer</title><link>http://blogs.msdn.com/b/charlie/archive/2007/11/19/connect-to-a-sql-database-and-use-the-sql-designer.aspx#10110570</link><pubDate>Fri, 31 Dec 2010 08:55:03 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:10110570</guid><dc:creator>anuj</dc:creator><description>&lt;p&gt;when i add the more than 1 table in dataclasses then it works only for 1 table not for other. should i add to multiple dataclasses for adding multiple table???&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=10110570" width="1" height="1"&gt;</description></item><item><title>re: Connect to a SQL Database and Use the LINQ to SQL Designer</title><link>http://blogs.msdn.com/b/charlie/archive/2007/11/19/connect-to-a-sql-database-and-use-the-sql-designer.aspx#10034855</link><pubDate>Tue, 06 Jul 2010 10:33:57 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:10034855</guid><dc:creator>Praveen</dc:creator><description>&lt;p&gt;Hello&lt;/p&gt;
&lt;p&gt;I want to know how will i connet to any table in the database dynamically when database having many thousands of tables because its not possible to craete a class entity for each table.&lt;/p&gt;
&lt;p&gt;Thanks&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=10034855" width="1" height="1"&gt;</description></item><item><title>Lexapro anxiety.</title><link>http://blogs.msdn.com/b/charlie/archive/2007/11/19/connect-to-a-sql-database-and-use-the-sql-designer.aspx#8895890</link><pubDate>Tue, 26 Aug 2008 05:39:49 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8895890</guid><dc:creator>Lexapro.</dc:creator><description>&lt;p&gt;Lexapro side effects. Lexapro anxiety. Lexapro. Lexapro study.&lt;/p&gt;
&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=8895890" width="1" height="1"&gt;</description></item><item><title>Visual Linq query builder for Linq to Sql: VLinq</title><link>http://blogs.msdn.com/b/charlie/archive/2007/11/19/connect-to-a-sql-database-and-use-the-sql-designer.aspx#8352323</link><pubDate>Wed, 02 Apr 2008 23:24:59 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8352323</guid><dc:creator>Vincent Yang</dc:creator><description>&lt;p&gt;Ref:&lt;a rel="nofollow" target="_new" href="http://blogs.msdn.com/mitsu/archive/2008/04/02/visual-linq-query-builder-for-linq-to-sql-vlinq"&gt;http://blogs.msdn.com/mitsu/archive/2008/04/02/visual-linq-query-builder-for-linq-to-sql-vlinq&lt;/a&gt;....&lt;/p&gt;
&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=8352323" width="1" height="1"&gt;</description></item><item><title>Visual Linq query builder for Linq to Sql</title><link>http://blogs.msdn.com/b/charlie/archive/2007/11/19/connect-to-a-sql-database-and-use-the-sql-designer.aspx#8351187</link><pubDate>Wed, 02 Apr 2008 16:18:34 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8351187</guid><dc:creator>The3Factory</dc:creator><description>&lt;p&gt;Visual Linq query builder for Linq to Sql&lt;/p&gt;
&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=8351187" width="1" height="1"&gt;</description></item><item><title>Visual Linq query builder pour Linq to Sql: VLinq</title><link>http://blogs.msdn.com/b/charlie/archive/2007/11/19/connect-to-a-sql-database-and-use-the-sql-designer.aspx#8350600</link><pubDate>Wed, 02 Apr 2008 13:03:15 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8350600</guid><dc:creator>Mitsuru FURUTA - Microsoft FRANCE</dc:creator><description>&lt;p&gt;Bonjour &amp;#224; tous, Apr&amp;#232;s quasiment un an de travail et d'organisation, je suis tr&amp;#232;s heureux de partager&lt;/p&gt;
&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=8350600" width="1" height="1"&gt;</description></item><item><title>Visual Linq query builder for Linq to Sql: VLinq</title><link>http://blogs.msdn.com/b/charlie/archive/2007/11/19/connect-to-a-sql-database-and-use-the-sql-designer.aspx#8350514</link><pubDate>Wed, 02 Apr 2008 12:29:33 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8350514</guid><dc:creator>Mitsu's blog</dc:creator><description>&lt;p&gt;Hi all, After almost one year of work and organization, I am very happy to share this project with you:&lt;/p&gt;
&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=8350514" width="1" height="1"&gt;</description></item><item><title>re: Connect to a SQL Database and Use the LINQ to SQL Designer</title><link>http://blogs.msdn.com/b/charlie/archive/2007/11/19/connect-to-a-sql-database-and-use-the-sql-designer.aspx#8324698</link><pubDate>Wed, 19 Mar 2008 07:49:02 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8324698</guid><dc:creator>Charlie Calvert</dc:creator><description>&lt;p&gt;Billy Bob,&lt;/p&gt;
&lt;p&gt;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.&lt;/p&gt;
&lt;p&gt;- Charlie&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=8324698" width="1" height="1"&gt;</description></item><item><title>re: Connect to a SQL Database and Use the LINQ to SQL Designer</title><link>http://blogs.msdn.com/b/charlie/archive/2007/11/19/connect-to-a-sql-database-and-use-the-sql-designer.aspx#8324693</link><pubDate>Wed, 19 Mar 2008 07:45:37 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8324693</guid><dc:creator>Charlie Calvert</dc:creator><description>&lt;p&gt;Pablo,&lt;/p&gt;
&lt;p&gt;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:&lt;/p&gt;
&lt;p&gt;DataClasses1DataContext db = &lt;/p&gt;
&lt;p&gt; &amp;nbsp;new DataClasses1DataContext(MyConnectionString);&lt;/p&gt;
&lt;p&gt;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.&lt;/p&gt;
&lt;p&gt;- Charlie&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=8324693" width="1" height="1"&gt;</description></item><item><title>re: Connect to a SQL Database and Use the LINQ to SQL Designer</title><link>http://blogs.msdn.com/b/charlie/archive/2007/11/19/connect-to-a-sql-database-and-use-the-sql-designer.aspx#7984440</link><pubDate>Sun, 02 Mar 2008 05:41:33 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:7984440</guid><dc:creator>billy bob</dc:creator><description>&lt;p&gt;A question:&lt;/p&gt;
&lt;p&gt;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.&lt;/p&gt;
&lt;p&gt;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.&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=7984440" width="1" height="1"&gt;</description></item></channel></rss>