<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://forums.lhotka.net/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>Search results matching tags 'Data portal', 'Visual Studio 2010', and 'Dal'</title><link>http://forums.lhotka.net/search/SearchResults.aspx?a=0&amp;o=DateDescending&amp;tag=Data+portal,Visual+Studio+2010,Dal&amp;orTags=0</link><description>Search results matching tags 'Data portal', 'Visual Studio 2010', and 'Dal'</description><dc:language>en-US</dc:language><generator>CommunityServer 2008.5 SP3 (Build: 36.8414)</generator><item><title>N-Tier application. Underlying connection was closed</title><link>http://forums.lhotka.net/forums/p/10377/48602.aspx#48602</link><pubDate>Tue, 17 May 2011 07:39:50 GMT</pubDate><guid isPermaLink="false">49a2225a-bd1e-4c5d-a665-720b81e87ca9:48602</guid><dc:creator>JacoM</dc:creator><description>&lt;p&gt;Hi, &lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;
&lt;p&gt;I&amp;#39;m new to the CSLA framework and I&amp;#39;m trying to write an N-Tier application so I can demo the framework to my company.&lt;/p&gt;
&lt;p&gt;I&amp;#39;m really struggling to get the data access working. I keep getting the &amp;quot;The underlying connection was closed: The connection was closed unexpectedly.&amp;quot; error every time I try to access a dataportal.fetch command.&lt;/p&gt;
&lt;p&gt;I&amp;#39;m using a windows forms UI and WcfHost.&lt;/p&gt;
&lt;p&gt;Here is some of the code in the app.config files and the web.config file. I&amp;#39;m really not even sure where to find the problem, so if more code is required just let me know.&lt;/p&gt;
&lt;p&gt;WindowsFormsUI app.config&lt;/p&gt;
&lt;p&gt;&amp;lt;code&amp;gt;&lt;/p&gt;
&lt;p&gt;&amp;lt;appSettings&amp;gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;add key=&amp;quot;CslaAuthentication&amp;quot; value=&amp;quot;Windows&amp;quot;/&amp;gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;add key=&amp;quot;CslaDataPortalProxy&amp;quot; value=&amp;quot;Csla.DataPortalClient.WcfProxy, Csla&amp;quot;/&amp;gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;add key =&amp;quot;CslaDataPortalUrl&amp;quot; value =&amp;quot;http://localhost:41337/WcfPortal.svc&amp;quot;/&amp;gt;&lt;br /&gt;&amp;nbsp; &amp;lt;/appSettings&amp;gt;&lt;br /&gt;&amp;nbsp; &amp;lt;connectionStrings&amp;gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;add name=&amp;quot;RIMS_PC&amp;quot; connectionString=&amp;quot;Data Source=.\SQLEXPRESS;AttachDbFilename=&amp;amp;quot;C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\RIMS_PC.mdf&amp;amp;quot;;Integrated Security=True;Connect Timeout=30;User Instance=True&amp;quot; providerName=&amp;quot;System.Data.SqlClient&amp;quot;/&amp;gt;&lt;br /&gt;&amp;nbsp; &amp;lt;/connectionStrings&amp;gt;&lt;/p&gt;
&lt;p&gt;&amp;lt;/code&amp;gt;&lt;/p&gt;
&lt;p&gt;DAL library app.coinfig&lt;/p&gt;
&lt;p&gt;&amp;lt;code&amp;gt;&lt;/p&gt;
&lt;p&gt;&amp;lt;connectionStrings&amp;gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;add name=&amp;quot;CSLAtester.DAL.Properties.Settings.RIMS_PCConnectionString&amp;quot;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; connectionString=&amp;quot;Data Source=.\SQLEXPRESS;AttachDbFilename=&amp;amp;quot;C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\RIMS_PC.mdf&amp;amp;quot;;Integrated Security=True;Connect Timeout=30;User Instance=True&amp;quot;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; providerName=&amp;quot;System.Data.SqlClient&amp;quot; /&amp;gt;&lt;br /&gt;&amp;nbsp; &amp;lt;/connectionStrings&amp;gt;&lt;/p&gt;
&lt;p&gt;&amp;lt;/code&amp;gt;&lt;/p&gt;
&lt;p&gt;WcfHost web.config&lt;/p&gt;
&lt;p&gt;&amp;lt;code&amp;gt;&lt;/p&gt;
&lt;p&gt;&amp;lt;connectionStrings&amp;gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;add name=&amp;quot;RIMS_PC&amp;quot; connectionString=&amp;quot;Data Source=.\SQLEXPRESS;AttachDbFilename=&amp;amp;quot;C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\RIMS_PC.mdf&amp;amp;quot;;Integrated Security=True;Connect Timeout=30;User Instance=True&amp;quot; providerName=&amp;quot;System.Data.SqlClient&amp;quot; /&amp;gt;&lt;br /&gt;&amp;nbsp; &amp;lt;/connectionStrings&amp;gt;&lt;br /&gt;&amp;nbsp; &amp;lt;system.serviceModel&amp;gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;serviceHostingEnvironment multipleSiteBindingsEnabled=&amp;quot;true&amp;quot; aspNetCompatibilityEnabled=&amp;quot;true&amp;quot;/&amp;gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;services&amp;gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;service name=&amp;quot;Csla.Server.Hosts.WcfPortal&amp;quot; behaviorConfiguration=&amp;quot;returnFaults&amp;quot;&amp;gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;endpoint contract=&amp;quot;Csla.Server.Hosts.IWcfPortal&amp;quot; binding=&amp;quot;wsHttpBinding&amp;quot;/&amp;gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/service&amp;gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;service behaviorConfiguration=&amp;quot;WcfPortalBehavior&amp;quot; name=&amp;quot;Csla.Server.Hosts.Silverlight.WcfPortal&amp;quot;&amp;gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;endpoint address=&amp;quot;&amp;quot; binding=&amp;quot;basicHttpBinding&amp;quot; contract=&amp;quot;Csla.Server.Hosts.Silverlight.IWcfPortal&amp;quot; bindingConfiguration=&amp;quot;basicHttpBinding_IWcfPortal&amp;quot;&amp;gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;identity&amp;gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;dns value=&amp;quot;localhost&amp;quot; /&amp;gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/identity&amp;gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/endpoint&amp;gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;endpoint address=&amp;quot;mex&amp;quot; binding=&amp;quot;mexHttpBinding&amp;quot; contract=&amp;quot;IMetadataExchange&amp;quot; /&amp;gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/service&amp;gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/services&amp;gt;&lt;/p&gt;
&lt;p&gt;&amp;lt;/code&amp;gt;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;
&lt;p&gt;I&amp;#39;m using CSLA 4.1 and VS 2010 and MS SQL server 2008 R2&lt;/p&gt;
&lt;p&gt;Any suggestions please&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;</description></item></channel></rss>