Como estou falando muito sobre o subsonic resolvi fazer um tuto para podermos iniciar o desenvolvimento com o mesmo:

1º Baixar o Subsonic http://www.subsonicproject.com/
PS. eu estou usando a versão 2.1 já existe a 3 mas nao gostei portanto esse tuto é para a versão 2.1

2º Colocar na referencia System.configuration, System.web, Subsonic e O do banco utilizado no meu caso MySql

3º o App.config


<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <configSections>
    <section name="SubSonicService" type="SubSonic.SubSonicSection, SubSonic" requirePermission="false" />
  </configSections>
  <appSettings>
    <add key="ClientSettingsProvider.ServiceUri" value="" />
  </appSettings>

  <connectionStrings>
    <clear />
    <add name="NOMECS" connectionString="SERVER=<IP>;DATABASE=<DB>;UID=<USER>;PASSWORD=<SENHA>;" />
  </connectionStrings>

  <SubSonicService defaultProvider="UM NOME">
    <providers>
      <clear />
      <add name="localhost" type="SubSonic.MySqlDataProvider,
 SubSonic" connectionStringName="NOMECS" generatedNamespace="VendasDeFichas" />
    </providers>
  </SubSonicService>

  <system.web>
    <membership defaultProvider="ClientAuthenticationMembershipProvider">
      <providers>
        <add name="ClientAuthenticationMembershipProvider" type="System.Web.ClientServices.Providers
.ClientFormsAuthenticationMembershipProvider, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" serviceUri="" />
      </providers>
    </membership>
    <roleManager defaultProvider="ClientRoleProvider" enabled="true">
      <providers>
        <add name="ClientRoleProvider" type="System.Web.ClientServices.Providers.ClientRoleProvider, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" serviceUri="" cacheTimeout="86400" />
      </providers>
    </roleManager>
  </system.web>
</configuration>

4° Instalar o subsonic… logo apos abrir o VS:
Tools>External Tools
Add
Title:&SubSonic DAL
Command: C:\Arquivos de programas\SubSonic\SubSonic 2.1 Final\SubCommander\sonic.exe
Arguments: generate /out Generated
Initial directory: $(ProjectDir)
Marcar > Use Output Window

OK ja instalamos o subsonic no VS… agora vamos trabalhar…

Posts Relacionados