CodeSmith Community

Hi, using Codesmith 4.0 and NietTiers latest build version as of today.

 I am trying to create a winforms application, I build the entire generated solution and it has no problems

I add a winforms project with 1 form and when I run any command in the service layer after creating an instance of it

 e.g. userService us = new UserService();

User user = us.GetByUserName("SSB");

I always get an exception could not load file or assembly Data.SqlClient or one of its dependendies. The System cannot find the file specified ...WindowsApplication2.vshost.exe.config in the DomainUtil.cs

I have created an app.config file in my windows application with all 3 sections I needed to add as per the report.html that is generated.

And added the Data, Enties and Service Dlls as references to my winforms project and in the using clause.

I have been trying all day without sucesss, any help or pointers would be welcome.

Regards

Satvinder

If anyone has a example csp file for the Northwind project with a winforms example app including app.config that would really help

 Cheers

 Satvinder

yes included that reference , still no luck

I ran my Codesmith against northwind using the following csp, app.config and windows form

 Northwind.csp

<?xml version="1.0"?>
<codeSmith xmlns="http://www.codesmithtools.com/schema/csp.xsd">
  <propertySets>
    <propertySet output="NetTiers.txt" template="C:\Program Files\NetTiers\netTiers2.0.1\NetTiers.cst">
      <property name="ExecuteSql">False</property>
      <property name="SQLFolderName">SQL</property>
      <property name="ViewReport">True</property>
      <property name="LaunchVisualStudio">False</property>
      <property name="IncludeUnitTest">None</property>
      <property name="IncludeComponentLayer">ServiceLayer</property>
      <property name="IncludeDatabaseFeatures">None</property>
      <property name="IncludeWCFDataAttributes">False</property>
      <property name="SerializeEntityState">False</property>
      <property name="IncludeXmlAttributes">False</property>
      <property name="CustomCodeFolderName">App_Code</property>
      <property name="BusinessLogicLayerNameSpace">Entities</property>
      <property name="DataAccessLayerNameSpace">Data</property>
      <property name="UnitTestsNameSpace">UnitTests</property>
      <property name="SignAssembly">False</property>
      <property name="GenerateWebLibrary">True</property>
      <property name="IncludeDesignTimeSupport">True</property>
      <property name="GenerateWebservice">False</property>
      <property name="AttemptCreateLocalVirtualDirectory">False</property>
      <property name="GenerateWebsite">False</property>
      <property name="UseWebAppProject">False</property>
      <property name="OverwriteWebConfig">False</property>
      <property name="IncludeAtlasLibrary">False</property>
      <property name="IncludeAtlasToolkit">False</property>
      <property name="GenerateWebsiteAdmin">False</property>
      <property name="WebAdminSiteName">Application Name</property>
      <property name="RetryEnabled">False</property>
      <property name="RetryMaxAttempts">5</property>
      <property name="RetrySleepTime">1000</property>
      <property name="IncludeCustoms">True</property>
      <property name="CustomNonMatchingReturnType">DataSet</property>
      <property name="IncludeDrop">True</property>
      <property name="IncludeInsert">True</property>
      <property name="IncludeUpdate">True</property>
      <property name="IncludeSave">True</property>
      <property name="IncludeDelete">True</property>
      <property name="IncludeGet">True</property>
      <property name="IncludeGetList">True</property>
      <property name="IncludeGetListByFK">True</property>
      <property name="IncludeGetListByIX">True</property>
      <property name="IncludeFind">True</property>
      <property name="IncludeManyToMany">True</property>
      <property name="IncludeRelations">True</property>
      <property name="IsolationLevel">None</property>
      <property name="InsertSuffix">_Insert</property>
      <property name="UpdateSuffix">_Update</property>
      <property name="DeleteSuffix">_Delete</property>
      <property name="SelectSuffix">_Get</property>
      <property name="SelectAllSuffix">_List</property>
      <property name="FindSuffix">_Find</property>
      <property name="GenerateWinLibrary">False</property>
      <property name="RootNameSpace">Northwind</property>
      <property name="OutputDirectory">c:\NetTiers\Northwind</property>
      <property name="MappingFile">c:\NetTiers\Northwind\NorthwindMapping.config</property>
      <property name="ComponentLayerNameSpace">Services</property>
      <property name="SourceTables">
        <connectionString>Data Source=Laptop\SUNNY;Initial Catalog=NorthWind;Persist Security Info=True;User ID=sa; password=walking;</connectionString>
        <providerType>SchemaExplorer.SqlSchemaProvider,SchemaExplorer.SqlSchemaProvider</providerType>
        <tableList>
      <table>
        <owner>dbo</owner>
        <name>Suppliers</name>
      </table>
      <table>
        <owner>dbo</owner>
        <name>Categories</name>
      </table>
      <table>
        <owner>dbo</owner>
        <name>Products</name>
      </table>
    </tableList>
      </property>
      <property name="WebServiceOutputPath">c:\NetTiers\Northwind\WebServices</property>
      <property name="WebServiceUrl">http://localhost/NorthwindServices</property>
      <property name="ChooseSourceDatabase">
        <connectionString>Data Source=Laptop\SUNNY;Initial Catalog=NorthWind;Persist Security Info=True;User ID=sa; password=walking;</connectionString>
        <providerType>SchemaExplorer.SqlSchemaProvider,SchemaExplorer.SqlSchemaProvider</providerType>
      </property>
      <property name="RetrySleepStyle">Constant</property>
      <property name="MethodNames">
        <MethodNamesProperty xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="">
      <Get>Get</Get>
      <GetAll>GetAll</GetAll>
      <GetPaged>GetPaged</GetPaged>
      <Find>Find</Find>
      <Insert>Insert</Insert>
      <Update>Update</Update>
      <Save>Save</Save>
      <Delete>Delete</Delete>
      <DeepLoad>DeepLoad</DeepLoad>
      <DeepSave>DeepSave</DeepSave>
      <GetTotalItems>GetTotalItems</GetTotalItems>
      <BulkInsert>BulkInsert</BulkInsert>
    </MethodNamesProperty>
      </property>
      <property name="StrippedTablePrefixes">tbl;tbl_</property>
      <property name="EntityFormat">{0}</property>
      <property name="CollectionFormat">{0}Collection</property>
      <property name="GenericViewFormat">VList&lt;{0}&gt;</property>
      <property name="GenericListFormat">TList&lt;{0}&gt;</property>
      <property name="ProviderFormat">{0}Provider</property>
      <property name="InterfaceFormat">I{0}</property>
      <property name="BaseClassFormat">{0}Base</property>
      <property name="EnumFormat">{0}List</property>
      <property name="ManyToManyFormat">{0}From{1}</property>
      <property name="ServiceClassNameFormat">{0}Service</property>
      <property name="ParseDbColDefaultVal">False</property>
      <property name="ChangeUnderscoreToPascalCase">False</property>
      <property name="AliasFilePath" />
      <property name="ProcedurePrefix" />
      <property name="CustomProcedureStartsWith">_{0}_</property>
      <property name="CSPUseDefaultValForNonNullableTypes">False</property>
    </propertySet>
  </propertySets>
</codeSmith>

App.Config

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
 <configSections>
  <section name="netTiersService"
      type="Northwind.Data.Bases.NetTiersServiceSection, Northwind.Data"
      allowDefinition="MachineToApplication"
      restartOnExternalChanges="true" />

 </configSections>
 <connectionStrings>
  <add name="netTiersConnectionString" connectionString="Data Source=Laptop\SUNNY;Initial Catalog=NorthWind;Persist Security Info=True;User ID=sa; password=walking;" />
 </connectionStrings>
 
 <netTiersService defaultProvider="SqlNetTiersProvider">
  <providers>

   <add
   name="SqlNetTiersProvider"
   type="Northwind.Data.SqlClient.SqlNetTiersProvider, Northwind.Data.SqlClient"
   connectionStringName="netTiersConnectionString"
   providerInvariantName="System.Data.SqlClient"
   entityFactoryType="Northwind.Entities.EntityFactory"
   useEntityFactory="true"
   enableEntityTracking="true"
   enableMethodAuthorization="false"
   useStoredProcedure="false"
  />

  </providers>
 </netTiersService>
</configuration> 

Form1.cs - has 1 button on form and thats it

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using Northwind.Data;
using Northwind.Entities;
using Northwind.Services;

namespace WindowsApplication1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            Northwind.Services.CategoriesService c = new CategoriesService();
            TList<Categories> cats = c.GetByCategoryName("Beverages");

        }
    }
} 

I feel so stupid....

 thank you for all your help, it works now.

Regards

Satvinder