LINQ to SQL model

1. Prisidėti papildomą projekta "Class library"
2. Pridėti LINQ to SQL model ir jį sukonfiguruoti
3. Konfiguruojant keisti namespace ir sutvarkyti connection string

4. Sukūrus projektą, jį dar reikia pridėti prie web projekto

5. Į web.config įdedame

      
< add name="DiscountDB" connectionString="Data Source=aaa;Initial Catalog=bbb;Persist Security Info=True;User ID=ccc;Password=ddd" providerName="System.Data.SqlClient"/>






       
<assemblies>

<

add assembly="System.Data.Linq, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>

</

assemblies>
   
6. Galiausiai galime naudoti:
        Dim odb As New ExportDB.DataContext
        Dim obj = From a In odb.MainGroups
7. Sukuriame naują vb failą, konfiguravimui
Namespace My

    Partial Friend NotInheritable Class MySettings

        Private Sub MySettings_SettingsLoaded(ByVal sender As Object, ByVal e As System.Configuration.SettingsLoadedEventArgs) Handles Me.SettingsLoaded

            Me.Item("DiscountConnectionString") = Configuration.ConfigurationManager.ConnectionStrings("DiscountDB").ConnectionString

            Me.Item("PriceListConnectionString") = Configuration.ConfigurationManager.ConnectionStrings("PriceListDB").ConnectionString

        End Sub

    End Class

End Namespace