'------------------------------------------------------------------------------
' <auto-generated>
'     This code was generated by a tool.
'     Runtime Version:2.0.50727.42
'
'     Changes to this file may cause incorrect behavior and will be lost if
'     the code is regenerated.
' </auto-generated>
'------------------------------------------------------------------------------

Option Strict Off
Option Explicit On

Imports System
Imports System.Data

'
'This source code was auto-generated by Microsoft.CompactFramework.Design.Data, Version 2.0.50727.42.
'

<System.ComponentModel.DesignerCategoryAttribute("code"),  _
 System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedDataSetSchema"),  _
 System.Xml.Serialization.XmlRootAttribute("SmartEstateDataSet")>  _
Partial Public Class SmartEstateDataSet
    Inherits System.Data.DataSet
    
    Private tableAgenti As AgentiDataTable
    
    Private tableClienti As ClientiDataTable
    
    Private tableImmobili As ImmobiliDataTable
    
    Private tablePreventivi As PreventiviDataTable
    
    Private relationFK__Preventiv__IdAge__1B0907CE As System.Data.DataRelation
    
    Private relationFK__Preventiv__IdCli__1920BF5C As System.Data.DataRelation
    
    Private relationFK__Preventiv__IdImm__1BFD2C07 As System.Data.DataRelation
    
    Private _schemaSerializationMode As System.Data.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema
    
    <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
    Public Sub New()
        MyBase.New
        Me.BeginInit
        Me.InitClass
        Dim schemaChangedHandler As System.ComponentModel.CollectionChangeEventHandler = AddressOf Me.SchemaChanged
        AddHandler MyBase.Tables.CollectionChanged, schemaChangedHandler
        AddHandler MyBase.Relations.CollectionChanged, schemaChangedHandler
        Me.EndInit
    End Sub
    
    <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
    Public ReadOnly Property Agenti() As AgentiDataTable
        Get
            Return Me.tableAgenti
        End Get
    End Property
    
    <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
    Public ReadOnly Property Clienti() As ClientiDataTable
        Get
            Return Me.tableClienti
        End Get
    End Property
    
    <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
    Public ReadOnly Property Immobili() As ImmobiliDataTable
        Get
            Return Me.tableImmobili
        End Get
    End Property
    
    <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
    Public ReadOnly Property Preventivi() As PreventiviDataTable
        Get
            Return Me.tablePreventivi
        End Get
    End Property
    
    <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
    Public Overrides Property SchemaSerializationMode() As System.Data.SchemaSerializationMode
        Get
            Return Me._schemaSerializationMode
        End Get
        Set
            Me._schemaSerializationMode = value
        End Set
    End Property
    
    <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
    Public Shadows ReadOnly Property Tables() As System.Data.DataTableCollection
        Get
            Return MyBase.Tables
        End Get
    End Property
    
    <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
    Public Shadows ReadOnly Property Relations() As System.Data.DataRelationCollection
        Get
            Return MyBase.Relations
        End Get
    End Property
    
    <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
    Protected Overrides Sub InitializeDerivedDataSet()
        Me.BeginInit
        Me.InitClass
        Me.EndInit
    End Sub
    
    <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
    Public Overrides Function Clone() As System.Data.DataSet
        Dim cln As SmartEstateDataSet = CType(MyBase.Clone,SmartEstateDataSet)
        cln.InitVars
        cln.SchemaSerializationMode = Me.SchemaSerializationMode
        Return cln
    End Function
    
    <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
    Protected Overrides Function ShouldSerializeTables() As Boolean
        Return false
    End Function
    
    <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
    Protected Overrides Function ShouldSerializeRelations() As Boolean
        Return false
    End Function
    
    <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
    Protected Overrides Sub ReadXmlSerializable(ByVal reader As System.Xml.XmlReader)
        If (Me.DetermineSchemaSerializationMode(reader) = System.Data.SchemaSerializationMode.IncludeSchema) Then
            Me.Reset
            Dim ds As System.Data.DataSet = New System.Data.DataSet
            ds.ReadXml(reader)
            If (Not (ds.Tables("Agenti")) Is Nothing) Then
                MyBase.Tables.Add(New AgentiDataTable(ds.Tables("Agenti")))
            End If
            If (Not (ds.Tables("Clienti")) Is Nothing) Then
                MyBase.Tables.Add(New ClientiDataTable(ds.Tables("Clienti")))
            End If
            If (Not (ds.Tables("Immobili")) Is Nothing) Then
                MyBase.Tables.Add(New ImmobiliDataTable(ds.Tables("Immobili")))
            End If
            If (Not (ds.Tables("Preventivi")) Is Nothing) Then
                MyBase.Tables.Add(New PreventiviDataTable(ds.Tables("Preventivi")))
            End If
            Me.DataSetName = ds.DataSetName
            Me.Prefix = ds.Prefix
            Me.Namespace = ds.Namespace
            Me.Locale = ds.Locale
            Me.CaseSensitive = ds.CaseSensitive
            Me.EnforceConstraints = ds.EnforceConstraints
            Me.Merge(ds, false, System.Data.MissingSchemaAction.Add)
            Me.InitVars
        Else
            Me.ReadXml(reader)
            Me.InitVars
        End If
    End Sub
    
    <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
    Protected Overrides Function GetSchemaSerializable() As System.Xml.Schema.XmlSchema
        Dim stream As System.IO.MemoryStream = New System.IO.MemoryStream
        Me.WriteXmlSchema(New System.Xml.XmlTextWriter(stream, Nothing))
        stream.Position = 0
        Return System.Xml.Schema.XmlSchema.Read(New System.Xml.XmlTextReader(stream), Nothing)
    End Function
    
    <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
    Friend Overloads Sub InitVars()
        Me.InitVars(true)
    End Sub
    
    <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
    Friend Overloads Sub InitVars(ByVal initTable As Boolean)
        Me.tableAgenti = CType(MyBase.Tables("Agenti"),AgentiDataTable)
        If (initTable = true) Then
            If (Not (Me.tableAgenti) Is Nothing) Then
                Me.tableAgenti.InitVars
            End If
        End If
        Me.tableClienti = CType(MyBase.Tables("Clienti"),ClientiDataTable)
        If (initTable = true) Then
            If (Not (Me.tableClienti) Is Nothing) Then
                Me.tableClienti.InitVars
            End If
        End If
        Me.tableImmobili = CType(MyBase.Tables("Immobili"),ImmobiliDataTable)
        If (initTable = true) Then
            If (Not (Me.tableImmobili) Is Nothing) Then
                Me.tableImmobili.InitVars
            End If
        End If
        Me.tablePreventivi = CType(MyBase.Tables("Preventivi"),PreventiviDataTable)
        If (initTable = true) Then
            If (Not (Me.tablePreventivi) Is Nothing) Then
                Me.tablePreventivi.InitVars
            End If
        End If
        Me.relationFK__Preventiv__IdAge__1B0907CE = Me.Relations("FK__Preventiv__IdAge__1B0907CE")
        Me.relationFK__Preventiv__IdCli__1920BF5C = Me.Relations("FK__Preventiv__IdCli__1920BF5C")
        Me.relationFK__Preventiv__IdImm__1BFD2C07 = Me.Relations("FK__Preventiv__IdImm__1BFD2C07")
    End Sub
    
    <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
    Private Sub InitClass()
        Me.DataSetName = "SmartEstateDataSet"
        Me.Prefix = ""
        Me.Namespace = "http://tempuri.org/SmartEstateDataSet.xsd"
        Me.EnforceConstraints = true
        Me.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema
        Me.tableAgenti = New AgentiDataTable
        MyBase.Tables.Add(Me.tableAgenti)
        Me.tableClienti = New ClientiDataTable
        MyBase.Tables.Add(Me.tableClienti)
        Me.tableImmobili = New ImmobiliDataTable
        MyBase.Tables.Add(Me.tableImmobili)
        Me.tablePreventivi = New PreventiviDataTable
        MyBase.Tables.Add(Me.tablePreventivi)
        Me.relationFK__Preventiv__IdAge__1B0907CE = New System.Data.DataRelation("FK__Preventiv__IdAge__1B0907CE", New System.Data.DataColumn() {Me.tableAgenti.IdAgenteColumn}, New System.Data.DataColumn() {Me.tablePreventivi.IdAgenteColumn}, false)
        Me.Relations.Add(Me.relationFK__Preventiv__IdAge__1B0907CE)
        Me.relationFK__Preventiv__IdCli__1920BF5C = New System.Data.DataRelation("FK__Preventiv__IdCli__1920BF5C", New System.Data.DataColumn() {Me.tableClienti.IdClienteColumn}, New System.Data.DataColumn() {Me.tablePreventivi.IdClienteColumn}, false)
        Me.Relations.Add(Me.relationFK__Preventiv__IdCli__1920BF5C)
        Me.relationFK__Preventiv__IdImm__1BFD2C07 = New System.Data.DataRelation("FK__Preventiv__IdImm__1BFD2C07", New System.Data.DataColumn() {Me.tableImmobili.IdImmobileColumn}, New System.Data.DataColumn() {Me.tablePreventivi.IdImmobileColumn}, false)
        Me.Relations.Add(Me.relationFK__Preventiv__IdImm__1BFD2C07)
    End Sub
    
    <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
    Private Function ShouldSerializeAgenti() As Boolean
        Return false
    End Function
    
    <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
    Private Function ShouldSerializeClienti() As Boolean
        Return false
    End Function
    
    <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
    Private Function ShouldSerializeImmobili() As Boolean
        Return false
    End Function
    
    <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
    Private Function ShouldSerializePreventivi() As Boolean
        Return false
    End Function
    
    <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
    Private Sub SchemaChanged(ByVal sender As Object, ByVal e As System.ComponentModel.CollectionChangeEventArgs)
        If (e.Action = System.ComponentModel.CollectionChangeAction.Remove) Then
            Me.InitVars
        End If
    End Sub
    
    <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
    Public Shared Function GetTypedDataSetSchema(ByVal xs As System.Xml.Schema.XmlSchemaSet) As System.Xml.Schema.XmlSchemaComplexType
        Dim ds As SmartEstateDataSet = New SmartEstateDataSet
        Dim type As System.Xml.Schema.XmlSchemaComplexType = New System.Xml.Schema.XmlSchemaComplexType
        Dim sequence As System.Xml.Schema.XmlSchemaSequence = New System.Xml.Schema.XmlSchemaSequence
        xs.Add(ds.GetSchemaSerializable)
        Dim any As System.Xml.Schema.XmlSchemaAny = New System.Xml.Schema.XmlSchemaAny
        any.Namespace = ds.Namespace
        sequence.Items.Add(any)
        type.Particle = sequence
        Return type
    End Function
    
    Public Delegate Sub AgentiRowChangeEventHandler(ByVal sender As Object, ByVal e As AgentiRowChangeEvent)
    
    Public Delegate Sub ClientiRowChangeEventHandler(ByVal sender As Object, ByVal e As ClientiRowChangeEvent)
    
    Public Delegate Sub ImmobiliRowChangeEventHandler(ByVal sender As Object, ByVal e As ImmobiliRowChangeEvent)
    
    Public Delegate Sub PreventiviRowChangeEventHandler(ByVal sender As Object, ByVal e As PreventiviRowChangeEvent)
    
    <System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedTableSchema")>  _
    Partial Public Class AgentiDataTable
        Inherits System.Data.DataTable
        Implements System.Collections.IEnumerable
        
        Private columnIdAgente As System.Data.DataColumn
        
        Private columnIndirizzo As System.Data.DataColumn
        
        Private columnCAP As System.Data.DataColumn
        
        Private columnCitta As System.Data.DataColumn
        
        Private columnIdAgenzia As System.Data.DataColumn
        
        Private columnTelefonoNumero As System.Data.DataColumn
        
        Private columnNome As System.Data.DataColumn
        
        Private columnTelefonoPrefisso As System.Data.DataColumn
        
        Private columnCognome As System.Data.DataColumn
        
        Private columnEmail As System.Data.DataColumn
        
        Private columnSysDataInsert As System.Data.DataColumn
        
        Private columnSysIdUtenteInsert As System.Data.DataColumn
        
        Private columnSysDataUpdate As System.Data.DataColumn
        
        Private columnSysIdUtenteUpdate As System.Data.DataColumn
        
        Private columnSysGUID As System.Data.DataColumn
        
        Private columnrowguid As System.Data.DataColumn
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub New()
            MyBase.New
            Me.TableName = "Agenti"
            Me.BeginInit
            Me.InitClass
            Me.EndInit
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Friend Sub New(ByVal table As System.Data.DataTable)
            MyBase.New
            Me.TableName = table.TableName
            If (table.CaseSensitive <> table.DataSet.CaseSensitive) Then
                Me.CaseSensitive = table.CaseSensitive
            End If
            If (table.Locale.ToString <> table.DataSet.Locale.ToString) Then
                Me.Locale = table.Locale
            End If
            If (table.Namespace <> table.DataSet.Namespace) Then
                Me.Namespace = table.Namespace
            End If
            Me.Prefix = table.Prefix
            Me.MinimumCapacity = table.MinimumCapacity
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property IdAgenteColumn() As System.Data.DataColumn
            Get
                Return Me.columnIdAgente
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property IndirizzoColumn() As System.Data.DataColumn
            Get
                Return Me.columnIndirizzo
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property CAPColumn() As System.Data.DataColumn
            Get
                Return Me.columnCAP
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property CittaColumn() As System.Data.DataColumn
            Get
                Return Me.columnCitta
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property IdAgenziaColumn() As System.Data.DataColumn
            Get
                Return Me.columnIdAgenzia
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property TelefonoNumeroColumn() As System.Data.DataColumn
            Get
                Return Me.columnTelefonoNumero
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property NomeColumn() As System.Data.DataColumn
            Get
                Return Me.columnNome
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property TelefonoPrefissoColumn() As System.Data.DataColumn
            Get
                Return Me.columnTelefonoPrefisso
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property CognomeColumn() As System.Data.DataColumn
            Get
                Return Me.columnCognome
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property EmailColumn() As System.Data.DataColumn
            Get
                Return Me.columnEmail
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property SysDataInsertColumn() As System.Data.DataColumn
            Get
                Return Me.columnSysDataInsert
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property SysIdUtenteInsertColumn() As System.Data.DataColumn
            Get
                Return Me.columnSysIdUtenteInsert
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property SysDataUpdateColumn() As System.Data.DataColumn
            Get
                Return Me.columnSysDataUpdate
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property SysIdUtenteUpdateColumn() As System.Data.DataColumn
            Get
                Return Me.columnSysIdUtenteUpdate
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property SysGUIDColumn() As System.Data.DataColumn
            Get
                Return Me.columnSysGUID
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property rowguidColumn() As System.Data.DataColumn
            Get
                Return Me.columnrowguid
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property Count() As Integer
            Get
                Return Me.Rows.Count
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Default ReadOnly Property Item(ByVal index As Integer) As AgentiRow
            Get
                Return CType(Me.Rows(index),AgentiRow)
            End Get
        End Property
        
        Public Event AgentiRowChanging As AgentiRowChangeEventHandler
        
        Public Event AgentiRowChanged As AgentiRowChangeEventHandler
        
        Public Event AgentiRowDeleting As AgentiRowChangeEventHandler
        
        Public Event AgentiRowDeleted As AgentiRowChangeEventHandler
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Overloads Sub AddAgentiRow(ByVal row As AgentiRow)
            Me.Rows.Add(row)
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Overloads Function AddAgentiRow(ByVal Indirizzo As String, ByVal CAP As String, ByVal Citta As String, ByVal IdAgenzia As Integer, ByVal TelefonoNumero As String, ByVal Nome As String, ByVal TelefonoPrefisso As String, ByVal Cognome As String, ByVal Email As String, ByVal SysDataInsert As Date, ByVal SysIdUtenteInsert As String, ByVal SysDataUpdate As Date, ByVal SysIdUtenteUpdate As String, ByVal SysGUID As System.Guid, ByVal rowguid As System.Guid) As AgentiRow
            Dim rowAgentiRow As AgentiRow = CType(Me.NewRow,AgentiRow)
            rowAgentiRow.ItemArray = New Object() {Nothing, Indirizzo, CAP, Citta, IdAgenzia, TelefonoNumero, Nome, TelefonoPrefisso, Cognome, Email, SysDataInsert, SysIdUtenteInsert, SysDataUpdate, SysIdUtenteUpdate, SysGUID, rowguid}
            Me.Rows.Add(rowAgentiRow)
            Return rowAgentiRow
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Function FindByIdAgenterowguid(ByVal IdAgente As Integer, ByVal rowguid As System.Guid) As AgentiRow
            Return CType(Me.Rows.Find(New Object() {IdAgente, rowguid}),AgentiRow)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Overridable Function GetEnumerator() As System.Collections.IEnumerator Implements System.Collections.IEnumerable.GetEnumerator
            Return Me.Rows.GetEnumerator
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Overrides Function Clone() As System.Data.DataTable
            Dim cln As AgentiDataTable = CType(MyBase.Clone,AgentiDataTable)
            cln.InitVars
            Return cln
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Protected Overrides Function CreateInstance() As System.Data.DataTable
            Return New AgentiDataTable
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Friend Sub InitVars()
            Me.columnIdAgente = MyBase.Columns("IdAgente")
            Me.columnIndirizzo = MyBase.Columns("Indirizzo")
            Me.columnCAP = MyBase.Columns("CAP")
            Me.columnCitta = MyBase.Columns("Citta")
            Me.columnIdAgenzia = MyBase.Columns("IdAgenzia")
            Me.columnTelefonoNumero = MyBase.Columns("TelefonoNumero")
            Me.columnNome = MyBase.Columns("Nome")
            Me.columnTelefonoPrefisso = MyBase.Columns("TelefonoPrefisso")
            Me.columnCognome = MyBase.Columns("Cognome")
            Me.columnEmail = MyBase.Columns("Email")
            Me.columnSysDataInsert = MyBase.Columns("SysDataInsert")
            Me.columnSysIdUtenteInsert = MyBase.Columns("SysIdUtenteInsert")
            Me.columnSysDataUpdate = MyBase.Columns("SysDataUpdate")
            Me.columnSysIdUtenteUpdate = MyBase.Columns("SysIdUtenteUpdate")
            Me.columnSysGUID = MyBase.Columns("SysGUID")
            Me.columnrowguid = MyBase.Columns("rowguid")
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Private Sub InitClass()
            Me.columnIdAgente = New System.Data.DataColumn("IdAgente", GetType(Integer), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnIdAgente)
            Me.columnIndirizzo = New System.Data.DataColumn("Indirizzo", GetType(String), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnIndirizzo)
            Me.columnCAP = New System.Data.DataColumn("CAP", GetType(String), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnCAP)
            Me.columnCitta = New System.Data.DataColumn("Citta", GetType(String), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnCitta)
            Me.columnIdAgenzia = New System.Data.DataColumn("IdAgenzia", GetType(Integer), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnIdAgenzia)
            Me.columnTelefonoNumero = New System.Data.DataColumn("TelefonoNumero", GetType(String), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnTelefonoNumero)
            Me.columnNome = New System.Data.DataColumn("Nome", GetType(String), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnNome)
            Me.columnTelefonoPrefisso = New System.Data.DataColumn("TelefonoPrefisso", GetType(String), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnTelefonoPrefisso)
            Me.columnCognome = New System.Data.DataColumn("Cognome", GetType(String), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnCognome)
            Me.columnEmail = New System.Data.DataColumn("Email", GetType(String), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnEmail)
            Me.columnSysDataInsert = New System.Data.DataColumn("SysDataInsert", GetType(Date), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnSysDataInsert)
            Me.columnSysIdUtenteInsert = New System.Data.DataColumn("SysIdUtenteInsert", GetType(String), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnSysIdUtenteInsert)
            Me.columnSysDataUpdate = New System.Data.DataColumn("SysDataUpdate", GetType(Date), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnSysDataUpdate)
            Me.columnSysIdUtenteUpdate = New System.Data.DataColumn("SysIdUtenteUpdate", GetType(String), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnSysIdUtenteUpdate)
            Me.columnSysGUID = New System.Data.DataColumn("SysGUID", GetType(System.Guid), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnSysGUID)
            Me.columnrowguid = New System.Data.DataColumn("rowguid", GetType(System.Guid), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnrowguid)
            Me.Constraints.Add(New System.Data.UniqueConstraint("Constraint1", New System.Data.DataColumn() {Me.columnIdAgente, Me.columnrowguid}, true))
            Me.columnIdAgente.AutoIncrement = true
            Me.columnIdAgente.AllowDBNull = false
            Me.columnIdAgente.ReadOnly = true
            Me.columnIndirizzo.MaxLength = 200
            Me.columnCAP.AllowDBNull = false
            Me.columnCAP.MaxLength = 5
            Me.columnCitta.MaxLength = 200
            Me.columnTelefonoNumero.MaxLength = 200
            Me.columnNome.MaxLength = 200
            Me.columnTelefonoPrefisso.MaxLength = 200
            Me.columnCognome.MaxLength = 200
            Me.columnEmail.MaxLength = 200
            Me.columnSysIdUtenteInsert.MaxLength = 40
            Me.columnSysIdUtenteUpdate.MaxLength = 40
            Me.columnrowguid.AllowDBNull = false
            Me.columnrowguid.ReadOnly = true
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Function NewAgentiRow() As AgentiRow
            Return CType(Me.NewRow,AgentiRow)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Protected Overrides Function NewRowFromBuilder(ByVal builder As System.Data.DataRowBuilder) As System.Data.DataRow
            Return New AgentiRow(builder)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Protected Overrides Function GetRowType() As System.Type
            Return GetType(AgentiRow)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Protected Overrides Sub OnRowChanged(ByVal e As System.Data.DataRowChangeEventArgs)
            MyBase.OnRowChanged(e)
            If (Not (Me.AgentiRowChangedEvent) Is Nothing) Then
                RaiseEvent AgentiRowChanged(Me, New AgentiRowChangeEvent(CType(e.Row,AgentiRow), e.Action))
            End If
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Protected Overrides Sub OnRowChanging(ByVal e As System.Data.DataRowChangeEventArgs)
            MyBase.OnRowChanging(e)
            If (Not (Me.AgentiRowChangingEvent) Is Nothing) Then
                RaiseEvent AgentiRowChanging(Me, New AgentiRowChangeEvent(CType(e.Row,AgentiRow), e.Action))
            End If
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Protected Overrides Sub OnRowDeleted(ByVal e As System.Data.DataRowChangeEventArgs)
            MyBase.OnRowDeleted(e)
            If (Not (Me.AgentiRowDeletedEvent) Is Nothing) Then
                RaiseEvent AgentiRowDeleted(Me, New AgentiRowChangeEvent(CType(e.Row,AgentiRow), e.Action))
            End If
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Protected Overrides Sub OnRowDeleting(ByVal e As System.Data.DataRowChangeEventArgs)
            MyBase.OnRowDeleting(e)
            If (Not (Me.AgentiRowDeletingEvent) Is Nothing) Then
                RaiseEvent AgentiRowDeleting(Me, New AgentiRowChangeEvent(CType(e.Row,AgentiRow), e.Action))
            End If
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub RemoveAgentiRow(ByVal row As AgentiRow)
            Me.Rows.Remove(row)
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Shared Function GetTypedTableSchema(ByVal xs As System.Xml.Schema.XmlSchemaSet) As System.Xml.Schema.XmlSchemaComplexType
            Dim type As System.Xml.Schema.XmlSchemaComplexType = New System.Xml.Schema.XmlSchemaComplexType
            Dim sequence As System.Xml.Schema.XmlSchemaSequence = New System.Xml.Schema.XmlSchemaSequence
            Dim ds As SmartEstateDataSet = New SmartEstateDataSet
            xs.Add(ds.GetSchemaSerializable)
            Dim any1 As System.Xml.Schema.XmlSchemaAny = New System.Xml.Schema.XmlSchemaAny
            any1.Namespace = "http://www.w3.org/2001/XMLSchema"
            any1.MinOccurs = New Decimal(0)
            any1.MaxOccurs = Decimal.MaxValue
            any1.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax
            sequence.Items.Add(any1)
            Dim any2 As System.Xml.Schema.XmlSchemaAny = New System.Xml.Schema.XmlSchemaAny
            any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1"
            any2.MinOccurs = New Decimal(1)
            any2.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax
            sequence.Items.Add(any2)
            Dim attribute1 As System.Xml.Schema.XmlSchemaAttribute = New System.Xml.Schema.XmlSchemaAttribute
            attribute1.Name = "namespace"
            attribute1.FixedValue = ds.Namespace
            type.Attributes.Add(attribute1)
            Dim attribute2 As System.Xml.Schema.XmlSchemaAttribute = New System.Xml.Schema.XmlSchemaAttribute
            attribute2.Name = "tableTypeName"
            attribute2.FixedValue = "AgentiDataTable"
            type.Attributes.Add(attribute2)
            type.Particle = sequence
            Return type
        End Function
    End Class
    
    <System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedTableSchema")>  _
    Partial Public Class ClientiDataTable
        Inherits System.Data.DataTable
        Implements System.Collections.IEnumerable
        
        Private columnIdCliente As System.Data.DataColumn
        
        Private columnIdAgenzia As System.Data.DataColumn
        
        Private columnNome As System.Data.DataColumn
        
        Private columnCognome As System.Data.DataColumn
        
        Private columnIndirizzo As System.Data.DataColumn
        
        Private columnCAP As System.Data.DataColumn
        
        Private columnCitta As System.Data.DataColumn
        
        Private columnTelefonoPrefisso As System.Data.DataColumn
        
        Private columnTelefonoNumero As System.Data.DataColumn
        
        Private columnrowguid As System.Data.DataColumn
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub New()
            MyBase.New
            Me.TableName = "Clienti"
            Me.BeginInit
            Me.InitClass
            Me.EndInit
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Friend Sub New(ByVal table As System.Data.DataTable)
            MyBase.New
            Me.TableName = table.TableName
            If (table.CaseSensitive <> table.DataSet.CaseSensitive) Then
                Me.CaseSensitive = table.CaseSensitive
            End If
            If (table.Locale.ToString <> table.DataSet.Locale.ToString) Then
                Me.Locale = table.Locale
            End If
            If (table.Namespace <> table.DataSet.Namespace) Then
                Me.Namespace = table.Namespace
            End If
            Me.Prefix = table.Prefix
            Me.MinimumCapacity = table.MinimumCapacity
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property IdClienteColumn() As System.Data.DataColumn
            Get
                Return Me.columnIdCliente
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property IdAgenziaColumn() As System.Data.DataColumn
            Get
                Return Me.columnIdAgenzia
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property NomeColumn() As System.Data.DataColumn
            Get
                Return Me.columnNome
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property CognomeColumn() As System.Data.DataColumn
            Get
                Return Me.columnCognome
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property IndirizzoColumn() As System.Data.DataColumn
            Get
                Return Me.columnIndirizzo
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property CAPColumn() As System.Data.DataColumn
            Get
                Return Me.columnCAP
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property CittaColumn() As System.Data.DataColumn
            Get
                Return Me.columnCitta
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property TelefonoPrefissoColumn() As System.Data.DataColumn
            Get
                Return Me.columnTelefonoPrefisso
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property TelefonoNumeroColumn() As System.Data.DataColumn
            Get
                Return Me.columnTelefonoNumero
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property rowguidColumn() As System.Data.DataColumn
            Get
                Return Me.columnrowguid
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property Count() As Integer
            Get
                Return Me.Rows.Count
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Default ReadOnly Property Item(ByVal index As Integer) As ClientiRow
            Get
                Return CType(Me.Rows(index),ClientiRow)
            End Get
        End Property
        
        Public Event ClientiRowChanging As ClientiRowChangeEventHandler
        
        Public Event ClientiRowChanged As ClientiRowChangeEventHandler
        
        Public Event ClientiRowDeleting As ClientiRowChangeEventHandler
        
        Public Event ClientiRowDeleted As ClientiRowChangeEventHandler
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Overloads Sub AddClientiRow(ByVal row As ClientiRow)
            Me.Rows.Add(row)
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Overloads Function AddClientiRow(ByVal IdAgenzia As Integer, ByVal Nome As String, ByVal Cognome As String, ByVal Indirizzo As String, ByVal CAP As String, ByVal Citta As String, ByVal TelefonoPrefisso As String, ByVal TelefonoNumero As String, ByVal rowguid As System.Guid) As ClientiRow
            Dim rowClientiRow As ClientiRow = CType(Me.NewRow,ClientiRow)
            rowClientiRow.ItemArray = New Object() {Nothing, IdAgenzia, Nome, Cognome, Indirizzo, CAP, Citta, TelefonoPrefisso, TelefonoNumero, rowguid}
            Me.Rows.Add(rowClientiRow)
            Return rowClientiRow
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Function FindByIdClienterowguid(ByVal IdCliente As Integer, ByVal rowguid As System.Guid) As ClientiRow
            Return CType(Me.Rows.Find(New Object() {IdCliente, rowguid}),ClientiRow)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Overridable Function GetEnumerator() As System.Collections.IEnumerator Implements System.Collections.IEnumerable.GetEnumerator
            Return Me.Rows.GetEnumerator
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Overrides Function Clone() As System.Data.DataTable
            Dim cln As ClientiDataTable = CType(MyBase.Clone,ClientiDataTable)
            cln.InitVars
            Return cln
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Protected Overrides Function CreateInstance() As System.Data.DataTable
            Return New ClientiDataTable
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Friend Sub InitVars()
            Me.columnIdCliente = MyBase.Columns("IdCliente")
            Me.columnIdAgenzia = MyBase.Columns("IdAgenzia")
            Me.columnNome = MyBase.Columns("Nome")
            Me.columnCognome = MyBase.Columns("Cognome")
            Me.columnIndirizzo = MyBase.Columns("Indirizzo")
            Me.columnCAP = MyBase.Columns("CAP")
            Me.columnCitta = MyBase.Columns("Citta")
            Me.columnTelefonoPrefisso = MyBase.Columns("TelefonoPrefisso")
            Me.columnTelefonoNumero = MyBase.Columns("TelefonoNumero")
            Me.columnrowguid = MyBase.Columns("rowguid")
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Private Sub InitClass()
            Me.columnIdCliente = New System.Data.DataColumn("IdCliente", GetType(Integer), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnIdCliente)
            Me.columnIdAgenzia = New System.Data.DataColumn("IdAgenzia", GetType(Integer), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnIdAgenzia)
            Me.columnNome = New System.Data.DataColumn("Nome", GetType(String), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnNome)
            Me.columnCognome = New System.Data.DataColumn("Cognome", GetType(String), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnCognome)
            Me.columnIndirizzo = New System.Data.DataColumn("Indirizzo", GetType(String), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnIndirizzo)
            Me.columnCAP = New System.Data.DataColumn("CAP", GetType(String), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnCAP)
            Me.columnCitta = New System.Data.DataColumn("Citta", GetType(String), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnCitta)
            Me.columnTelefonoPrefisso = New System.Data.DataColumn("TelefonoPrefisso", GetType(String), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnTelefonoPrefisso)
            Me.columnTelefonoNumero = New System.Data.DataColumn("TelefonoNumero", GetType(String), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnTelefonoNumero)
            Me.columnrowguid = New System.Data.DataColumn("rowguid", GetType(System.Guid), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnrowguid)
            Me.Constraints.Add(New System.Data.UniqueConstraint("Constraint1", New System.Data.DataColumn() {Me.columnIdCliente, Me.columnrowguid}, true))
            Me.columnIdCliente.AutoIncrement = true
            Me.columnIdCliente.AllowDBNull = false
            Me.columnIdCliente.ReadOnly = true
            Me.columnIdAgenzia.AllowDBNull = false
            Me.columnNome.MaxLength = 200
            Me.columnCognome.MaxLength = 200
            Me.columnIndirizzo.MaxLength = 200
            Me.columnCAP.MaxLength = 200
            Me.columnCitta.MaxLength = 200
            Me.columnTelefonoPrefisso.MaxLength = 200
            Me.columnTelefonoNumero.MaxLength = 200
            Me.columnrowguid.AllowDBNull = false
            Me.columnrowguid.ReadOnly = true
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Function NewClientiRow() As ClientiRow
            Return CType(Me.NewRow,ClientiRow)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Protected Overrides Function NewRowFromBuilder(ByVal builder As System.Data.DataRowBuilder) As System.Data.DataRow
            Return New ClientiRow(builder)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Protected Overrides Function GetRowType() As System.Type
            Return GetType(ClientiRow)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Protected Overrides Sub OnRowChanged(ByVal e As System.Data.DataRowChangeEventArgs)
            MyBase.OnRowChanged(e)
            If (Not (Me.ClientiRowChangedEvent) Is Nothing) Then
                RaiseEvent ClientiRowChanged(Me, New ClientiRowChangeEvent(CType(e.Row,ClientiRow), e.Action))
            End If
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Protected Overrides Sub OnRowChanging(ByVal e As System.Data.DataRowChangeEventArgs)
            MyBase.OnRowChanging(e)
            If (Not (Me.ClientiRowChangingEvent) Is Nothing) Then
                RaiseEvent ClientiRowChanging(Me, New ClientiRowChangeEvent(CType(e.Row,ClientiRow), e.Action))
            End If
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Protected Overrides Sub OnRowDeleted(ByVal e As System.Data.DataRowChangeEventArgs)
            MyBase.OnRowDeleted(e)
            If (Not (Me.ClientiRowDeletedEvent) Is Nothing) Then
                RaiseEvent ClientiRowDeleted(Me, New ClientiRowChangeEvent(CType(e.Row,ClientiRow), e.Action))
            End If
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Protected Overrides Sub OnRowDeleting(ByVal e As System.Data.DataRowChangeEventArgs)
            MyBase.OnRowDeleting(e)
            If (Not (Me.ClientiRowDeletingEvent) Is Nothing) Then
                RaiseEvent ClientiRowDeleting(Me, New ClientiRowChangeEvent(CType(e.Row,ClientiRow), e.Action))
            End If
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub RemoveClientiRow(ByVal row As ClientiRow)
            Me.Rows.Remove(row)
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Shared Function GetTypedTableSchema(ByVal xs As System.Xml.Schema.XmlSchemaSet) As System.Xml.Schema.XmlSchemaComplexType
            Dim type As System.Xml.Schema.XmlSchemaComplexType = New System.Xml.Schema.XmlSchemaComplexType
            Dim sequence As System.Xml.Schema.XmlSchemaSequence = New System.Xml.Schema.XmlSchemaSequence
            Dim ds As SmartEstateDataSet = New SmartEstateDataSet
            xs.Add(ds.GetSchemaSerializable)
            Dim any1 As System.Xml.Schema.XmlSchemaAny = New System.Xml.Schema.XmlSchemaAny
            any1.Namespace = "http://www.w3.org/2001/XMLSchema"
            any1.MinOccurs = New Decimal(0)
            any1.MaxOccurs = Decimal.MaxValue
            any1.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax
            sequence.Items.Add(any1)
            Dim any2 As System.Xml.Schema.XmlSchemaAny = New System.Xml.Schema.XmlSchemaAny
            any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1"
            any2.MinOccurs = New Decimal(1)
            any2.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax
            sequence.Items.Add(any2)
            Dim attribute1 As System.Xml.Schema.XmlSchemaAttribute = New System.Xml.Schema.XmlSchemaAttribute
            attribute1.Name = "namespace"
            attribute1.FixedValue = ds.Namespace
            type.Attributes.Add(attribute1)
            Dim attribute2 As System.Xml.Schema.XmlSchemaAttribute = New System.Xml.Schema.XmlSchemaAttribute
            attribute2.Name = "tableTypeName"
            attribute2.FixedValue = "ClientiDataTable"
            type.Attributes.Add(attribute2)
            type.Particle = sequence
            Return type
        End Function
    End Class
    
    <System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedTableSchema")>  _
    Partial Public Class ImmobiliDataTable
        Inherits System.Data.DataTable
        Implements System.Collections.IEnumerable
        
        Private columnIdImmobile As System.Data.DataColumn
        
        Private columnIdAgenzia As System.Data.DataColumn
        
        Private columnCodiceImmobile As System.Data.DataColumn
        
        Private columnCodiceTipoImmobile As System.Data.DataColumn
        
        Private columnRiferimentoInterno As System.Data.DataColumn
        
        Private columnDescrizioneLunga As System.Data.DataColumn
        
        Private columnDescrizioneBreve As System.Data.DataColumn
        
        Private columnDimensione As System.Data.DataColumn
        
        Private columnIndirizzo As System.Data.DataColumn
        
        Private columnCAP As System.Data.DataColumn
        
        Private columnZona As System.Data.DataColumn
        
        Private columnCitta As System.Data.DataColumn
        
        Private columnFoto As System.Data.DataColumn
        
        Private columnPlanimetria As System.Data.DataColumn
        
        Private columnPrezzoMin As System.Data.DataColumn
        
        Private columnPrezzoMax As System.Data.DataColumn
        
        Private columnSpeseCondominiali As System.Data.DataColumn
        
        Private columnValutazione As System.Data.DataColumn
        
        Private columnrowguid As System.Data.DataColumn
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub New()
            MyBase.New
            Me.TableName = "Immobili"
            Me.BeginInit
            Me.InitClass
            Me.EndInit
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Friend Sub New(ByVal table As System.Data.DataTable)
            MyBase.New
            Me.TableName = table.TableName
            If (table.CaseSensitive <> table.DataSet.CaseSensitive) Then
                Me.CaseSensitive = table.CaseSensitive
            End If
            If (table.Locale.ToString <> table.DataSet.Locale.ToString) Then
                Me.Locale = table.Locale
            End If
            If (table.Namespace <> table.DataSet.Namespace) Then
                Me.Namespace = table.Namespace
            End If
            Me.Prefix = table.Prefix
            Me.MinimumCapacity = table.MinimumCapacity
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property IdImmobileColumn() As System.Data.DataColumn
            Get
                Return Me.columnIdImmobile
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property IdAgenziaColumn() As System.Data.DataColumn
            Get
                Return Me.columnIdAgenzia
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property CodiceImmobileColumn() As System.Data.DataColumn
            Get
                Return Me.columnCodiceImmobile
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property CodiceTipoImmobileColumn() As System.Data.DataColumn
            Get
                Return Me.columnCodiceTipoImmobile
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property RiferimentoInternoColumn() As System.Data.DataColumn
            Get
                Return Me.columnRiferimentoInterno
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property DescrizioneLungaColumn() As System.Data.DataColumn
            Get
                Return Me.columnDescrizioneLunga
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property DescrizioneBreveColumn() As System.Data.DataColumn
            Get
                Return Me.columnDescrizioneBreve
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property DimensioneColumn() As System.Data.DataColumn
            Get
                Return Me.columnDimensione
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property IndirizzoColumn() As System.Data.DataColumn
            Get
                Return Me.columnIndirizzo
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property CAPColumn() As System.Data.DataColumn
            Get
                Return Me.columnCAP
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property ZonaColumn() As System.Data.DataColumn
            Get
                Return Me.columnZona
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property CittaColumn() As System.Data.DataColumn
            Get
                Return Me.columnCitta
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property FotoColumn() As System.Data.DataColumn
            Get
                Return Me.columnFoto
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property PlanimetriaColumn() As System.Data.DataColumn
            Get
                Return Me.columnPlanimetria
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property PrezzoMinColumn() As System.Data.DataColumn
            Get
                Return Me.columnPrezzoMin
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property PrezzoMaxColumn() As System.Data.DataColumn
            Get
                Return Me.columnPrezzoMax
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property SpeseCondominialiColumn() As System.Data.DataColumn
            Get
                Return Me.columnSpeseCondominiali
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property ValutazioneColumn() As System.Data.DataColumn
            Get
                Return Me.columnValutazione
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property rowguidColumn() As System.Data.DataColumn
            Get
                Return Me.columnrowguid
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property Count() As Integer
            Get
                Return Me.Rows.Count
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Default ReadOnly Property Item(ByVal index As Integer) As ImmobiliRow
            Get
                Return CType(Me.Rows(index),ImmobiliRow)
            End Get
        End Property
        
        Public Event ImmobiliRowChanging As ImmobiliRowChangeEventHandler
        
        Public Event ImmobiliRowChanged As ImmobiliRowChangeEventHandler
        
        Public Event ImmobiliRowDeleting As ImmobiliRowChangeEventHandler
        
        Public Event ImmobiliRowDeleted As ImmobiliRowChangeEventHandler
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Overloads Sub AddImmobiliRow(ByVal row As ImmobiliRow)
            Me.Rows.Add(row)
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Overloads Function AddImmobiliRow( _
                    ByVal IdAgenzia As Integer,  _
                    ByVal CodiceImmobile As String,  _
                    ByVal CodiceTipoImmobile As String,  _
                    ByVal RiferimentoInterno As String,  _
                    ByVal DescrizioneLunga As String,  _
                    ByVal DescrizioneBreve As String,  _
                    ByVal Dimensione As Integer,  _
                    ByVal Indirizzo As String,  _
                    ByVal CAP As String,  _
                    ByVal Zona As String,  _
                    ByVal Citta As String,  _
                    ByVal Foto() As Byte,  _
                    ByVal Planimetria() As Byte,  _
                    ByVal PrezzoMin As Integer,  _
                    ByVal PrezzoMax As Integer,  _
                    ByVal SpeseCondominiali As Integer,  _
                    ByVal Valutazione As Integer,  _
                    ByVal rowguid As System.Guid) As ImmobiliRow
            Dim rowImmobiliRow As ImmobiliRow = CType(Me.NewRow,ImmobiliRow)
            rowImmobiliRow.ItemArray = New Object() {Nothing, IdAgenzia, CodiceImmobile, CodiceTipoImmobile, RiferimentoInterno, DescrizioneLunga, DescrizioneBreve, Dimensione, Indirizzo, CAP, Zona, Citta, Foto, Planimetria, PrezzoMin, PrezzoMax, SpeseCondominiali, Valutazione, rowguid}
            Me.Rows.Add(rowImmobiliRow)
            Return rowImmobiliRow
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Function FindByIdImmobilerowguid(ByVal IdImmobile As Integer, ByVal rowguid As System.Guid) As ImmobiliRow
            Return CType(Me.Rows.Find(New Object() {IdImmobile, rowguid}),ImmobiliRow)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Overridable Function GetEnumerator() As System.Collections.IEnumerator Implements System.Collections.IEnumerable.GetEnumerator
            Return Me.Rows.GetEnumerator
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Overrides Function Clone() As System.Data.DataTable
            Dim cln As ImmobiliDataTable = CType(MyBase.Clone,ImmobiliDataTable)
            cln.InitVars
            Return cln
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Protected Overrides Function CreateInstance() As System.Data.DataTable
            Return New ImmobiliDataTable
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Friend Sub InitVars()
            Me.columnIdImmobile = MyBase.Columns("IdImmobile")
            Me.columnIdAgenzia = MyBase.Columns("IdAgenzia")
            Me.columnCodiceImmobile = MyBase.Columns("CodiceImmobile")
            Me.columnCodiceTipoImmobile = MyBase.Columns("CodiceTipoImmobile")
            Me.columnRiferimentoInterno = MyBase.Columns("RiferimentoInterno")
            Me.columnDescrizioneLunga = MyBase.Columns("DescrizioneLunga")
            Me.columnDescrizioneBreve = MyBase.Columns("DescrizioneBreve")
            Me.columnDimensione = MyBase.Columns("Dimensione")
            Me.columnIndirizzo = MyBase.Columns("Indirizzo")
            Me.columnCAP = MyBase.Columns("CAP")
            Me.columnZona = MyBase.Columns("Zona")
            Me.columnCitta = MyBase.Columns("Citta")
            Me.columnFoto = MyBase.Columns("Foto")
            Me.columnPlanimetria = MyBase.Columns("Planimetria")
            Me.columnPrezzoMin = MyBase.Columns("PrezzoMin")
            Me.columnPrezzoMax = MyBase.Columns("PrezzoMax")
            Me.columnSpeseCondominiali = MyBase.Columns("SpeseCondominiali")
            Me.columnValutazione = MyBase.Columns("Valutazione")
            Me.columnrowguid = MyBase.Columns("rowguid")
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Private Sub InitClass()
            Me.columnIdImmobile = New System.Data.DataColumn("IdImmobile", GetType(Integer), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnIdImmobile)
            Me.columnIdAgenzia = New System.Data.DataColumn("IdAgenzia", GetType(Integer), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnIdAgenzia)
            Me.columnCodiceImmobile = New System.Data.DataColumn("CodiceImmobile", GetType(String), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnCodiceImmobile)
            Me.columnCodiceTipoImmobile = New System.Data.DataColumn("CodiceTipoImmobile", GetType(String), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnCodiceTipoImmobile)
            Me.columnRiferimentoInterno = New System.Data.DataColumn("RiferimentoInterno", GetType(String), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnRiferimentoInterno)
            Me.columnDescrizioneLunga = New System.Data.DataColumn("DescrizioneLunga", GetType(String), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnDescrizioneLunga)
            Me.columnDescrizioneBreve = New System.Data.DataColumn("DescrizioneBreve", GetType(String), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnDescrizioneBreve)
            Me.columnDimensione = New System.Data.DataColumn("Dimensione", GetType(Integer), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnDimensione)
            Me.columnIndirizzo = New System.Data.DataColumn("Indirizzo", GetType(String), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnIndirizzo)
            Me.columnCAP = New System.Data.DataColumn("CAP", GetType(String), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnCAP)
            Me.columnZona = New System.Data.DataColumn("Zona", GetType(String), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnZona)
            Me.columnCitta = New System.Data.DataColumn("Citta", GetType(String), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnCitta)
            Me.columnFoto = New System.Data.DataColumn("Foto", GetType(Byte()), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnFoto)
            Me.columnPlanimetria = New System.Data.DataColumn("Planimetria", GetType(Byte()), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnPlanimetria)
            Me.columnPrezzoMin = New System.Data.DataColumn("PrezzoMin", GetType(Integer), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnPrezzoMin)
            Me.columnPrezzoMax = New System.Data.DataColumn("PrezzoMax", GetType(Integer), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnPrezzoMax)
            Me.columnSpeseCondominiali = New System.Data.DataColumn("SpeseCondominiali", GetType(Integer), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnSpeseCondominiali)
            Me.columnValutazione = New System.Data.DataColumn("Valutazione", GetType(Integer), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnValutazione)
            Me.columnrowguid = New System.Data.DataColumn("rowguid", GetType(System.Guid), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnrowguid)
            Me.Constraints.Add(New System.Data.UniqueConstraint("Constraint1", New System.Data.DataColumn() {Me.columnIdImmobile, Me.columnrowguid}, true))
            Me.columnIdImmobile.AutoIncrement = true
            Me.columnIdImmobile.AllowDBNull = false
            Me.columnIdImmobile.ReadOnly = true
            Me.columnIdAgenzia.AllowDBNull = false
            Me.columnCodiceImmobile.MaxLength = 200
            Me.columnCodiceTipoImmobile.MaxLength = 200
            Me.columnRiferimentoInterno.MaxLength = 200
            Me.columnDescrizioneLunga.MaxLength = 200
            Me.columnDescrizioneBreve.MaxLength = 200
            Me.columnIndirizzo.MaxLength = 200
            Me.columnCAP.MaxLength = 5
            Me.columnZona.MaxLength = 200
            Me.columnCitta.MaxLength = 200
            Me.columnrowguid.AllowDBNull = false
            Me.columnrowguid.ReadOnly = true
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Function NewImmobiliRow() As ImmobiliRow
            Return CType(Me.NewRow,ImmobiliRow)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Protected Overrides Function NewRowFromBuilder(ByVal builder As System.Data.DataRowBuilder) As System.Data.DataRow
            Return New ImmobiliRow(builder)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Protected Overrides Function GetRowType() As System.Type
            Return GetType(ImmobiliRow)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Protected Overrides Sub OnRowChanged(ByVal e As System.Data.DataRowChangeEventArgs)
            MyBase.OnRowChanged(e)
            If (Not (Me.ImmobiliRowChangedEvent) Is Nothing) Then
                RaiseEvent ImmobiliRowChanged(Me, New ImmobiliRowChangeEvent(CType(e.Row,ImmobiliRow), e.Action))
            End If
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Protected Overrides Sub OnRowChanging(ByVal e As System.Data.DataRowChangeEventArgs)
            MyBase.OnRowChanging(e)
            If (Not (Me.ImmobiliRowChangingEvent) Is Nothing) Then
                RaiseEvent ImmobiliRowChanging(Me, New ImmobiliRowChangeEvent(CType(e.Row,ImmobiliRow), e.Action))
            End If
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Protected Overrides Sub OnRowDeleted(ByVal e As System.Data.DataRowChangeEventArgs)
            MyBase.OnRowDeleted(e)
            If (Not (Me.ImmobiliRowDeletedEvent) Is Nothing) Then
                RaiseEvent ImmobiliRowDeleted(Me, New ImmobiliRowChangeEvent(CType(e.Row,ImmobiliRow), e.Action))
            End If
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Protected Overrides Sub OnRowDeleting(ByVal e As System.Data.DataRowChangeEventArgs)
            MyBase.OnRowDeleting(e)
            If (Not (Me.ImmobiliRowDeletingEvent) Is Nothing) Then
                RaiseEvent ImmobiliRowDeleting(Me, New ImmobiliRowChangeEvent(CType(e.Row,ImmobiliRow), e.Action))
            End If
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub RemoveImmobiliRow(ByVal row As ImmobiliRow)
            Me.Rows.Remove(row)
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Shared Function GetTypedTableSchema(ByVal xs As System.Xml.Schema.XmlSchemaSet) As System.Xml.Schema.XmlSchemaComplexType
            Dim type As System.Xml.Schema.XmlSchemaComplexType = New System.Xml.Schema.XmlSchemaComplexType
            Dim sequence As System.Xml.Schema.XmlSchemaSequence = New System.Xml.Schema.XmlSchemaSequence
            Dim ds As SmartEstateDataSet = New SmartEstateDataSet
            xs.Add(ds.GetSchemaSerializable)
            Dim any1 As System.Xml.Schema.XmlSchemaAny = New System.Xml.Schema.XmlSchemaAny
            any1.Namespace = "http://www.w3.org/2001/XMLSchema"
            any1.MinOccurs = New Decimal(0)
            any1.MaxOccurs = Decimal.MaxValue
            any1.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax
            sequence.Items.Add(any1)
            Dim any2 As System.Xml.Schema.XmlSchemaAny = New System.Xml.Schema.XmlSchemaAny
            any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1"
            any2.MinOccurs = New Decimal(1)
            any2.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax
            sequence.Items.Add(any2)
            Dim attribute1 As System.Xml.Schema.XmlSchemaAttribute = New System.Xml.Schema.XmlSchemaAttribute
            attribute1.Name = "namespace"
            attribute1.FixedValue = ds.Namespace
            type.Attributes.Add(attribute1)
            Dim attribute2 As System.Xml.Schema.XmlSchemaAttribute = New System.Xml.Schema.XmlSchemaAttribute
            attribute2.Name = "tableTypeName"
            attribute2.FixedValue = "ImmobiliDataTable"
            type.Attributes.Add(attribute2)
            type.Particle = sequence
            Return type
        End Function
    End Class
    
    <System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedTableSchema")>  _
    Partial Public Class PreventiviDataTable
        Inherits System.Data.DataTable
        Implements System.Collections.IEnumerable
        
        Private columnIdPreventivo As System.Data.DataColumn
        
        Private columnIdCliente As System.Data.DataColumn
        
        Private columnIdImmobile As System.Data.DataColumn
        
        Private columnIdAgente As System.Data.DataColumn
        
        Private columnAppuntamento As System.Data.DataColumn
        
        Private columnCodiceTipoOffertaImmobile As System.Data.DataColumn
        
        Private columnrowguid As System.Data.DataColumn
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub New()
            MyBase.New
            Me.TableName = "Preventivi"
            Me.BeginInit
            Me.InitClass
            Me.EndInit
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Friend Sub New(ByVal table As System.Data.DataTable)
            MyBase.New
            Me.TableName = table.TableName
            If (table.CaseSensitive <> table.DataSet.CaseSensitive) Then
                Me.CaseSensitive = table.CaseSensitive
            End If
            If (table.Locale.ToString <> table.DataSet.Locale.ToString) Then
                Me.Locale = table.Locale
            End If
            If (table.Namespace <> table.DataSet.Namespace) Then
                Me.Namespace = table.Namespace
            End If
            Me.Prefix = table.Prefix
            Me.MinimumCapacity = table.MinimumCapacity
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property IdPreventivoColumn() As System.Data.DataColumn
            Get
                Return Me.columnIdPreventivo
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property IdClienteColumn() As System.Data.DataColumn
            Get
                Return Me.columnIdCliente
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property IdImmobileColumn() As System.Data.DataColumn
            Get
                Return Me.columnIdImmobile
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property IdAgenteColumn() As System.Data.DataColumn
            Get
                Return Me.columnIdAgente
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property AppuntamentoColumn() As System.Data.DataColumn
            Get
                Return Me.columnAppuntamento
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property CodiceTipoOffertaImmobileColumn() As System.Data.DataColumn
            Get
                Return Me.columnCodiceTipoOffertaImmobile
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property rowguidColumn() As System.Data.DataColumn
            Get
                Return Me.columnrowguid
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property Count() As Integer
            Get
                Return Me.Rows.Count
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Default ReadOnly Property Item(ByVal index As Integer) As PreventiviRow
            Get
                Return CType(Me.Rows(index),PreventiviRow)
            End Get
        End Property
        
        Public Event PreventiviRowChanging As PreventiviRowChangeEventHandler
        
        Public Event PreventiviRowChanged As PreventiviRowChangeEventHandler
        
        Public Event PreventiviRowDeleting As PreventiviRowChangeEventHandler
        
        Public Event PreventiviRowDeleted As PreventiviRowChangeEventHandler
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Overloads Sub AddPreventiviRow(ByVal row As PreventiviRow)
            Me.Rows.Add(row)
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Overloads Function AddPreventiviRow(ByVal parentClientiRowByFK__Preventiv__IdCli__1920BF5C As ClientiRow, ByVal parentImmobiliRowByFK__Preventiv__IdImm__1BFD2C07 As ImmobiliRow, ByVal parentAgentiRowByFK__Preventiv__IdAge__1B0907CE As AgentiRow, ByVal Appuntamento As Date, ByVal CodiceTipoOffertaImmobile As String, ByVal rowguid As System.Guid) As PreventiviRow
            Dim rowPreventiviRow As PreventiviRow = CType(Me.NewRow,PreventiviRow)
            rowPreventiviRow.ItemArray = New Object() {Nothing, parentClientiRowByFK__Preventiv__IdCli__1920BF5C(0), parentImmobiliRowByFK__Preventiv__IdImm__1BFD2C07(0), parentAgentiRowByFK__Preventiv__IdAge__1B0907CE(0), Appuntamento, CodiceTipoOffertaImmobile, rowguid}
            Me.Rows.Add(rowPreventiviRow)
            Return rowPreventiviRow
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Function FindByIdPreventivorowguid(ByVal IdPreventivo As Integer, ByVal rowguid As System.Guid) As PreventiviRow
            Return CType(Me.Rows.Find(New Object() {IdPreventivo, rowguid}),PreventiviRow)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Overridable Function GetEnumerator() As System.Collections.IEnumerator Implements System.Collections.IEnumerable.GetEnumerator
            Return Me.Rows.GetEnumerator
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Overrides Function Clone() As System.Data.DataTable
            Dim cln As PreventiviDataTable = CType(MyBase.Clone,PreventiviDataTable)
            cln.InitVars
            Return cln
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Protected Overrides Function CreateInstance() As System.Data.DataTable
            Return New PreventiviDataTable
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Friend Sub InitVars()
            Me.columnIdPreventivo = MyBase.Columns("IdPreventivo")
            Me.columnIdCliente = MyBase.Columns("IdCliente")
            Me.columnIdImmobile = MyBase.Columns("IdImmobile")
            Me.columnIdAgente = MyBase.Columns("IdAgente")
            Me.columnAppuntamento = MyBase.Columns("Appuntamento")
            Me.columnCodiceTipoOffertaImmobile = MyBase.Columns("CodiceTipoOffertaImmobile")
            Me.columnrowguid = MyBase.Columns("rowguid")
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Private Sub InitClass()
            Me.columnIdPreventivo = New System.Data.DataColumn("IdPreventivo", GetType(Integer), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnIdPreventivo)
            Me.columnIdCliente = New System.Data.DataColumn("IdCliente", GetType(Integer), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnIdCliente)
            Me.columnIdImmobile = New System.Data.DataColumn("IdImmobile", GetType(Integer), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnIdImmobile)
            Me.columnIdAgente = New System.Data.DataColumn("IdAgente", GetType(Integer), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnIdAgente)
            Me.columnAppuntamento = New System.Data.DataColumn("Appuntamento", GetType(Date), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnAppuntamento)
            Me.columnCodiceTipoOffertaImmobile = New System.Data.DataColumn("CodiceTipoOffertaImmobile", GetType(String), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnCodiceTipoOffertaImmobile)
            Me.columnrowguid = New System.Data.DataColumn("rowguid", GetType(System.Guid), Nothing, System.Data.MappingType.Element)
            MyBase.Columns.Add(Me.columnrowguid)
            Me.Constraints.Add(New System.Data.UniqueConstraint("Constraint1", New System.Data.DataColumn() {Me.columnIdPreventivo, Me.columnrowguid}, true))
            Me.columnIdPreventivo.AutoIncrement = true
            Me.columnIdPreventivo.AllowDBNull = false
            Me.columnIdPreventivo.ReadOnly = true
            Me.columnIdCliente.AllowDBNull = false
            Me.columnIdImmobile.AllowDBNull = false
            Me.columnIdAgente.AllowDBNull = false
            Me.columnCodiceTipoOffertaImmobile.MaxLength = 200
            Me.columnrowguid.AllowDBNull = false
            Me.columnrowguid.ReadOnly = true
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Function NewPreventiviRow() As PreventiviRow
            Return CType(Me.NewRow,PreventiviRow)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Protected Overrides Function NewRowFromBuilder(ByVal builder As System.Data.DataRowBuilder) As System.Data.DataRow
            Return New PreventiviRow(builder)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Protected Overrides Function GetRowType() As System.Type
            Return GetType(PreventiviRow)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Protected Overrides Sub OnRowChanged(ByVal e As System.Data.DataRowChangeEventArgs)
            MyBase.OnRowChanged(e)
            If (Not (Me.PreventiviRowChangedEvent) Is Nothing) Then
                RaiseEvent PreventiviRowChanged(Me, New PreventiviRowChangeEvent(CType(e.Row,PreventiviRow), e.Action))
            End If
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Protected Overrides Sub OnRowChanging(ByVal e As System.Data.DataRowChangeEventArgs)
            MyBase.OnRowChanging(e)
            If (Not (Me.PreventiviRowChangingEvent) Is Nothing) Then
                RaiseEvent PreventiviRowChanging(Me, New PreventiviRowChangeEvent(CType(e.Row,PreventiviRow), e.Action))
            End If
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Protected Overrides Sub OnRowDeleted(ByVal e As System.Data.DataRowChangeEventArgs)
            MyBase.OnRowDeleted(e)
            If (Not (Me.PreventiviRowDeletedEvent) Is Nothing) Then
                RaiseEvent PreventiviRowDeleted(Me, New PreventiviRowChangeEvent(CType(e.Row,PreventiviRow), e.Action))
            End If
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Protected Overrides Sub OnRowDeleting(ByVal e As System.Data.DataRowChangeEventArgs)
            MyBase.OnRowDeleting(e)
            If (Not (Me.PreventiviRowDeletingEvent) Is Nothing) Then
                RaiseEvent PreventiviRowDeleting(Me, New PreventiviRowChangeEvent(CType(e.Row,PreventiviRow), e.Action))
            End If
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub RemovePreventiviRow(ByVal row As PreventiviRow)
            Me.Rows.Remove(row)
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Shared Function GetTypedTableSchema(ByVal xs As System.Xml.Schema.XmlSchemaSet) As System.Xml.Schema.XmlSchemaComplexType
            Dim type As System.Xml.Schema.XmlSchemaComplexType = New System.Xml.Schema.XmlSchemaComplexType
            Dim sequence As System.Xml.Schema.XmlSchemaSequence = New System.Xml.Schema.XmlSchemaSequence
            Dim ds As SmartEstateDataSet = New SmartEstateDataSet
            xs.Add(ds.GetSchemaSerializable)
            Dim any1 As System.Xml.Schema.XmlSchemaAny = New System.Xml.Schema.XmlSchemaAny
            any1.Namespace = "http://www.w3.org/2001/XMLSchema"
            any1.MinOccurs = New Decimal(0)
            any1.MaxOccurs = Decimal.MaxValue
            any1.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax
            sequence.Items.Add(any1)
            Dim any2 As System.Xml.Schema.XmlSchemaAny = New System.Xml.Schema.XmlSchemaAny
            any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1"
            any2.MinOccurs = New Decimal(1)
            any2.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax
            sequence.Items.Add(any2)
            Dim attribute1 As System.Xml.Schema.XmlSchemaAttribute = New System.Xml.Schema.XmlSchemaAttribute
            attribute1.Name = "namespace"
            attribute1.FixedValue = ds.Namespace
            type.Attributes.Add(attribute1)
            Dim attribute2 As System.Xml.Schema.XmlSchemaAttribute = New System.Xml.Schema.XmlSchemaAttribute
            attribute2.Name = "tableTypeName"
            attribute2.FixedValue = "PreventiviDataTable"
            type.Attributes.Add(attribute2)
            type.Particle = sequence
            Return type
        End Function
    End Class
    
    Partial Public Class AgentiRow
        Inherits System.Data.DataRow
        
        Private tableAgenti As AgentiDataTable
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Friend Sub New(ByVal rb As System.Data.DataRowBuilder)
            MyBase.New(rb)
            Me.tableAgenti = CType(Me.Table,AgentiDataTable)
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property IdAgente() As Integer
            Get
                Return CType(Me(Me.tableAgenti.IdAgenteColumn),Integer)
            End Get
            Set
                Me(Me.tableAgenti.IdAgenteColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property Indirizzo() As String
            Get
                Try 
                    Return CType(Me(Me.tableAgenti.IndirizzoColumn),String)
                Catch e As System.InvalidCastException
                    Throw New System.Data.StrongTypingException("The value for column 'Indirizzo' in table 'Agenti' is DBNull.", e)
                End Try
            End Get
            Set
                Me(Me.tableAgenti.IndirizzoColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property CAP() As String
            Get
                Return CType(Me(Me.tableAgenti.CAPColumn),String)
            End Get
            Set
                Me(Me.tableAgenti.CAPColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property Citta() As String
            Get
                Try 
                    Return CType(Me(Me.tableAgenti.CittaColumn),String)
                Catch e As System.InvalidCastException
                    Throw New System.Data.StrongTypingException("The value for column 'Citta' in table 'Agenti' is DBNull.", e)
                End Try
            End Get
            Set
                Me(Me.tableAgenti.CittaColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property IdAgenzia() As Integer
            Get
                Try 
                    Return CType(Me(Me.tableAgenti.IdAgenziaColumn),Integer)
                Catch e As System.InvalidCastException
                    Throw New System.Data.StrongTypingException("The value for column 'IdAgenzia' in table 'Agenti' is DBNull.", e)
                End Try
            End Get
            Set
                Me(Me.tableAgenti.IdAgenziaColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property TelefonoNumero() As String
            Get
                Try 
                    Return CType(Me(Me.tableAgenti.TelefonoNumeroColumn),String)
                Catch e As System.InvalidCastException
                    Throw New System.Data.StrongTypingException("The value for column 'TelefonoNumero' in table 'Agenti' is DBNull.", e)
                End Try
            End Get
            Set
                Me(Me.tableAgenti.TelefonoNumeroColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property Nome() As String
            Get
                Try 
                    Return CType(Me(Me.tableAgenti.NomeColumn),String)
                Catch e As System.InvalidCastException
                    Throw New System.Data.StrongTypingException("The value for column 'Nome' in table 'Agenti' is DBNull.", e)
                End Try
            End Get
            Set
                Me(Me.tableAgenti.NomeColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property TelefonoPrefisso() As String
            Get
                Try 
                    Return CType(Me(Me.tableAgenti.TelefonoPrefissoColumn),String)
                Catch e As System.InvalidCastException
                    Throw New System.Data.StrongTypingException("The value for column 'TelefonoPrefisso' in table 'Agenti' is DBNull.", e)
                End Try
            End Get
            Set
                Me(Me.tableAgenti.TelefonoPrefissoColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property Cognome() As String
            Get
                Try 
                    Return CType(Me(Me.tableAgenti.CognomeColumn),String)
                Catch e As System.InvalidCastException
                    Throw New System.Data.StrongTypingException("The value for column 'Cognome' in table 'Agenti' is DBNull.", e)
                End Try
            End Get
            Set
                Me(Me.tableAgenti.CognomeColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property Email() As String
            Get
                Try 
                    Return CType(Me(Me.tableAgenti.EmailColumn),String)
                Catch e As System.InvalidCastException
                    Throw New System.Data.StrongTypingException("The value for column 'Email' in table 'Agenti' is DBNull.", e)
                End Try
            End Get
            Set
                Me(Me.tableAgenti.EmailColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property SysDataInsert() As Date
            Get
                Try 
                    Return CType(Me(Me.tableAgenti.SysDataInsertColumn),Date)
                Catch e As System.InvalidCastException
                    Throw New System.Data.StrongTypingException("The value for column 'SysDataInsert' in table 'Agenti' is DBNull.", e)
                End Try
            End Get
            Set
                Me(Me.tableAgenti.SysDataInsertColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property SysIdUtenteInsert() As String
            Get
                Try 
                    Return CType(Me(Me.tableAgenti.SysIdUtenteInsertColumn),String)
                Catch e As System.InvalidCastException
                    Throw New System.Data.StrongTypingException("The value for column 'SysIdUtenteInsert' in table 'Agenti' is DBNull.", e)
                End Try
            End Get
            Set
                Me(Me.tableAgenti.SysIdUtenteInsertColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property SysDataUpdate() As Date
            Get
                Try 
                    Return CType(Me(Me.tableAgenti.SysDataUpdateColumn),Date)
                Catch e As System.InvalidCastException
                    Throw New System.Data.StrongTypingException("The value for column 'SysDataUpdate' in table 'Agenti' is DBNull.", e)
                End Try
            End Get
            Set
                Me(Me.tableAgenti.SysDataUpdateColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property SysIdUtenteUpdate() As String
            Get
                Try 
                    Return CType(Me(Me.tableAgenti.SysIdUtenteUpdateColumn),String)
                Catch e As System.InvalidCastException
                    Throw New System.Data.StrongTypingException("The value for column 'SysIdUtenteUpdate' in table 'Agenti' is DBNull.", e)
                End Try
            End Get
            Set
                Me(Me.tableAgenti.SysIdUtenteUpdateColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property SysGUID() As System.Guid
            Get
                Try 
                    Return CType(Me(Me.tableAgenti.SysGUIDColumn),System.Guid)
                Catch e As System.InvalidCastException
                    Throw New System.Data.StrongTypingException("The value for column 'SysGUID' in table 'Agenti' is DBNull.", e)
                End Try
            End Get
            Set
                Me(Me.tableAgenti.SysGUIDColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property rowguid() As System.Guid
            Get
                Return CType(Me(Me.tableAgenti.rowguidColumn),System.Guid)
            End Get
            Set
                Me(Me.tableAgenti.rowguidColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Function IsIndirizzoNull() As Boolean
            Return Me.IsNull(Me.tableAgenti.IndirizzoColumn)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub SetIndirizzoNull()
            Me(Me.tableAgenti.IndirizzoColumn) = System.Convert.DBNull
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Function IsCittaNull() As Boolean
            Return Me.IsNull(Me.tableAgenti.CittaColumn)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub SetCittaNull()
            Me(Me.tableAgenti.CittaColumn) = System.Convert.DBNull
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Function IsIdAgenziaNull() As Boolean
            Return Me.IsNull(Me.tableAgenti.IdAgenziaColumn)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub SetIdAgenziaNull()
            Me(Me.tableAgenti.IdAgenziaColumn) = System.Convert.DBNull
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Function IsTelefonoNumeroNull() As Boolean
            Return Me.IsNull(Me.tableAgenti.TelefonoNumeroColumn)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub SetTelefonoNumeroNull()
            Me(Me.tableAgenti.TelefonoNumeroColumn) = System.Convert.DBNull
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Function IsNomeNull() As Boolean
            Return Me.IsNull(Me.tableAgenti.NomeColumn)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub SetNomeNull()
            Me(Me.tableAgenti.NomeColumn) = System.Convert.DBNull
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Function IsTelefonoPrefissoNull() As Boolean
            Return Me.IsNull(Me.tableAgenti.TelefonoPrefissoColumn)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub SetTelefonoPrefissoNull()
            Me(Me.tableAgenti.TelefonoPrefissoColumn) = System.Convert.DBNull
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Function IsCognomeNull() As Boolean
            Return Me.IsNull(Me.tableAgenti.CognomeColumn)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub SetCognomeNull()
            Me(Me.tableAgenti.CognomeColumn) = System.Convert.DBNull
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Function IsEmailNull() As Boolean
            Return Me.IsNull(Me.tableAgenti.EmailColumn)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub SetEmailNull()
            Me(Me.tableAgenti.EmailColumn) = System.Convert.DBNull
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Function IsSysDataInsertNull() As Boolean
            Return Me.IsNull(Me.tableAgenti.SysDataInsertColumn)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub SetSysDataInsertNull()
            Me(Me.tableAgenti.SysDataInsertColumn) = System.Convert.DBNull
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Function IsSysIdUtenteInsertNull() As Boolean
            Return Me.IsNull(Me.tableAgenti.SysIdUtenteInsertColumn)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub SetSysIdUtenteInsertNull()
            Me(Me.tableAgenti.SysIdUtenteInsertColumn) = System.Convert.DBNull
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Function IsSysDataUpdateNull() As Boolean
            Return Me.IsNull(Me.tableAgenti.SysDataUpdateColumn)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub SetSysDataUpdateNull()
            Me(Me.tableAgenti.SysDataUpdateColumn) = System.Convert.DBNull
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Function IsSysIdUtenteUpdateNull() As Boolean
            Return Me.IsNull(Me.tableAgenti.SysIdUtenteUpdateColumn)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub SetSysIdUtenteUpdateNull()
            Me(Me.tableAgenti.SysIdUtenteUpdateColumn) = System.Convert.DBNull
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Function IsSysGUIDNull() As Boolean
            Return Me.IsNull(Me.tableAgenti.SysGUIDColumn)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub SetSysGUIDNull()
            Me(Me.tableAgenti.SysGUIDColumn) = System.Convert.DBNull
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Function GetPreventiviRows() As PreventiviRow()
            Return CType(MyBase.GetChildRows(Me.Table.ChildRelations("FK__Preventiv__IdAge__1B0907CE")),PreventiviRow())
        End Function
    End Class
    
    Partial Public Class ClientiRow
        Inherits System.Data.DataRow
        
        Private tableClienti As ClientiDataTable
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Friend Sub New(ByVal rb As System.Data.DataRowBuilder)
            MyBase.New(rb)
            Me.tableClienti = CType(Me.Table,ClientiDataTable)
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property IdCliente() As Integer
            Get
                Return CType(Me(Me.tableClienti.IdClienteColumn),Integer)
            End Get
            Set
                Me(Me.tableClienti.IdClienteColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property IdAgenzia() As Integer
            Get
                Return CType(Me(Me.tableClienti.IdAgenziaColumn),Integer)
            End Get
            Set
                Me(Me.tableClienti.IdAgenziaColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property Nome() As String
            Get
                Try 
                    Return CType(Me(Me.tableClienti.NomeColumn),String)
                Catch e As System.InvalidCastException
                    Throw New System.Data.StrongTypingException("The value for column 'Nome' in table 'Clienti' is DBNull.", e)
                End Try
            End Get
            Set
                Me(Me.tableClienti.NomeColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property Cognome() As String
            Get
                Try 
                    Return CType(Me(Me.tableClienti.CognomeColumn),String)
                Catch e As System.InvalidCastException
                    Throw New System.Data.StrongTypingException("The value for column 'Cognome' in table 'Clienti' is DBNull.", e)
                End Try
            End Get
            Set
                Me(Me.tableClienti.CognomeColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property Indirizzo() As String
            Get
                Try 
                    Return CType(Me(Me.tableClienti.IndirizzoColumn),String)
                Catch e As System.InvalidCastException
                    Throw New System.Data.StrongTypingException("The value for column 'Indirizzo' in table 'Clienti' is DBNull.", e)
                End Try
            End Get
            Set
                Me(Me.tableClienti.IndirizzoColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property CAP() As String
            Get
                Try 
                    Return CType(Me(Me.tableClienti.CAPColumn),String)
                Catch e As System.InvalidCastException
                    Throw New System.Data.StrongTypingException("The value for column 'CAP' in table 'Clienti' is DBNull.", e)
                End Try
            End Get
            Set
                Me(Me.tableClienti.CAPColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property Citta() As String
            Get
                Try 
                    Return CType(Me(Me.tableClienti.CittaColumn),String)
                Catch e As System.InvalidCastException
                    Throw New System.Data.StrongTypingException("The value for column 'Citta' in table 'Clienti' is DBNull.", e)
                End Try
            End Get
            Set
                Me(Me.tableClienti.CittaColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property TelefonoPrefisso() As String
            Get
                Try 
                    Return CType(Me(Me.tableClienti.TelefonoPrefissoColumn),String)
                Catch e As System.InvalidCastException
                    Throw New System.Data.StrongTypingException("The value for column 'TelefonoPrefisso' in table 'Clienti' is DBNull.", e)
                End Try
            End Get
            Set
                Me(Me.tableClienti.TelefonoPrefissoColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property TelefonoNumero() As String
            Get
                Try 
                    Return CType(Me(Me.tableClienti.TelefonoNumeroColumn),String)
                Catch e As System.InvalidCastException
                    Throw New System.Data.StrongTypingException("The value for column 'TelefonoNumero' in table 'Clienti' is DBNull.", e)
                End Try
            End Get
            Set
                Me(Me.tableClienti.TelefonoNumeroColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property rowguid() As System.Guid
            Get
                Return CType(Me(Me.tableClienti.rowguidColumn),System.Guid)
            End Get
            Set
                Me(Me.tableClienti.rowguidColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Function IsNomeNull() As Boolean
            Return Me.IsNull(Me.tableClienti.NomeColumn)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub SetNomeNull()
            Me(Me.tableClienti.NomeColumn) = System.Convert.DBNull
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Function IsCognomeNull() As Boolean
            Return Me.IsNull(Me.tableClienti.CognomeColumn)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub SetCognomeNull()
            Me(Me.tableClienti.CognomeColumn) = System.Convert.DBNull
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Function IsIndirizzoNull() As Boolean
            Return Me.IsNull(Me.tableClienti.IndirizzoColumn)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub SetIndirizzoNull()
            Me(Me.tableClienti.IndirizzoColumn) = System.Convert.DBNull
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Function IsCAPNull() As Boolean
            Return Me.IsNull(Me.tableClienti.CAPColumn)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub SetCAPNull()
            Me(Me.tableClienti.CAPColumn) = System.Convert.DBNull
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Function IsCittaNull() As Boolean
            Return Me.IsNull(Me.tableClienti.CittaColumn)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub SetCittaNull()
            Me(Me.tableClienti.CittaColumn) = System.Convert.DBNull
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Function IsTelefonoPrefissoNull() As Boolean
            Return Me.IsNull(Me.tableClienti.TelefonoPrefissoColumn)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub SetTelefonoPrefissoNull()
            Me(Me.tableClienti.TelefonoPrefissoColumn) = System.Convert.DBNull
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Function IsTelefonoNumeroNull() As Boolean
            Return Me.IsNull(Me.tableClienti.TelefonoNumeroColumn)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub SetTelefonoNumeroNull()
            Me(Me.tableClienti.TelefonoNumeroColumn) = System.Convert.DBNull
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Function GetPreventiviRows() As PreventiviRow()
            Return CType(MyBase.GetChildRows(Me.Table.ChildRelations("FK__Preventiv__IdCli__1920BF5C")),PreventiviRow())
        End Function
    End Class
    
    Partial Public Class ImmobiliRow
        Inherits System.Data.DataRow
        
        Private tableImmobili As ImmobiliDataTable
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Friend Sub New(ByVal rb As System.Data.DataRowBuilder)
            MyBase.New(rb)
            Me.tableImmobili = CType(Me.Table,ImmobiliDataTable)
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property IdImmobile() As Integer
            Get
                Return CType(Me(Me.tableImmobili.IdImmobileColumn),Integer)
            End Get
            Set
                Me(Me.tableImmobili.IdImmobileColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property IdAgenzia() As Integer
            Get
                Return CType(Me(Me.tableImmobili.IdAgenziaColumn),Integer)
            End Get
            Set
                Me(Me.tableImmobili.IdAgenziaColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property CodiceImmobile() As String
            Get
                Try 
                    Return CType(Me(Me.tableImmobili.CodiceImmobileColumn),String)
                Catch e As System.InvalidCastException
                    Throw New System.Data.StrongTypingException("The value for column 'CodiceImmobile' in table 'Immobili' is DBNull.", e)
                End Try
            End Get
            Set
                Me(Me.tableImmobili.CodiceImmobileColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property CodiceTipoImmobile() As String
            Get
                Try 
                    Return CType(Me(Me.tableImmobili.CodiceTipoImmobileColumn),String)
                Catch e As System.InvalidCastException
                    Throw New System.Data.StrongTypingException("The value for column 'CodiceTipoImmobile' in table 'Immobili' is DBNull.", e)
                End Try
            End Get
            Set
                Me(Me.tableImmobili.CodiceTipoImmobileColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property RiferimentoInterno() As String
            Get
                Try 
                    Return CType(Me(Me.tableImmobili.RiferimentoInternoColumn),String)
                Catch e As System.InvalidCastException
                    Throw New System.Data.StrongTypingException("The value for column 'RiferimentoInterno' in table 'Immobili' is DBNull.", e)
                End Try
            End Get
            Set
                Me(Me.tableImmobili.RiferimentoInternoColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property DescrizioneLunga() As String
            Get
                Try 
                    Return CType(Me(Me.tableImmobili.DescrizioneLungaColumn),String)
                Catch e As System.InvalidCastException
                    Throw New System.Data.StrongTypingException("The value for column 'DescrizioneLunga' in table 'Immobili' is DBNull.", e)
                End Try
            End Get
            Set
                Me(Me.tableImmobili.DescrizioneLungaColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property DescrizioneBreve() As String
            Get
                Try 
                    Return CType(Me(Me.tableImmobili.DescrizioneBreveColumn),String)
                Catch e As System.InvalidCastException
                    Throw New System.Data.StrongTypingException("The value for column 'DescrizioneBreve' in table 'Immobili' is DBNull.", e)
                End Try
            End Get
            Set
                Me(Me.tableImmobili.DescrizioneBreveColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property Dimensione() As Integer
            Get
                Try 
                    Return CType(Me(Me.tableImmobili.DimensioneColumn),Integer)
                Catch e As System.InvalidCastException
                    Throw New System.Data.StrongTypingException("The value for column 'Dimensione' in table 'Immobili' is DBNull.", e)
                End Try
            End Get
            Set
                Me(Me.tableImmobili.DimensioneColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property Indirizzo() As String
            Get
                Try 
                    Return CType(Me(Me.tableImmobili.IndirizzoColumn),String)
                Catch e As System.InvalidCastException
                    Throw New System.Data.StrongTypingException("The value for column 'Indirizzo' in table 'Immobili' is DBNull.", e)
                End Try
            End Get
            Set
                Me(Me.tableImmobili.IndirizzoColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property CAP() As String
            Get
                Try 
                    Return CType(Me(Me.tableImmobili.CAPColumn),String)
                Catch e As System.InvalidCastException
                    Throw New System.Data.StrongTypingException("The value for column 'CAP' in table 'Immobili' is DBNull.", e)
                End Try
            End Get
            Set
                Me(Me.tableImmobili.CAPColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property Zona() As String
            Get
                Try 
                    Return CType(Me(Me.tableImmobili.ZonaColumn),String)
                Catch e As System.InvalidCastException
                    Throw New System.Data.StrongTypingException("The value for column 'Zona' in table 'Immobili' is DBNull.", e)
                End Try
            End Get
            Set
                Me(Me.tableImmobili.ZonaColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property Citta() As String
            Get
                Try 
                    Return CType(Me(Me.tableImmobili.CittaColumn),String)
                Catch e As System.InvalidCastException
                    Throw New System.Data.StrongTypingException("The value for column 'Citta' in table 'Immobili' is DBNull.", e)
                End Try
            End Get
            Set
                Me(Me.tableImmobili.CittaColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property Foto() As Byte()
            Get
                Try 
                    Return CType(Me(Me.tableImmobili.FotoColumn),Byte())
                Catch e As System.InvalidCastException
                    Throw New System.Data.StrongTypingException("The value for column 'Foto' in table 'Immobili' is DBNull.", e)
                End Try
            End Get
            Set
                Me(Me.tableImmobili.FotoColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property Planimetria() As Byte()
            Get
                Try 
                    Return CType(Me(Me.tableImmobili.PlanimetriaColumn),Byte())
                Catch e As System.InvalidCastException
                    Throw New System.Data.StrongTypingException("The value for column 'Planimetria' in table 'Immobili' is DBNull.", e)
                End Try
            End Get
            Set
                Me(Me.tableImmobili.PlanimetriaColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property PrezzoMin() As Integer
            Get
                Try 
                    Return CType(Me(Me.tableImmobili.PrezzoMinColumn),Integer)
                Catch e As System.InvalidCastException
                    Throw New System.Data.StrongTypingException("The value for column 'PrezzoMin' in table 'Immobili' is DBNull.", e)
                End Try
            End Get
            Set
                Me(Me.tableImmobili.PrezzoMinColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property PrezzoMax() As Integer
            Get
                Try 
                    Return CType(Me(Me.tableImmobili.PrezzoMaxColumn),Integer)
                Catch e As System.InvalidCastException
                    Throw New System.Data.StrongTypingException("The value for column 'PrezzoMax' in table 'Immobili' is DBNull.", e)
                End Try
            End Get
            Set
                Me(Me.tableImmobili.PrezzoMaxColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property SpeseCondominiali() As Integer
            Get
                Try 
                    Return CType(Me(Me.tableImmobili.SpeseCondominialiColumn),Integer)
                Catch e As System.InvalidCastException
                    Throw New System.Data.StrongTypingException("The value for column 'SpeseCondominiali' in table 'Immobili' is DBNull.", e)
                End Try
            End Get
            Set
                Me(Me.tableImmobili.SpeseCondominialiColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property Valutazione() As Integer
            Get
                Try 
                    Return CType(Me(Me.tableImmobili.ValutazioneColumn),Integer)
                Catch e As System.InvalidCastException
                    Throw New System.Data.StrongTypingException("The value for column 'Valutazione' in table 'Immobili' is DBNull.", e)
                End Try
            End Get
            Set
                Me(Me.tableImmobili.ValutazioneColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property rowguid() As System.Guid
            Get
                Return CType(Me(Me.tableImmobili.rowguidColumn),System.Guid)
            End Get
            Set
                Me(Me.tableImmobili.rowguidColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Function IsCodiceImmobileNull() As Boolean
            Return Me.IsNull(Me.tableImmobili.CodiceImmobileColumn)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub SetCodiceImmobileNull()
            Me(Me.tableImmobili.CodiceImmobileColumn) = System.Convert.DBNull
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Function IsCodiceTipoImmobileNull() As Boolean
            Return Me.IsNull(Me.tableImmobili.CodiceTipoImmobileColumn)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub SetCodiceTipoImmobileNull()
            Me(Me.tableImmobili.CodiceTipoImmobileColumn) = System.Convert.DBNull
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Function IsRiferimentoInternoNull() As Boolean
            Return Me.IsNull(Me.tableImmobili.RiferimentoInternoColumn)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub SetRiferimentoInternoNull()
            Me(Me.tableImmobili.RiferimentoInternoColumn) = System.Convert.DBNull
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Function IsDescrizioneLungaNull() As Boolean
            Return Me.IsNull(Me.tableImmobili.DescrizioneLungaColumn)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub SetDescrizioneLungaNull()
            Me(Me.tableImmobili.DescrizioneLungaColumn) = System.Convert.DBNull
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Function IsDescrizioneBreveNull() As Boolean
            Return Me.IsNull(Me.tableImmobili.DescrizioneBreveColumn)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub SetDescrizioneBreveNull()
            Me(Me.tableImmobili.DescrizioneBreveColumn) = System.Convert.DBNull
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Function IsDimensioneNull() As Boolean
            Return Me.IsNull(Me.tableImmobili.DimensioneColumn)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub SetDimensioneNull()
            Me(Me.tableImmobili.DimensioneColumn) = System.Convert.DBNull
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Function IsIndirizzoNull() As Boolean
            Return Me.IsNull(Me.tableImmobili.IndirizzoColumn)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub SetIndirizzoNull()
            Me(Me.tableImmobili.IndirizzoColumn) = System.Convert.DBNull
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Function IsCAPNull() As Boolean
            Return Me.IsNull(Me.tableImmobili.CAPColumn)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub SetCAPNull()
            Me(Me.tableImmobili.CAPColumn) = System.Convert.DBNull
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Function IsZonaNull() As Boolean
            Return Me.IsNull(Me.tableImmobili.ZonaColumn)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub SetZonaNull()
            Me(Me.tableImmobili.ZonaColumn) = System.Convert.DBNull
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Function IsCittaNull() As Boolean
            Return Me.IsNull(Me.tableImmobili.CittaColumn)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub SetCittaNull()
            Me(Me.tableImmobili.CittaColumn) = System.Convert.DBNull
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Function IsFotoNull() As Boolean
            Return Me.IsNull(Me.tableImmobili.FotoColumn)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub SetFotoNull()
            Me(Me.tableImmobili.FotoColumn) = System.Convert.DBNull
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Function IsPlanimetriaNull() As Boolean
            Return Me.IsNull(Me.tableImmobili.PlanimetriaColumn)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub SetPlanimetriaNull()
            Me(Me.tableImmobili.PlanimetriaColumn) = System.Convert.DBNull
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Function IsPrezzoMinNull() As Boolean
            Return Me.IsNull(Me.tableImmobili.PrezzoMinColumn)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub SetPrezzoMinNull()
            Me(Me.tableImmobili.PrezzoMinColumn) = System.Convert.DBNull
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Function IsPrezzoMaxNull() As Boolean
            Return Me.IsNull(Me.tableImmobili.PrezzoMaxColumn)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub SetPrezzoMaxNull()
            Me(Me.tableImmobili.PrezzoMaxColumn) = System.Convert.DBNull
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Function IsSpeseCondominialiNull() As Boolean
            Return Me.IsNull(Me.tableImmobili.SpeseCondominialiColumn)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub SetSpeseCondominialiNull()
            Me(Me.tableImmobili.SpeseCondominialiColumn) = System.Convert.DBNull
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Function IsValutazioneNull() As Boolean
            Return Me.IsNull(Me.tableImmobili.ValutazioneColumn)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub SetValutazioneNull()
            Me(Me.tableImmobili.ValutazioneColumn) = System.Convert.DBNull
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Function GetPreventiviRows() As PreventiviRow()
            Return CType(MyBase.GetChildRows(Me.Table.ChildRelations("FK__Preventiv__IdImm__1BFD2C07")),PreventiviRow())
        End Function
    End Class
    
    Partial Public Class PreventiviRow
        Inherits System.Data.DataRow
        
        Private tablePreventivi As PreventiviDataTable
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Friend Sub New(ByVal rb As System.Data.DataRowBuilder)
            MyBase.New(rb)
            Me.tablePreventivi = CType(Me.Table,PreventiviDataTable)
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property IdPreventivo() As Integer
            Get
                Return CType(Me(Me.tablePreventivi.IdPreventivoColumn),Integer)
            End Get
            Set
                Me(Me.tablePreventivi.IdPreventivoColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property IdCliente() As Integer
            Get
                Return CType(Me(Me.tablePreventivi.IdClienteColumn),Integer)
            End Get
            Set
                Me(Me.tablePreventivi.IdClienteColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property IdImmobile() As Integer
            Get
                Return CType(Me(Me.tablePreventivi.IdImmobileColumn),Integer)
            End Get
            Set
                Me(Me.tablePreventivi.IdImmobileColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property IdAgente() As Integer
            Get
                Return CType(Me(Me.tablePreventivi.IdAgenteColumn),Integer)
            End Get
            Set
                Me(Me.tablePreventivi.IdAgenteColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property Appuntamento() As Date
            Get
                Try 
                    Return CType(Me(Me.tablePreventivi.AppuntamentoColumn),Date)
                Catch e As System.InvalidCastException
                    Throw New System.Data.StrongTypingException("The value for column 'Appuntamento' in table 'Preventivi' is DBNull.", e)
                End Try
            End Get
            Set
                Me(Me.tablePreventivi.AppuntamentoColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property CodiceTipoOffertaImmobile() As String
            Get
                Try 
                    Return CType(Me(Me.tablePreventivi.CodiceTipoOffertaImmobileColumn),String)
                Catch e As System.InvalidCastException
                    Throw New System.Data.StrongTypingException("The value for column 'CodiceTipoOffertaImmobile' in table 'Preventivi' is DBNull."& _ 
                            "", e)
                End Try
            End Get
            Set
                Me(Me.tablePreventivi.CodiceTipoOffertaImmobileColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property rowguid() As System.Guid
            Get
                Return CType(Me(Me.tablePreventivi.rowguidColumn),System.Guid)
            End Get
            Set
                Me(Me.tablePreventivi.rowguidColumn) = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property AgentiRow() As AgentiRow
            Get
                Return CType(Me.GetParentRow(Me.Table.ParentRelations("FK__Preventiv__IdAge__1B0907CE")),AgentiRow)
            End Get
            Set
                Me.SetParentRow(value, Me.Table.ParentRelations("FK__Preventiv__IdAge__1B0907CE"))
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property ClientiRow() As ClientiRow
            Get
                Return CType(Me.GetParentRow(Me.Table.ParentRelations("FK__Preventiv__IdCli__1920BF5C")),ClientiRow)
            End Get
            Set
                Me.SetParentRow(value, Me.Table.ParentRelations("FK__Preventiv__IdCli__1920BF5C"))
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property ImmobiliRow() As ImmobiliRow
            Get
                Return CType(Me.GetParentRow(Me.Table.ParentRelations("FK__Preventiv__IdImm__1BFD2C07")),ImmobiliRow)
            End Get
            Set
                Me.SetParentRow(value, Me.Table.ParentRelations("FK__Preventiv__IdImm__1BFD2C07"))
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Function IsAppuntamentoNull() As Boolean
            Return Me.IsNull(Me.tablePreventivi.AppuntamentoColumn)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub SetAppuntamentoNull()
            Me(Me.tablePreventivi.AppuntamentoColumn) = System.Convert.DBNull
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Function IsCodiceTipoOffertaImmobileNull() As Boolean
            Return Me.IsNull(Me.tablePreventivi.CodiceTipoOffertaImmobileColumn)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub SetCodiceTipoOffertaImmobileNull()
            Me(Me.tablePreventivi.CodiceTipoOffertaImmobileColumn) = System.Convert.DBNull
        End Sub
    End Class
    
    Public Class AgentiRowChangeEvent
        Inherits System.EventArgs
        
        Private eventRow As AgentiRow
        
        Private eventAction As System.Data.DataRowAction
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub New(ByVal row As AgentiRow, ByVal action As System.Data.DataRowAction)
            MyBase.New
            Me.eventRow = row
            Me.eventAction = action
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property Row() As AgentiRow
            Get
                Return Me.eventRow
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property Action() As System.Data.DataRowAction
            Get
                Return Me.eventAction
            End Get
        End Property
    End Class
    
    Public Class ClientiRowChangeEvent
        Inherits System.EventArgs
        
        Private eventRow As ClientiRow
        
        Private eventAction As System.Data.DataRowAction
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub New(ByVal row As ClientiRow, ByVal action As System.Data.DataRowAction)
            MyBase.New
            Me.eventRow = row
            Me.eventAction = action
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property Row() As ClientiRow
            Get
                Return Me.eventRow
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property Action() As System.Data.DataRowAction
            Get
                Return Me.eventAction
            End Get
        End Property
    End Class
    
    Public Class ImmobiliRowChangeEvent
        Inherits System.EventArgs
        
        Private eventRow As ImmobiliRow
        
        Private eventAction As System.Data.DataRowAction
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub New(ByVal row As ImmobiliRow, ByVal action As System.Data.DataRowAction)
            MyBase.New
            Me.eventRow = row
            Me.eventAction = action
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property Row() As ImmobiliRow
            Get
                Return Me.eventRow
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property Action() As System.Data.DataRowAction
            Get
                Return Me.eventAction
            End Get
        End Property
    End Class
    
    Public Class PreventiviRowChangeEvent
        Inherits System.EventArgs
        
        Private eventRow As PreventiviRow
        
        Private eventAction As System.Data.DataRowAction
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub New(ByVal row As PreventiviRow, ByVal action As System.Data.DataRowAction)
            MyBase.New
            Me.eventRow = row
            Me.eventAction = action
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property Row() As PreventiviRow
            Get
                Return Me.eventRow
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public ReadOnly Property Action() As System.Data.DataRowAction
            Get
                Return Me.eventAction
            End Get
        End Property
    End Class
End Class

Namespace SmartEstateDataSetTableAdapters
    
    <System.ComponentModel.DesignerCategoryAttribute("code"),  _
     System.ComponentModel.DataObjectAttribute(true)>  _
    Partial Public Class AgentiTableAdapter
        Inherits System.ComponentModel.Component
        
        Private WithEvents _adapter As System.Data.SqlServerCe.SqlCeDataAdapter
        
        Private _connection As System.Data.SqlServerCe.SqlCeConnection
        
        Private _commandCollection() As System.Data.SqlServerCe.SqlCeCommand
        
        Private _clearBeforeFill As Boolean
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub New()
            MyBase.New
            Me.ClearBeforeFill = true
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Private ReadOnly Property Adapter() As System.Data.SqlServerCe.SqlCeDataAdapter
            Get
                If (Me._adapter Is Nothing) Then
                    Me.InitAdapter
                End If
                Return Me._adapter
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Friend Property Connection() As System.Data.SqlServerCe.SqlCeConnection
            Get
                If (Me._connection Is Nothing) Then
                    Me.InitConnection
                End If
                Return Me._connection
            End Get
            Set
                Me._connection = value
                If (Not (Me.Adapter.InsertCommand) Is Nothing) Then
                    Me.Adapter.InsertCommand.Connection = value
                End If
                If (Not (Me.Adapter.DeleteCommand) Is Nothing) Then
                    Me.Adapter.DeleteCommand.Connection = value
                End If
                If (Not (Me.Adapter.UpdateCommand) Is Nothing) Then
                    Me.Adapter.UpdateCommand.Connection = value
                End If
                Dim i As Integer = 0
                Do While (i < Me.CommandCollection.Length)
                    If (Not (Me.CommandCollection(i)) Is Nothing) Then
                        CType(Me.CommandCollection(i),System.Data.SqlServerCe.SqlCeCommand).Connection = value
                    End If
                    i = (i + 1)
                Loop
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Protected ReadOnly Property CommandCollection() As System.Data.SqlServerCe.SqlCeCommand()
            Get
                If (Me._commandCollection Is Nothing) Then
                    Me.InitCommandCollection
                End If
                Return Me._commandCollection
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property ClearBeforeFill() As Boolean
            Get
                Return Me._clearBeforeFill
            End Get
            Set
                Me._clearBeforeFill = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Private Sub InitAdapter()
            Me._adapter = New System.Data.SqlServerCe.SqlCeDataAdapter
            Dim tableMapping As System.Data.Common.DataTableMapping = New System.Data.Common.DataTableMapping
            tableMapping.SourceTable = "Table"
            tableMapping.DataSetTable = "Agenti"
            tableMapping.ColumnMappings.Add("IdAgente", "IdAgente")
            tableMapping.ColumnMappings.Add("Indirizzo", "Indirizzo")
            tableMapping.ColumnMappings.Add("CAP", "CAP")
            tableMapping.ColumnMappings.Add("Citta", "Citta")
            tableMapping.ColumnMappings.Add("IdAgenzia", "IdAgenzia")
            tableMapping.ColumnMappings.Add("TelefonoNumero", "TelefonoNumero")
            tableMapping.ColumnMappings.Add("Nome", "Nome")
            tableMapping.ColumnMappings.Add("TelefonoPrefisso", "TelefonoPrefisso")
            tableMapping.ColumnMappings.Add("Cognome", "Cognome")
            tableMapping.ColumnMappings.Add("Email", "Email")
            tableMapping.ColumnMappings.Add("SysDataInsert", "SysDataInsert")
            tableMapping.ColumnMappings.Add("SysIdUtenteInsert", "SysIdUtenteInsert")
            tableMapping.ColumnMappings.Add("SysDataUpdate", "SysDataUpdate")
            tableMapping.ColumnMappings.Add("SysIdUtenteUpdate", "SysIdUtenteUpdate")
            tableMapping.ColumnMappings.Add("SysGUID", "SysGUID")
            tableMapping.ColumnMappings.Add("rowguid", "rowguid")
            Me._adapter.TableMappings.Add(tableMapping)
            Me._adapter.DeleteCommand = New System.Data.SqlServerCe.SqlCeCommand
            Me._adapter.DeleteCommand.Connection = Me.Connection
            Me._adapter.DeleteCommand.CommandText = "DELETE FROM [Agenti] WHERE (([IdAgente] = @p1))"
            Me._adapter.DeleteCommand.CommandType = System.Data.CommandType.Text
            Dim param As System.Data.SqlServerCe.SqlCeParameter = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p1"
            param.DbType = System.Data.DbType.Int32
            param.IsNullable = true
            param.SourceColumn = "IdAgente"
            param.SourceVersion = System.Data.DataRowVersion.Original
            Me._adapter.DeleteCommand.Parameters.Add(param)
            Me._adapter.InsertCommand = New System.Data.SqlServerCe.SqlCeCommand
            Me._adapter.InsertCommand.Connection = Me.Connection
            Me._adapter.InsertCommand.CommandText = "INSERT INTO [Agenti] ([Indirizzo], [CAP], [Citta], [IdAgenzia], [TelefonoNumero],"& _ 
                " [Nome], [TelefonoPrefisso], [Cognome], [Email], [SysDataInsert], [SysIdUtenteIn"& _ 
                "sert], [SysDataUpdate], [SysIdUtenteUpdate], [SysGUID]) VALUES (@p1, @p2, @p3, @"& _ 
                "p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14)"
            Me._adapter.InsertCommand.CommandType = System.Data.CommandType.Text
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p1"
            param.IsNullable = true
            param.SourceColumn = "Indirizzo"
            Me._adapter.InsertCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p2"
            param.DbType = System.Data.DbType.StringFixedLength
            param.IsNullable = true
            param.SourceColumn = "CAP"
            Me._adapter.InsertCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p3"
            param.IsNullable = true
            param.SourceColumn = "Citta"
            Me._adapter.InsertCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p4"
            param.DbType = System.Data.DbType.Int32
            param.IsNullable = true
            param.SourceColumn = "IdAgenzia"
            Me._adapter.InsertCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p5"
            param.IsNullable = true
            param.SourceColumn = "TelefonoNumero"
            Me._adapter.InsertCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p6"
            param.IsNullable = true
            param.SourceColumn = "Nome"
            Me._adapter.InsertCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p7"
            param.IsNullable = true
            param.SourceColumn = "TelefonoPrefisso"
            Me._adapter.InsertCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p8"
            param.IsNullable = true
            param.SourceColumn = "Cognome"
            Me._adapter.InsertCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p9"
            param.IsNullable = true
            param.SourceColumn = "Email"
            Me._adapter.InsertCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p10"
            param.DbType = System.Data.DbType.DateTime
            param.IsNullable = true
            param.SourceColumn = "SysDataInsert"
            Me._adapter.InsertCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p11"
            param.IsNullable = true
            param.SourceColumn = "SysIdUtenteInsert"
            Me._adapter.InsertCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p12"
            param.DbType = System.Data.DbType.DateTime
            param.IsNullable = true
            param.SourceColumn = "SysDataUpdate"
            Me._adapter.InsertCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p13"
            param.IsNullable = true
            param.SourceColumn = "SysIdUtenteUpdate"
            Me._adapter.InsertCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p14"
            param.DbType = System.Data.DbType.Guid
            param.IsNullable = true
            param.SourceColumn = "SysGUID"
            Me._adapter.InsertCommand.Parameters.Add(param)
            Me._adapter.UpdateCommand = New System.Data.SqlServerCe.SqlCeCommand
            Me._adapter.UpdateCommand.Connection = Me.Connection
            Me._adapter.UpdateCommand.CommandText = "UPDATE [Agenti] SET [Indirizzo] = @p1, [CAP] = @p2, [Citta] = @p3, [IdAgenzia] = "& _ 
                "@p4, [TelefonoNumero] = @p5, [Nome] = @p6, [TelefonoPrefisso] = @p7, [Cognome] ="& _ 
                " @p8, [Email] = @p9, [SysDataInsert] = @p10, [SysIdUtenteInsert] = @p11, [SysDat"& _ 
                "aUpdate] = @p12, [SysIdUtenteUpdate] = @p13, [SysGUID] = @p14 WHERE (([IdAgente]"& _ 
                " = @p15))"
            Me._adapter.UpdateCommand.CommandType = System.Data.CommandType.Text
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p1"
            param.IsNullable = true
            param.SourceColumn = "Indirizzo"
            Me._adapter.UpdateCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p2"
            param.DbType = System.Data.DbType.StringFixedLength
            param.IsNullable = true
            param.SourceColumn = "CAP"
            Me._adapter.UpdateCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p3"
            param.IsNullable = true
            param.SourceColumn = "Citta"
            Me._adapter.UpdateCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p4"
            param.DbType = System.Data.DbType.Int32
            param.IsNullable = true
            param.SourceColumn = "IdAgenzia"
            Me._adapter.UpdateCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p5"
            param.IsNullable = true
            param.SourceColumn = "TelefonoNumero"
            Me._adapter.UpdateCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p6"
            param.IsNullable = true
            param.SourceColumn = "Nome"
            Me._adapter.UpdateCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p7"
            param.IsNullable = true
            param.SourceColumn = "TelefonoPrefisso"
            Me._adapter.UpdateCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p8"
            param.IsNullable = true
            param.SourceColumn = "Cognome"
            Me._adapter.UpdateCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p9"
            param.IsNullable = true
            param.SourceColumn = "Email"
            Me._adapter.UpdateCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p10"
            param.DbType = System.Data.DbType.DateTime
            param.IsNullable = true
            param.SourceColumn = "SysDataInsert"
            Me._adapter.UpdateCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p11"
            param.IsNullable = true
            param.SourceColumn = "SysIdUtenteInsert"
            Me._adapter.UpdateCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p12"
            param.DbType = System.Data.DbType.DateTime
            param.IsNullable = true
            param.SourceColumn = "SysDataUpdate"
            Me._adapter.UpdateCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p13"
            param.IsNullable = true
            param.SourceColumn = "SysIdUtenteUpdate"
            Me._adapter.UpdateCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p14"
            param.DbType = System.Data.DbType.Guid
            param.IsNullable = true
            param.SourceColumn = "SysGUID"
            Me._adapter.UpdateCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p15"
            param.DbType = System.Data.DbType.Int32
            param.IsNullable = true
            param.SourceColumn = "IdAgente"
            param.SourceVersion = System.Data.DataRowVersion.Original
            Me._adapter.UpdateCommand.Parameters.Add(param)
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Private Sub InitConnection()
            Me._connection = New System.Data.SqlServerCe.SqlCeConnection
            Me._connection.ConnectionString = ("Data Source ="  _
                        + (System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly.GetName.CodeBase) + "\SmartEstate.sdf;"))
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Private Sub InitCommandCollection()
            Me._commandCollection = New System.Data.SqlServerCe.SqlCeCommand(0) {}
            Me._commandCollection(0) = New System.Data.SqlServerCe.SqlCeCommand
            Me._commandCollection(0).Connection = Me.Connection
            Me._commandCollection(0).CommandText = "SELECT [IdAgente], [Indirizzo], [CAP], [Citta], [IdAgenzia], [TelefonoNumero], [N"& _ 
                "ome], [TelefonoPrefisso], [Cognome], [Email], [SysDataInsert], [SysIdUtenteInser"& _ 
                "t], [SysDataUpdate], [SysIdUtenteUpdate], [SysGUID], [rowguid] FROM [Agenti]"
            Me._commandCollection(0).CommandType = System.Data.CommandType.Text
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute(),  _
         System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Fill, true)>  _
        Public Overloads Overridable Function Fill(ByVal dataTable As SmartEstateDataSet.AgentiDataTable) As Integer
            Me.Adapter.SelectCommand = Me.CommandCollection(0)
            If (Me.ClearBeforeFill = true) Then
                dataTable.Clear
            End If
            Dim returnValue As Integer = Me.Adapter.Fill(dataTable)
            Return returnValue
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute(),  _
         System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.[Select], true)>  _
        Public Overloads Overridable Function GetData() As SmartEstateDataSet.AgentiDataTable
            Me.Adapter.SelectCommand = Me.CommandCollection(0)
            Dim dataTable As SmartEstateDataSet.AgentiDataTable = New SmartEstateDataSet.AgentiDataTable
            Me.Adapter.Fill(dataTable)
            Return dataTable
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Overloads Overridable Function Update(ByVal dataTable As SmartEstateDataSet.AgentiDataTable) As Integer
            Return Me.Adapter.Update(dataTable)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Overloads Overridable Function Update(ByVal dataSet As SmartEstateDataSet) As Integer
            Return Me.Adapter.Update(dataSet, "Agenti")
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Overloads Overridable Function Update(ByVal dataRow As System.Data.DataRow) As Integer
            Return Me.Adapter.Update(New System.Data.DataRow() {dataRow})
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Overloads Overridable Function Update(ByVal dataRows() As System.Data.DataRow) As Integer
            Return Me.Adapter.Update(dataRows)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute(),  _
         System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Delete, true)>  _
        Public Overloads Overridable Function Delete(ByVal p1 As Integer) As Integer
            Me.Adapter.DeleteCommand.Parameters(0).Value = CType(p1,Integer)
            Dim previousConnectionState As System.Data.ConnectionState = Me.Adapter.DeleteCommand.Connection.State
            If ((Me.Adapter.DeleteCommand.Connection.State And System.Data.ConnectionState.Open)  _
                        <> System.Data.ConnectionState.Open) Then
                Me.Adapter.DeleteCommand.Connection.Open
            End If
            Try 
                Dim returnValue As Integer = Me.Adapter.DeleteCommand.ExecuteNonQuery
                Return returnValue
            Finally
                If (previousConnectionState = System.Data.ConnectionState.Closed) Then
                    Me.Adapter.DeleteCommand.Connection.Close
                End If
            End Try
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute(),  _
         System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Insert, true)>  _
        Public Overloads Overridable Function Insert(ByVal p1 As String, ByVal p2 As String, ByVal p3 As String, ByVal p4 As System.Nullable(Of Integer), ByVal p5 As String, ByVal p6 As String, ByVal p7 As String, ByVal p8 As String, ByVal p9 As String, ByVal p10 As System.Nullable(Of Date), ByVal p11 As String, ByVal p12 As System.Nullable(Of Date), ByVal p13 As String, ByVal p14 As System.Nullable(Of System.Guid)) As Integer
            If (p1 Is Nothing) Then
                Me.Adapter.InsertCommand.Parameters(0).Value = System.DBNull.Value
            Else
                Me.Adapter.InsertCommand.Parameters(0).Value = CType(p1,String)
            End If
            If (p2 Is Nothing) Then
                Throw New System.ArgumentNullException("p2")
            Else
                Me.Adapter.InsertCommand.Parameters(1).Value = CType(p2,String)
            End If
            If (p3 Is Nothing) Then
                Me.Adapter.InsertCommand.Parameters(2).Value = System.DBNull.Value
            Else
                Me.Adapter.InsertCommand.Parameters(2).Value = CType(p3,String)
            End If
            If (p4.HasValue = true) Then
                Me.Adapter.InsertCommand.Parameters(3).Value = CType(p4.Value,Integer)
            Else
                Me.Adapter.InsertCommand.Parameters(3).Value = System.DBNull.Value
            End If
            If (p5 Is Nothing) Then
                Me.Adapter.InsertCommand.Parameters(4).Value = System.DBNull.Value
            Else
                Me.Adapter.InsertCommand.Parameters(4).Value = CType(p5,String)
            End If
            If (p6 Is Nothing) Then
                Me.Adapter.InsertCommand.Parameters(5).Value = System.DBNull.Value
            Else
                Me.Adapter.InsertCommand.Parameters(5).Value = CType(p6,String)
            End If
            If (p7 Is Nothing) Then
                Me.Adapter.InsertCommand.Parameters(6).Value = System.DBNull.Value
            Else
                Me.Adapter.InsertCommand.Parameters(6).Value = CType(p7,String)
            End If
            If (p8 Is Nothing) Then
                Me.Adapter.InsertCommand.Parameters(7).Value = System.DBNull.Value
            Else
                Me.Adapter.InsertCommand.Parameters(7).Value = CType(p8,String)
            End If
            If (p9 Is Nothing) Then
                Me.Adapter.InsertCommand.Parameters(8).Value = System.DBNull.Value
            Else
                Me.Adapter.InsertCommand.Parameters(8).Value = CType(p9,String)
            End If
            If (p10.HasValue = true) Then
                Me.Adapter.InsertCommand.Parameters(9).Value = CType(p10.Value,Date)
            Else
                Me.Adapter.InsertCommand.Parameters(9).Value = System.DBNull.Value
            End If
            If (p11 Is Nothing) Then
                Me.Adapter.InsertCommand.Parameters(10).Value = System.DBNull.Value
            Else
                Me.Adapter.InsertCommand.Parameters(10).Value = CType(p11,String)
            End If
            If (p12.HasValue = true) Then
                Me.Adapter.InsertCommand.Parameters(11).Value = CType(p12.Value,Date)
            Else
                Me.Adapter.InsertCommand.Parameters(11).Value = System.DBNull.Value
            End If
            If (p13 Is Nothing) Then
                Me.Adapter.InsertCommand.Parameters(12).Value = System.DBNull.Value
            Else
                Me.Adapter.InsertCommand.Parameters(12).Value = CType(p13,String)
            End If
            If (p14.HasValue = true) Then
                Me.Adapter.InsertCommand.Parameters(13).Value = CType(p14.Value,System.Guid)
            Else
                Me.Adapter.InsertCommand.Parameters(13).Value = System.DBNull.Value
            End If
            Dim previousConnectionState As System.Data.ConnectionState = Me.Adapter.InsertCommand.Connection.State
            If ((Me.Adapter.InsertCommand.Connection.State And System.Data.ConnectionState.Open)  _
                        <> System.Data.ConnectionState.Open) Then
                Me.Adapter.InsertCommand.Connection.Open
            End If
            Try 
                Dim returnValue As Integer = Me.Adapter.InsertCommand.ExecuteNonQuery
                Return returnValue
            Finally
                If (previousConnectionState = System.Data.ConnectionState.Closed) Then
                    Me.Adapter.InsertCommand.Connection.Close
                End If
            End Try
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute(),  _
         System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Update, true)>  _
        Public Overloads Overridable Function Update(ByVal p1 As String, ByVal p2 As String, ByVal p3 As String, ByVal p4 As System.Nullable(Of Integer), ByVal p5 As String, ByVal p6 As String, ByVal p7 As String, ByVal p8 As String, ByVal p9 As String, ByVal p10 As System.Nullable(Of Date), ByVal p11 As String, ByVal p12 As System.Nullable(Of Date), ByVal p13 As String, ByVal p14 As System.Nullable(Of System.Guid), ByVal p15 As Integer) As Integer
            If (p1 Is Nothing) Then
                Me.Adapter.UpdateCommand.Parameters(0).Value = System.DBNull.Value
            Else
                Me.Adapter.UpdateCommand.Parameters(0).Value = CType(p1,String)
            End If
            If (p2 Is Nothing) Then
                Throw New System.ArgumentNullException("p2")
            Else
                Me.Adapter.UpdateCommand.Parameters(1).Value = CType(p2,String)
            End If
            If (p3 Is Nothing) Then
                Me.Adapter.UpdateCommand.Parameters(2).Value = System.DBNull.Value
            Else
                Me.Adapter.UpdateCommand.Parameters(2).Value = CType(p3,String)
            End If
            If (p4.HasValue = true) Then
                Me.Adapter.UpdateCommand.Parameters(3).Value = CType(p4.Value,Integer)
            Else
                Me.Adapter.UpdateCommand.Parameters(3).Value = System.DBNull.Value
            End If
            If (p5 Is Nothing) Then
                Me.Adapter.UpdateCommand.Parameters(4).Value = System.DBNull.Value
            Else
                Me.Adapter.UpdateCommand.Parameters(4).Value = CType(p5,String)
            End If
            If (p6 Is Nothing) Then
                Me.Adapter.UpdateCommand.Parameters(5).Value = System.DBNull.Value
            Else
                Me.Adapter.UpdateCommand.Parameters(5).Value = CType(p6,String)
            End If
            If (p7 Is Nothing) Then
                Me.Adapter.UpdateCommand.Parameters(6).Value = System.DBNull.Value
            Else
                Me.Adapter.UpdateCommand.Parameters(6).Value = CType(p7,String)
            End If
            If (p8 Is Nothing) Then
                Me.Adapter.UpdateCommand.Parameters(7).Value = System.DBNull.Value
            Else
                Me.Adapter.UpdateCommand.Parameters(7).Value = CType(p8,String)
            End If
            If (p9 Is Nothing) Then
                Me.Adapter.UpdateCommand.Parameters(8).Value = System.DBNull.Value
            Else
                Me.Adapter.UpdateCommand.Parameters(8).Value = CType(p9,String)
            End If
            If (p10.HasValue = true) Then
                Me.Adapter.UpdateCommand.Parameters(9).Value = CType(p10.Value,Date)
            Else
                Me.Adapter.UpdateCommand.Parameters(9).Value = System.DBNull.Value
            End If
            If (p11 Is Nothing) Then
                Me.Adapter.UpdateCommand.Parameters(10).Value = System.DBNull.Value
            Else
                Me.Adapter.UpdateCommand.Parameters(10).Value = CType(p11,String)
            End If
            If (p12.HasValue = true) Then
                Me.Adapter.UpdateCommand.Parameters(11).Value = CType(p12.Value,Date)
            Else
                Me.Adapter.UpdateCommand.Parameters(11).Value = System.DBNull.Value
            End If
            If (p13 Is Nothing) Then
                Me.Adapter.UpdateCommand.Parameters(12).Value = System.DBNull.Value
            Else
                Me.Adapter.UpdateCommand.Parameters(12).Value = CType(p13,String)
            End If
            If (p14.HasValue = true) Then
                Me.Adapter.UpdateCommand.Parameters(13).Value = CType(p14.Value,System.Guid)
            Else
                Me.Adapter.UpdateCommand.Parameters(13).Value = System.DBNull.Value
            End If
            Me.Adapter.UpdateCommand.Parameters(14).Value = CType(p15,Integer)
            Dim previousConnectionState As System.Data.ConnectionState = Me.Adapter.UpdateCommand.Connection.State
            If ((Me.Adapter.UpdateCommand.Connection.State And System.Data.ConnectionState.Open)  _
                        <> System.Data.ConnectionState.Open) Then
                Me.Adapter.UpdateCommand.Connection.Open
            End If
            Try 
                Dim returnValue As Integer = Me.Adapter.UpdateCommand.ExecuteNonQuery
                Return returnValue
            Finally
                If (previousConnectionState = System.Data.ConnectionState.Closed) Then
                    Me.Adapter.UpdateCommand.Connection.Close
                End If
            End Try
        End Function
    End Class
    
    <System.ComponentModel.DesignerCategoryAttribute("code"),  _
     System.ComponentModel.DataObjectAttribute(true)>  _
    Partial Public Class ClientiTableAdapter
        Inherits System.ComponentModel.Component
        
        Private WithEvents _adapter As System.Data.SqlServerCe.SqlCeDataAdapter
        
        Private _connection As System.Data.SqlServerCe.SqlCeConnection
        
        Private _commandCollection() As System.Data.SqlServerCe.SqlCeCommand
        
        Private _clearBeforeFill As Boolean
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub New()
            MyBase.New
            Me.ClearBeforeFill = true
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Private ReadOnly Property Adapter() As System.Data.SqlServerCe.SqlCeDataAdapter
            Get
                If (Me._adapter Is Nothing) Then
                    Me.InitAdapter
                End If
                Return Me._adapter
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Friend Property Connection() As System.Data.SqlServerCe.SqlCeConnection
            Get
                If (Me._connection Is Nothing) Then
                    Me.InitConnection
                End If
                Return Me._connection
            End Get
            Set
                Me._connection = value
                If (Not (Me.Adapter.InsertCommand) Is Nothing) Then
                    Me.Adapter.InsertCommand.Connection = value
                End If
                If (Not (Me.Adapter.DeleteCommand) Is Nothing) Then
                    Me.Adapter.DeleteCommand.Connection = value
                End If
                If (Not (Me.Adapter.UpdateCommand) Is Nothing) Then
                    Me.Adapter.UpdateCommand.Connection = value
                End If
                Dim i As Integer = 0
                Do While (i < Me.CommandCollection.Length)
                    If (Not (Me.CommandCollection(i)) Is Nothing) Then
                        CType(Me.CommandCollection(i),System.Data.SqlServerCe.SqlCeCommand).Connection = value
                    End If
                    i = (i + 1)
                Loop
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Protected ReadOnly Property CommandCollection() As System.Data.SqlServerCe.SqlCeCommand()
            Get
                If (Me._commandCollection Is Nothing) Then
                    Me.InitCommandCollection
                End If
                Return Me._commandCollection
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property ClearBeforeFill() As Boolean
            Get
                Return Me._clearBeforeFill
            End Get
            Set
                Me._clearBeforeFill = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Private Sub InitAdapter()
            Me._adapter = New System.Data.SqlServerCe.SqlCeDataAdapter
            Dim tableMapping As System.Data.Common.DataTableMapping = New System.Data.Common.DataTableMapping
            tableMapping.SourceTable = "Table"
            tableMapping.DataSetTable = "Clienti"
            tableMapping.ColumnMappings.Add("IdCliente", "IdCliente")
            tableMapping.ColumnMappings.Add("IdAgenzia", "IdAgenzia")
            tableMapping.ColumnMappings.Add("Nome", "Nome")
            tableMapping.ColumnMappings.Add("Cognome", "Cognome")
            tableMapping.ColumnMappings.Add("Indirizzo", "Indirizzo")
            tableMapping.ColumnMappings.Add("CAP", "CAP")
            tableMapping.ColumnMappings.Add("Citta", "Citta")
            tableMapping.ColumnMappings.Add("TelefonoPrefisso", "TelefonoPrefisso")
            tableMapping.ColumnMappings.Add("TelefonoNumero", "TelefonoNumero")
            tableMapping.ColumnMappings.Add("rowguid", "rowguid")
            Me._adapter.TableMappings.Add(tableMapping)
            Me._adapter.DeleteCommand = New System.Data.SqlServerCe.SqlCeCommand
            Me._adapter.DeleteCommand.Connection = Me.Connection
            Me._adapter.DeleteCommand.CommandText = "DELETE FROM [Clienti] WHERE (([IdCliente] = @p1))"
            Me._adapter.DeleteCommand.CommandType = System.Data.CommandType.Text
            Dim param As System.Data.SqlServerCe.SqlCeParameter = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p1"
            param.DbType = System.Data.DbType.Int32
            param.IsNullable = true
            param.SourceColumn = "IdCliente"
            param.SourceVersion = System.Data.DataRowVersion.Original
            Me._adapter.DeleteCommand.Parameters.Add(param)
            Me._adapter.InsertCommand = New System.Data.SqlServerCe.SqlCeCommand
            Me._adapter.InsertCommand.Connection = Me.Connection
            Me._adapter.InsertCommand.CommandText = "INSERT INTO [Clienti] ([IdAgenzia], [Nome], [Cognome], [Indirizzo], [CAP], [Citta"& _ 
                "], [TelefonoPrefisso], [TelefonoNumero]) VALUES (@p1, @p2, @p3, @p4, @p5, @p6, @"& _ 
                "p7, @p8)"
            Me._adapter.InsertCommand.CommandType = System.Data.CommandType.Text
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p1"
            param.DbType = System.Data.DbType.Int32
            param.IsNullable = true
            param.SourceColumn = "IdAgenzia"
            Me._adapter.InsertCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p2"
            param.IsNullable = true
            param.SourceColumn = "Nome"
            Me._adapter.InsertCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p3"
            param.IsNullable = true
            param.SourceColumn = "Cognome"
            Me._adapter.InsertCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p4"
            param.IsNullable = true
            param.SourceColumn = "Indirizzo"
            Me._adapter.InsertCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p5"
            param.IsNullable = true
            param.SourceColumn = "CAP"
            Me._adapter.InsertCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p6"
            param.IsNullable = true
            param.SourceColumn = "Citta"
            Me._adapter.InsertCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p7"
            param.IsNullable = true
            param.SourceColumn = "TelefonoPrefisso"
            Me._adapter.InsertCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p8"
            param.IsNullable = true
            param.SourceColumn = "TelefonoNumero"
            Me._adapter.InsertCommand.Parameters.Add(param)
            Me._adapter.UpdateCommand = New System.Data.SqlServerCe.SqlCeCommand
            Me._adapter.UpdateCommand.Connection = Me.Connection
            Me._adapter.UpdateCommand.CommandText = "UPDATE [Clienti] SET [IdAgenzia] = @p1, [Nome] = @p2, [Cognome] = @p3, [Indirizzo"& _ 
                "] = @p4, [CAP] = @p5, [Citta] = @p6, [TelefonoPrefisso] = @p7, [TelefonoNumero] "& _ 
                "= @p8 WHERE (([IdCliente] = @p9))"
            Me._adapter.UpdateCommand.CommandType = System.Data.CommandType.Text
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p1"
            param.DbType = System.Data.DbType.Int32
            param.IsNullable = true
            param.SourceColumn = "IdAgenzia"
            Me._adapter.UpdateCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p2"
            param.IsNullable = true
            param.SourceColumn = "Nome"
            Me._adapter.UpdateCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p3"
            param.IsNullable = true
            param.SourceColumn = "Cognome"
            Me._adapter.UpdateCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p4"
            param.IsNullable = true
            param.SourceColumn = "Indirizzo"
            Me._adapter.UpdateCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p5"
            param.IsNullable = true
            param.SourceColumn = "CAP"
            Me._adapter.UpdateCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p6"
            param.IsNullable = true
            param.SourceColumn = "Citta"
            Me._adapter.UpdateCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p7"
            param.IsNullable = true
            param.SourceColumn = "TelefonoPrefisso"
            Me._adapter.UpdateCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p8"
            param.IsNullable = true
            param.SourceColumn = "TelefonoNumero"
            Me._adapter.UpdateCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p9"
            param.DbType = System.Data.DbType.Int32
            param.IsNullable = true
            param.SourceColumn = "IdCliente"
            param.SourceVersion = System.Data.DataRowVersion.Original
            Me._adapter.UpdateCommand.Parameters.Add(param)
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Private Sub InitConnection()
            Me._connection = New System.Data.SqlServerCe.SqlCeConnection
            Me._connection.ConnectionString = ("Data Source ="  _
                        + (System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly.GetName.CodeBase) + "\SmartEstate.sdf;"))
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Private Sub InitCommandCollection()
            Me._commandCollection = New System.Data.SqlServerCe.SqlCeCommand(0) {}
            Me._commandCollection(0) = New System.Data.SqlServerCe.SqlCeCommand
            Me._commandCollection(0).Connection = Me.Connection
            Me._commandCollection(0).CommandText = "SELECT [IdCliente], [IdAgenzia], [Nome], [Cognome], [Indirizzo], [CAP], [Citta], "& _ 
                "[TelefonoPrefisso], [TelefonoNumero], [rowguid] FROM [Clienti]"
            Me._commandCollection(0).CommandType = System.Data.CommandType.Text
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute(),  _
         System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Fill, true)>  _
        Public Overloads Overridable Function Fill(ByVal dataTable As SmartEstateDataSet.ClientiDataTable) As Integer
            Me.Adapter.SelectCommand = Me.CommandCollection(0)
            If (Me.ClearBeforeFill = true) Then
                dataTable.Clear
            End If
            Dim returnValue As Integer = Me.Adapter.Fill(dataTable)
            Return returnValue
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute(),  _
         System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.[Select], true)>  _
        Public Overloads Overridable Function GetData() As SmartEstateDataSet.ClientiDataTable
            Me.Adapter.SelectCommand = Me.CommandCollection(0)
            Dim dataTable As SmartEstateDataSet.ClientiDataTable = New SmartEstateDataSet.ClientiDataTable
            Me.Adapter.Fill(dataTable)
            Return dataTable
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Overloads Overridable Function Update(ByVal dataTable As SmartEstateDataSet.ClientiDataTable) As Integer
            Return Me.Adapter.Update(dataTable)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Overloads Overridable Function Update(ByVal dataSet As SmartEstateDataSet) As Integer
            Return Me.Adapter.Update(dataSet, "Clienti")
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Overloads Overridable Function Update(ByVal dataRow As System.Data.DataRow) As Integer
            Return Me.Adapter.Update(New System.Data.DataRow() {dataRow})
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Overloads Overridable Function Update(ByVal dataRows() As System.Data.DataRow) As Integer
            Return Me.Adapter.Update(dataRows)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute(),  _
         System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Delete, true)>  _
        Public Overloads Overridable Function Delete(ByVal p1 As Integer) As Integer
            Me.Adapter.DeleteCommand.Parameters(0).Value = CType(p1,Integer)
            Dim previousConnectionState As System.Data.ConnectionState = Me.Adapter.DeleteCommand.Connection.State
            If ((Me.Adapter.DeleteCommand.Connection.State And System.Data.ConnectionState.Open)  _
                        <> System.Data.ConnectionState.Open) Then
                Me.Adapter.DeleteCommand.Connection.Open
            End If
            Try 
                Dim returnValue As Integer = Me.Adapter.DeleteCommand.ExecuteNonQuery
                Return returnValue
            Finally
                If (previousConnectionState = System.Data.ConnectionState.Closed) Then
                    Me.Adapter.DeleteCommand.Connection.Close
                End If
            End Try
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute(),  _
         System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Insert, true)>  _
        Public Overloads Overridable Function Insert(ByVal p1 As Integer, ByVal p2 As String, ByVal p3 As String, ByVal p4 As String, ByVal p5 As String, ByVal p6 As String, ByVal p7 As String, ByVal p8 As String) As Integer
            Me.Adapter.InsertCommand.Parameters(0).Value = CType(p1,Integer)
            If (p2 Is Nothing) Then
                Me.Adapter.InsertCommand.Parameters(1).Value = System.DBNull.Value
            Else
                Me.Adapter.InsertCommand.Parameters(1).Value = CType(p2,String)
            End If
            If (p3 Is Nothing) Then
                Me.Adapter.InsertCommand.Parameters(2).Value = System.DBNull.Value
            Else
                Me.Adapter.InsertCommand.Parameters(2).Value = CType(p3,String)
            End If
            If (p4 Is Nothing) Then
                Me.Adapter.InsertCommand.Parameters(3).Value = System.DBNull.Value
            Else
                Me.Adapter.InsertCommand.Parameters(3).Value = CType(p4,String)
            End If
            If (p5 Is Nothing) Then
                Me.Adapter.InsertCommand.Parameters(4).Value = System.DBNull.Value
            Else
                Me.Adapter.InsertCommand.Parameters(4).Value = CType(p5,String)
            End If
            If (p6 Is Nothing) Then
                Me.Adapter.InsertCommand.Parameters(5).Value = System.DBNull.Value
            Else
                Me.Adapter.InsertCommand.Parameters(5).Value = CType(p6,String)
            End If
            If (p7 Is Nothing) Then
                Me.Adapter.InsertCommand.Parameters(6).Value = System.DBNull.Value
            Else
                Me.Adapter.InsertCommand.Parameters(6).Value = CType(p7,String)
            End If
            If (p8 Is Nothing) Then
                Me.Adapter.InsertCommand.Parameters(7).Value = System.DBNull.Value
            Else
                Me.Adapter.InsertCommand.Parameters(7).Value = CType(p8,String)
            End If
            Dim previousConnectionState As System.Data.ConnectionState = Me.Adapter.InsertCommand.Connection.State
            If ((Me.Adapter.InsertCommand.Connection.State And System.Data.ConnectionState.Open)  _
                        <> System.Data.ConnectionState.Open) Then
                Me.Adapter.InsertCommand.Connection.Open
            End If
            Try 
                Dim returnValue As Integer = Me.Adapter.InsertCommand.ExecuteNonQuery
                Return returnValue
            Finally
                If (previousConnectionState = System.Data.ConnectionState.Closed) Then
                    Me.Adapter.InsertCommand.Connection.Close
                End If
            End Try
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute(),  _
         System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Update, true)>  _
        Public Overloads Overridable Function Update(ByVal p1 As Integer, ByVal p2 As String, ByVal p3 As String, ByVal p4 As String, ByVal p5 As String, ByVal p6 As String, ByVal p7 As String, ByVal p8 As String, ByVal p9 As Integer) As Integer
            Me.Adapter.UpdateCommand.Parameters(0).Value = CType(p1,Integer)
            If (p2 Is Nothing) Then
                Me.Adapter.UpdateCommand.Parameters(1).Value = System.DBNull.Value
            Else
                Me.Adapter.UpdateCommand.Parameters(1).Value = CType(p2,String)
            End If
            If (p3 Is Nothing) Then
                Me.Adapter.UpdateCommand.Parameters(2).Value = System.DBNull.Value
            Else
                Me.Adapter.UpdateCommand.Parameters(2).Value = CType(p3,String)
            End If
            If (p4 Is Nothing) Then
                Me.Adapter.UpdateCommand.Parameters(3).Value = System.DBNull.Value
            Else
                Me.Adapter.UpdateCommand.Parameters(3).Value = CType(p4,String)
            End If
            If (p5 Is Nothing) Then
                Me.Adapter.UpdateCommand.Parameters(4).Value = System.DBNull.Value
            Else
                Me.Adapter.UpdateCommand.Parameters(4).Value = CType(p5,String)
            End If
            If (p6 Is Nothing) Then
                Me.Adapter.UpdateCommand.Parameters(5).Value = System.DBNull.Value
            Else
                Me.Adapter.UpdateCommand.Parameters(5).Value = CType(p6,String)
            End If
            If (p7 Is Nothing) Then
                Me.Adapter.UpdateCommand.Parameters(6).Value = System.DBNull.Value
            Else
                Me.Adapter.UpdateCommand.Parameters(6).Value = CType(p7,String)
            End If
            If (p8 Is Nothing) Then
                Me.Adapter.UpdateCommand.Parameters(7).Value = System.DBNull.Value
            Else
                Me.Adapter.UpdateCommand.Parameters(7).Value = CType(p8,String)
            End If
            Me.Adapter.UpdateCommand.Parameters(8).Value = CType(p9,Integer)
            Dim previousConnectionState As System.Data.ConnectionState = Me.Adapter.UpdateCommand.Connection.State
            If ((Me.Adapter.UpdateCommand.Connection.State And System.Data.ConnectionState.Open)  _
                        <> System.Data.ConnectionState.Open) Then
                Me.Adapter.UpdateCommand.Connection.Open
            End If
            Try 
                Dim returnValue As Integer = Me.Adapter.UpdateCommand.ExecuteNonQuery
                Return returnValue
            Finally
                If (previousConnectionState = System.Data.ConnectionState.Closed) Then
                    Me.Adapter.UpdateCommand.Connection.Close
                End If
            End Try
        End Function
    End Class
    
    <System.ComponentModel.DesignerCategoryAttribute("code"),  _
     System.ComponentModel.DataObjectAttribute(true)>  _
    Partial Public Class ImmobiliTableAdapter
        Inherits System.ComponentModel.Component
        
        Private WithEvents _adapter As System.Data.SqlServerCe.SqlCeDataAdapter
        
        Private _connection As System.Data.SqlServerCe.SqlCeConnection
        
        Private _commandCollection() As System.Data.SqlServerCe.SqlCeCommand
        
        Private _clearBeforeFill As Boolean
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub New()
            MyBase.New
            Me.ClearBeforeFill = true
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Private ReadOnly Property Adapter() As System.Data.SqlServerCe.SqlCeDataAdapter
            Get
                If (Me._adapter Is Nothing) Then
                    Me.InitAdapter
                End If
                Return Me._adapter
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Friend Property Connection() As System.Data.SqlServerCe.SqlCeConnection
            Get
                If (Me._connection Is Nothing) Then
                    Me.InitConnection
                End If
                Return Me._connection
            End Get
            Set
                Me._connection = value
                If (Not (Me.Adapter.InsertCommand) Is Nothing) Then
                    Me.Adapter.InsertCommand.Connection = value
                End If
                If (Not (Me.Adapter.DeleteCommand) Is Nothing) Then
                    Me.Adapter.DeleteCommand.Connection = value
                End If
                If (Not (Me.Adapter.UpdateCommand) Is Nothing) Then
                    Me.Adapter.UpdateCommand.Connection = value
                End If
                Dim i As Integer = 0
                Do While (i < Me.CommandCollection.Length)
                    If (Not (Me.CommandCollection(i)) Is Nothing) Then
                        CType(Me.CommandCollection(i),System.Data.SqlServerCe.SqlCeCommand).Connection = value
                    End If
                    i = (i + 1)
                Loop
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Protected ReadOnly Property CommandCollection() As System.Data.SqlServerCe.SqlCeCommand()
            Get
                If (Me._commandCollection Is Nothing) Then
                    Me.InitCommandCollection
                End If
                Return Me._commandCollection
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property ClearBeforeFill() As Boolean
            Get
                Return Me._clearBeforeFill
            End Get
            Set
                Me._clearBeforeFill = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Private Sub InitAdapter()
            Me._adapter = New System.Data.SqlServerCe.SqlCeDataAdapter
            Dim tableMapping As System.Data.Common.DataTableMapping = New System.Data.Common.DataTableMapping
            tableMapping.SourceTable = "Table"
            tableMapping.DataSetTable = "Immobili"
            tableMapping.ColumnMappings.Add("IdImmobile", "IdImmobile")
            tableMapping.ColumnMappings.Add("IdAgenzia", "IdAgenzia")
            tableMapping.ColumnMappings.Add("CodiceImmobile", "CodiceImmobile")
            tableMapping.ColumnMappings.Add("CodiceTipoImmobile", "CodiceTipoImmobile")
            tableMapping.ColumnMappings.Add("RiferimentoInterno", "RiferimentoInterno")
            tableMapping.ColumnMappings.Add("DescrizioneLunga", "DescrizioneLunga")
            tableMapping.ColumnMappings.Add("DescrizioneBreve", "DescrizioneBreve")
            tableMapping.ColumnMappings.Add("Dimensione", "Dimensione")
            tableMapping.ColumnMappings.Add("Indirizzo", "Indirizzo")
            tableMapping.ColumnMappings.Add("CAP", "CAP")
            tableMapping.ColumnMappings.Add("Zona", "Zona")
            tableMapping.ColumnMappings.Add("Citta", "Citta")
            tableMapping.ColumnMappings.Add("Foto", "Foto")
            tableMapping.ColumnMappings.Add("Planimetria", "Planimetria")
            tableMapping.ColumnMappings.Add("PrezzoMin", "PrezzoMin")
            tableMapping.ColumnMappings.Add("PrezzoMax", "PrezzoMax")
            tableMapping.ColumnMappings.Add("SpeseCondominiali", "SpeseCondominiali")
            tableMapping.ColumnMappings.Add("Valutazione", "Valutazione")
            tableMapping.ColumnMappings.Add("rowguid", "rowguid")
            Me._adapter.TableMappings.Add(tableMapping)
            Me._adapter.DeleteCommand = New System.Data.SqlServerCe.SqlCeCommand
            Me._adapter.DeleteCommand.Connection = Me.Connection
            Me._adapter.DeleteCommand.CommandText = "DELETE FROM [Immobili] WHERE (([IdImmobile] = @p1))"
            Me._adapter.DeleteCommand.CommandType = System.Data.CommandType.Text
            Dim param As System.Data.SqlServerCe.SqlCeParameter = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p1"
            param.DbType = System.Data.DbType.Int32
            param.IsNullable = true
            param.SourceColumn = "IdImmobile"
            param.SourceVersion = System.Data.DataRowVersion.Original
            Me._adapter.DeleteCommand.Parameters.Add(param)
            Me._adapter.InsertCommand = New System.Data.SqlServerCe.SqlCeCommand
            Me._adapter.InsertCommand.Connection = Me.Connection
            Me._adapter.InsertCommand.CommandText = "INSERT INTO [Immobili] ([IdAgenzia], [CodiceImmobile], [CodiceTipoImmobile], [Rif"& _ 
                "erimentoInterno], [DescrizioneLunga], [DescrizioneBreve], [Dimensione], [Indiriz"& _ 
                "zo], [CAP], [Zona], [Citta], [Foto], [Planimetria], [PrezzoMin], [PrezzoMax], [S"& _ 
                "peseCondominiali], [Valutazione]) VALUES (@p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8"& _ 
                ", @p9, @p10, @p11, @p12, @p13, @p14, @p15, @p16, @p17)"
            Me._adapter.InsertCommand.CommandType = System.Data.CommandType.Text
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p1"
            param.DbType = System.Data.DbType.Int32
            param.IsNullable = true
            param.SourceColumn = "IdAgenzia"
            Me._adapter.InsertCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p2"
            param.IsNullable = true
            param.SourceColumn = "CodiceImmobile"
            Me._adapter.InsertCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p3"
            param.IsNullable = true
            param.SourceColumn = "CodiceTipoImmobile"
            Me._adapter.InsertCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p4"
            param.IsNullable = true
            param.SourceColumn = "RiferimentoInterno"
            Me._adapter.InsertCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p5"
            param.IsNullable = true
            param.SourceColumn = "DescrizioneLunga"
            Me._adapter.InsertCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p6"
            param.IsNullable = true
            param.SourceColumn = "DescrizioneBreve"
            Me._adapter.InsertCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p7"
            param.DbType = System.Data.DbType.Int32
            param.IsNullable = true
            param.SourceColumn = "Dimensione"
            Me._adapter.InsertCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p8"
            param.IsNullable = true
            param.SourceColumn = "Indirizzo"
            Me._adapter.InsertCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p9"
            param.DbType = System.Data.DbType.StringFixedLength
            param.IsNullable = true
            param.SourceColumn = "CAP"
            Me._adapter.InsertCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p10"
            param.IsNullable = true
            param.SourceColumn = "Zona"
            Me._adapter.InsertCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p11"
            param.IsNullable = true
            param.SourceColumn = "Citta"
            Me._adapter.InsertCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p12"
            param.DbType = System.Data.DbType.Binary
            param.IsNullable = true
            param.SourceColumn = "Foto"
            Me._adapter.InsertCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p13"
            param.DbType = System.Data.DbType.Binary
            param.IsNullable = true
            param.SourceColumn = "Planimetria"
            Me._adapter.InsertCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p14"
            param.DbType = System.Data.DbType.Int32
            param.IsNullable = true
            param.SourceColumn = "PrezzoMin"
            Me._adapter.InsertCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p15"
            param.DbType = System.Data.DbType.Int32
            param.IsNullable = true
            param.SourceColumn = "PrezzoMax"
            Me._adapter.InsertCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p16"
            param.DbType = System.Data.DbType.Int32
            param.IsNullable = true
            param.SourceColumn = "SpeseCondominiali"
            Me._adapter.InsertCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p17"
            param.DbType = System.Data.DbType.Int32
            param.IsNullable = true
            param.SourceColumn = "Valutazione"
            Me._adapter.InsertCommand.Parameters.Add(param)
            Me._adapter.UpdateCommand = New System.Data.SqlServerCe.SqlCeCommand
            Me._adapter.UpdateCommand.Connection = Me.Connection
            Me._adapter.UpdateCommand.CommandText = "UPDATE [Immobili] SET [IdAgenzia] = @p1, [CodiceImmobile] = @p2, [CodiceTipoImmob"& _ 
                "ile] = @p3, [RiferimentoInterno] = @p4, [DescrizioneLunga] = @p5, [DescrizioneBr"& _ 
                "eve] = @p6, [Dimensione] = @p7, [Indirizzo] = @p8, [CAP] = @p9, [Zona] = @p10, ["& _ 
                "Citta] = @p11, [Foto] = @p12, [Planimetria] = @p13, [PrezzoMin] = @p14, [PrezzoM"& _ 
                "ax] = @p15, [SpeseCondominiali] = @p16, [Valutazione] = @p17 WHERE (([IdImmobile"& _ 
                "] = @p18))"
            Me._adapter.UpdateCommand.CommandType = System.Data.CommandType.Text
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p1"
            param.DbType = System.Data.DbType.Int32
            param.IsNullable = true
            param.SourceColumn = "IdAgenzia"
            Me._adapter.UpdateCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p2"
            param.IsNullable = true
            param.SourceColumn = "CodiceImmobile"
            Me._adapter.UpdateCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p3"
            param.IsNullable = true
            param.SourceColumn = "CodiceTipoImmobile"
            Me._adapter.UpdateCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p4"
            param.IsNullable = true
            param.SourceColumn = "RiferimentoInterno"
            Me._adapter.UpdateCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p5"
            param.IsNullable = true
            param.SourceColumn = "DescrizioneLunga"
            Me._adapter.UpdateCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p6"
            param.IsNullable = true
            param.SourceColumn = "DescrizioneBreve"
            Me._adapter.UpdateCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p7"
            param.DbType = System.Data.DbType.Int32
            param.IsNullable = true
            param.SourceColumn = "Dimensione"
            Me._adapter.UpdateCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p8"
            param.IsNullable = true
            param.SourceColumn = "Indirizzo"
            Me._adapter.UpdateCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p9"
            param.DbType = System.Data.DbType.StringFixedLength
            param.IsNullable = true
            param.SourceColumn = "CAP"
            Me._adapter.UpdateCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p10"
            param.IsNullable = true
            param.SourceColumn = "Zona"
            Me._adapter.UpdateCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p11"
            param.IsNullable = true
            param.SourceColumn = "Citta"
            Me._adapter.UpdateCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p12"
            param.DbType = System.Data.DbType.Binary
            param.IsNullable = true
            param.SourceColumn = "Foto"
            Me._adapter.UpdateCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p13"
            param.DbType = System.Data.DbType.Binary
            param.IsNullable = true
            param.SourceColumn = "Planimetria"
            Me._adapter.UpdateCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p14"
            param.DbType = System.Data.DbType.Int32
            param.IsNullable = true
            param.SourceColumn = "PrezzoMin"
            Me._adapter.UpdateCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p15"
            param.DbType = System.Data.DbType.Int32
            param.IsNullable = true
            param.SourceColumn = "PrezzoMax"
            Me._adapter.UpdateCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p16"
            param.DbType = System.Data.DbType.Int32
            param.IsNullable = true
            param.SourceColumn = "SpeseCondominiali"
            Me._adapter.UpdateCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p17"
            param.DbType = System.Data.DbType.Int32
            param.IsNullable = true
            param.SourceColumn = "Valutazione"
            Me._adapter.UpdateCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p18"
            param.DbType = System.Data.DbType.Int32
            param.IsNullable = true
            param.SourceColumn = "IdImmobile"
            param.SourceVersion = System.Data.DataRowVersion.Original
            Me._adapter.UpdateCommand.Parameters.Add(param)
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Private Sub InitConnection()
            Me._connection = New System.Data.SqlServerCe.SqlCeConnection
            Me._connection.ConnectionString = ("Data Source ="  _
                        + (System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly.GetName.CodeBase) + "\SmartEstate.sdf;"))
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Private Sub InitCommandCollection()
            Me._commandCollection = New System.Data.SqlServerCe.SqlCeCommand(0) {}
            Me._commandCollection(0) = New System.Data.SqlServerCe.SqlCeCommand
            Me._commandCollection(0).Connection = Me.Connection
            Me._commandCollection(0).CommandText = "SELECT [IdImmobile], [IdAgenzia], [CodiceImmobile], [CodiceTipoImmobile], [Riferi"& _ 
                "mentoInterno], [DescrizioneLunga], [DescrizioneBreve], [Dimensione], [Indirizzo]"& _ 
                ", [CAP], [Zona], [Citta], [Foto], [Planimetria], [PrezzoMin], [PrezzoMax], [Spes"& _ 
                "eCondominiali], [Valutazione], [rowguid] FROM [Immobili]"
            Me._commandCollection(0).CommandType = System.Data.CommandType.Text
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute(),  _
         System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Fill, true)>  _
        Public Overloads Overridable Function Fill(ByVal dataTable As SmartEstateDataSet.ImmobiliDataTable) As Integer
            Me.Adapter.SelectCommand = Me.CommandCollection(0)
            If (Me.ClearBeforeFill = true) Then
                dataTable.Clear
            End If
            Dim returnValue As Integer = Me.Adapter.Fill(dataTable)
            Return returnValue
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute(),  _
         System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.[Select], true)>  _
        Public Overloads Overridable Function GetData() As SmartEstateDataSet.ImmobiliDataTable
            Me.Adapter.SelectCommand = Me.CommandCollection(0)
            Dim dataTable As SmartEstateDataSet.ImmobiliDataTable = New SmartEstateDataSet.ImmobiliDataTable
            Me.Adapter.Fill(dataTable)
            Return dataTable
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Overloads Overridable Function Update(ByVal dataTable As SmartEstateDataSet.ImmobiliDataTable) As Integer
            Return Me.Adapter.Update(dataTable)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Overloads Overridable Function Update(ByVal dataSet As SmartEstateDataSet) As Integer
            Return Me.Adapter.Update(dataSet, "Immobili")
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Overloads Overridable Function Update(ByVal dataRow As System.Data.DataRow) As Integer
            Return Me.Adapter.Update(New System.Data.DataRow() {dataRow})
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Overloads Overridable Function Update(ByVal dataRows() As System.Data.DataRow) As Integer
            Return Me.Adapter.Update(dataRows)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute(),  _
         System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Delete, true)>  _
        Public Overloads Overridable Function Delete(ByVal p1 As Integer) As Integer
            Me.Adapter.DeleteCommand.Parameters(0).Value = CType(p1,Integer)
            Dim previousConnectionState As System.Data.ConnectionState = Me.Adapter.DeleteCommand.Connection.State
            If ((Me.Adapter.DeleteCommand.Connection.State And System.Data.ConnectionState.Open)  _
                        <> System.Data.ConnectionState.Open) Then
                Me.Adapter.DeleteCommand.Connection.Open
            End If
            Try 
                Dim returnValue As Integer = Me.Adapter.DeleteCommand.ExecuteNonQuery
                Return returnValue
            Finally
                If (previousConnectionState = System.Data.ConnectionState.Closed) Then
                    Me.Adapter.DeleteCommand.Connection.Close
                End If
            End Try
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute(),  _
         System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Insert, true)>  _
        Public Overloads Overridable Function Insert( _
                    ByVal p1 As Integer,  _
                    ByVal p2 As String,  _
                    ByVal p3 As String,  _
                    ByVal p4 As String,  _
                    ByVal p5 As String,  _
                    ByVal p6 As String,  _
                    ByVal p7 As System.Nullable(Of Integer),  _
                    ByVal p8 As String,  _
                    ByVal p9 As String,  _
                    ByVal p10 As String,  _
                    ByVal p11 As String,  _
                    ByVal p12() As Byte,  _
                    ByVal p13() As Byte,  _
                    ByVal p14 As System.Nullable(Of Integer),  _
                    ByVal p15 As System.Nullable(Of Integer),  _
                    ByVal p16 As System.Nullable(Of Integer),  _
                    ByVal p17 As System.Nullable(Of Integer)) As Integer
            Me.Adapter.InsertCommand.Parameters(0).Value = CType(p1,Integer)
            If (p2 Is Nothing) Then
                Me.Adapter.InsertCommand.Parameters(1).Value = System.DBNull.Value
            Else
                Me.Adapter.InsertCommand.Parameters(1).Value = CType(p2,String)
            End If
            If (p3 Is Nothing) Then
                Me.Adapter.InsertCommand.Parameters(2).Value = System.DBNull.Value
            Else
                Me.Adapter.InsertCommand.Parameters(2).Value = CType(p3,String)
            End If
            If (p4 Is Nothing) Then
                Me.Adapter.InsertCommand.Parameters(3).Value = System.DBNull.Value
            Else
                Me.Adapter.InsertCommand.Parameters(3).Value = CType(p4,String)
            End If
            If (p5 Is Nothing) Then
                Me.Adapter.InsertCommand.Parameters(4).Value = System.DBNull.Value
            Else
                Me.Adapter.InsertCommand.Parameters(4).Value = CType(p5,String)
            End If
            If (p6 Is Nothing) Then
                Me.Adapter.InsertCommand.Parameters(5).Value = System.DBNull.Value
            Else
                Me.Adapter.InsertCommand.Parameters(5).Value = CType(p6,String)
            End If
            If (p7.HasValue = true) Then
                Me.Adapter.InsertCommand.Parameters(6).Value = CType(p7.Value,Integer)
            Else
                Me.Adapter.InsertCommand.Parameters(6).Value = System.DBNull.Value
            End If
            If (p8 Is Nothing) Then
                Me.Adapter.InsertCommand.Parameters(7).Value = System.DBNull.Value
            Else
                Me.Adapter.InsertCommand.Parameters(7).Value = CType(p8,String)
            End If
            If (p9 Is Nothing) Then
                Me.Adapter.InsertCommand.Parameters(8).Value = System.DBNull.Value
            Else
                Me.Adapter.InsertCommand.Parameters(8).Value = CType(p9,String)
            End If
            If (p10 Is Nothing) Then
                Me.Adapter.InsertCommand.Parameters(9).Value = System.DBNull.Value
            Else
                Me.Adapter.InsertCommand.Parameters(9).Value = CType(p10,String)
            End If
            If (p11 Is Nothing) Then
                Me.Adapter.InsertCommand.Parameters(10).Value = System.DBNull.Value
            Else
                Me.Adapter.InsertCommand.Parameters(10).Value = CType(p11,String)
            End If
            If (p12 Is Nothing) Then
                Me.Adapter.InsertCommand.Parameters(11).Value = System.DBNull.Value
            Else
                Me.Adapter.InsertCommand.Parameters(11).Value = CType(p12,Byte())
            End If
            If (p13 Is Nothing) Then
                Me.Adapter.InsertCommand.Parameters(12).Value = System.DBNull.Value
            Else
                Me.Adapter.InsertCommand.Parameters(12).Value = CType(p13,Byte())
            End If
            If (p14.HasValue = true) Then
                Me.Adapter.InsertCommand.Parameters(13).Value = CType(p14.Value,Integer)
            Else
                Me.Adapter.InsertCommand.Parameters(13).Value = System.DBNull.Value
            End If
            If (p15.HasValue = true) Then
                Me.Adapter.InsertCommand.Parameters(14).Value = CType(p15.Value,Integer)
            Else
                Me.Adapter.InsertCommand.Parameters(14).Value = System.DBNull.Value
            End If
            If (p16.HasValue = true) Then
                Me.Adapter.InsertCommand.Parameters(15).Value = CType(p16.Value,Integer)
            Else
                Me.Adapter.InsertCommand.Parameters(15).Value = System.DBNull.Value
            End If
            If (p17.HasValue = true) Then
                Me.Adapter.InsertCommand.Parameters(16).Value = CType(p17.Value,Integer)
            Else
                Me.Adapter.InsertCommand.Parameters(16).Value = System.DBNull.Value
            End If
            Dim previousConnectionState As System.Data.ConnectionState = Me.Adapter.InsertCommand.Connection.State
            If ((Me.Adapter.InsertCommand.Connection.State And System.Data.ConnectionState.Open)  _
                        <> System.Data.ConnectionState.Open) Then
                Me.Adapter.InsertCommand.Connection.Open
            End If
            Try 
                Dim returnValue As Integer = Me.Adapter.InsertCommand.ExecuteNonQuery
                Return returnValue
            Finally
                If (previousConnectionState = System.Data.ConnectionState.Closed) Then
                    Me.Adapter.InsertCommand.Connection.Close
                End If
            End Try
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute(),  _
         System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Update, true)>  _
        Public Overloads Overridable Function Update( _
                    ByVal p1 As Integer,  _
                    ByVal p2 As String,  _
                    ByVal p3 As String,  _
                    ByVal p4 As String,  _
                    ByVal p5 As String,  _
                    ByVal p6 As String,  _
                    ByVal p7 As System.Nullable(Of Integer),  _
                    ByVal p8 As String,  _
                    ByVal p9 As String,  _
                    ByVal p10 As String,  _
                    ByVal p11 As String,  _
                    ByVal p12() As Byte,  _
                    ByVal p13() As Byte,  _
                    ByVal p14 As System.Nullable(Of Integer),  _
                    ByVal p15 As System.Nullable(Of Integer),  _
                    ByVal p16 As System.Nullable(Of Integer),  _
                    ByVal p17 As System.Nullable(Of Integer),  _
                    ByVal p18 As Integer) As Integer
            Me.Adapter.UpdateCommand.Parameters(0).Value = CType(p1,Integer)
            If (p2 Is Nothing) Then
                Me.Adapter.UpdateCommand.Parameters(1).Value = System.DBNull.Value
            Else
                Me.Adapter.UpdateCommand.Parameters(1).Value = CType(p2,String)
            End If
            If (p3 Is Nothing) Then
                Me.Adapter.UpdateCommand.Parameters(2).Value = System.DBNull.Value
            Else
                Me.Adapter.UpdateCommand.Parameters(2).Value = CType(p3,String)
            End If
            If (p4 Is Nothing) Then
                Me.Adapter.UpdateCommand.Parameters(3).Value = System.DBNull.Value
            Else
                Me.Adapter.UpdateCommand.Parameters(3).Value = CType(p4,String)
            End If
            If (p5 Is Nothing) Then
                Me.Adapter.UpdateCommand.Parameters(4).Value = System.DBNull.Value
            Else
                Me.Adapter.UpdateCommand.Parameters(4).Value = CType(p5,String)
            End If
            If (p6 Is Nothing) Then
                Me.Adapter.UpdateCommand.Parameters(5).Value = System.DBNull.Value
            Else
                Me.Adapter.UpdateCommand.Parameters(5).Value = CType(p6,String)
            End If
            If (p7.HasValue = true) Then
                Me.Adapter.UpdateCommand.Parameters(6).Value = CType(p7.Value,Integer)
            Else
                Me.Adapter.UpdateCommand.Parameters(6).Value = System.DBNull.Value
            End If
            If (p8 Is Nothing) Then
                Me.Adapter.UpdateCommand.Parameters(7).Value = System.DBNull.Value
            Else
                Me.Adapter.UpdateCommand.Parameters(7).Value = CType(p8,String)
            End If
            If (p9 Is Nothing) Then
                Me.Adapter.UpdateCommand.Parameters(8).Value = System.DBNull.Value
            Else
                Me.Adapter.UpdateCommand.Parameters(8).Value = CType(p9,String)
            End If
            If (p10 Is Nothing) Then
                Me.Adapter.UpdateCommand.Parameters(9).Value = System.DBNull.Value
            Else
                Me.Adapter.UpdateCommand.Parameters(9).Value = CType(p10,String)
            End If
            If (p11 Is Nothing) Then
                Me.Adapter.UpdateCommand.Parameters(10).Value = System.DBNull.Value
            Else
                Me.Adapter.UpdateCommand.Parameters(10).Value = CType(p11,String)
            End If
            If (p12 Is Nothing) Then
                Me.Adapter.UpdateCommand.Parameters(11).Value = System.DBNull.Value
            Else
                Me.Adapter.UpdateCommand.Parameters(11).Value = CType(p12,Byte())
            End If
            If (p13 Is Nothing) Then
                Me.Adapter.UpdateCommand.Parameters(12).Value = System.DBNull.Value
            Else
                Me.Adapter.UpdateCommand.Parameters(12).Value = CType(p13,Byte())
            End If
            If (p14.HasValue = true) Then
                Me.Adapter.UpdateCommand.Parameters(13).Value = CType(p14.Value,Integer)
            Else
                Me.Adapter.UpdateCommand.Parameters(13).Value = System.DBNull.Value
            End If
            If (p15.HasValue = true) Then
                Me.Adapter.UpdateCommand.Parameters(14).Value = CType(p15.Value,Integer)
            Else
                Me.Adapter.UpdateCommand.Parameters(14).Value = System.DBNull.Value
            End If
            If (p16.HasValue = true) Then
                Me.Adapter.UpdateCommand.Parameters(15).Value = CType(p16.Value,Integer)
            Else
                Me.Adapter.UpdateCommand.Parameters(15).Value = System.DBNull.Value
            End If
            If (p17.HasValue = true) Then
                Me.Adapter.UpdateCommand.Parameters(16).Value = CType(p17.Value,Integer)
            Else
                Me.Adapter.UpdateCommand.Parameters(16).Value = System.DBNull.Value
            End If
            Me.Adapter.UpdateCommand.Parameters(17).Value = CType(p18,Integer)
            Dim previousConnectionState As System.Data.ConnectionState = Me.Adapter.UpdateCommand.Connection.State
            If ((Me.Adapter.UpdateCommand.Connection.State And System.Data.ConnectionState.Open)  _
                        <> System.Data.ConnectionState.Open) Then
                Me.Adapter.UpdateCommand.Connection.Open
            End If
            Try 
                Dim returnValue As Integer = Me.Adapter.UpdateCommand.ExecuteNonQuery
                Return returnValue
            Finally
                If (previousConnectionState = System.Data.ConnectionState.Closed) Then
                    Me.Adapter.UpdateCommand.Connection.Close
                End If
            End Try
        End Function
    End Class
    
    <System.ComponentModel.DesignerCategoryAttribute("code"),  _
     System.ComponentModel.DataObjectAttribute(true)>  _
    Partial Public Class PreventiviTableAdapter
        Inherits System.ComponentModel.Component
        
        Private WithEvents _adapter As System.Data.SqlServerCe.SqlCeDataAdapter
        
        Private _connection As System.Data.SqlServerCe.SqlCeConnection
        
        Private _commandCollection() As System.Data.SqlServerCe.SqlCeCommand
        
        Private _clearBeforeFill As Boolean
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Sub New()
            MyBase.New
            Me.ClearBeforeFill = true
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Private ReadOnly Property Adapter() As System.Data.SqlServerCe.SqlCeDataAdapter
            Get
                If (Me._adapter Is Nothing) Then
                    Me.InitAdapter
                End If
                Return Me._adapter
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Friend Property Connection() As System.Data.SqlServerCe.SqlCeConnection
            Get
                If (Me._connection Is Nothing) Then
                    Me.InitConnection
                End If
                Return Me._connection
            End Get
            Set
                Me._connection = value
                If (Not (Me.Adapter.InsertCommand) Is Nothing) Then
                    Me.Adapter.InsertCommand.Connection = value
                End If
                If (Not (Me.Adapter.DeleteCommand) Is Nothing) Then
                    Me.Adapter.DeleteCommand.Connection = value
                End If
                If (Not (Me.Adapter.UpdateCommand) Is Nothing) Then
                    Me.Adapter.UpdateCommand.Connection = value
                End If
                Dim i As Integer = 0
                Do While (i < Me.CommandCollection.Length)
                    If (Not (Me.CommandCollection(i)) Is Nothing) Then
                        CType(Me.CommandCollection(i),System.Data.SqlServerCe.SqlCeCommand).Connection = value
                    End If
                    i = (i + 1)
                Loop
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Protected ReadOnly Property CommandCollection() As System.Data.SqlServerCe.SqlCeCommand()
            Get
                If (Me._commandCollection Is Nothing) Then
                    Me.InitCommandCollection
                End If
                Return Me._commandCollection
            End Get
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Property ClearBeforeFill() As Boolean
            Get
                Return Me._clearBeforeFill
            End Get
            Set
                Me._clearBeforeFill = value
            End Set
        End Property
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Private Sub InitAdapter()
            Me._adapter = New System.Data.SqlServerCe.SqlCeDataAdapter
            Dim tableMapping As System.Data.Common.DataTableMapping = New System.Data.Common.DataTableMapping
            tableMapping.SourceTable = "Table"
            tableMapping.DataSetTable = "Preventivi"
            tableMapping.ColumnMappings.Add("IdPreventivo", "IdPreventivo")
            tableMapping.ColumnMappings.Add("IdCliente", "IdCliente")
            tableMapping.ColumnMappings.Add("IdImmobile", "IdImmobile")
            tableMapping.ColumnMappings.Add("IdAgente", "IdAgente")
            tableMapping.ColumnMappings.Add("Appuntamento", "Appuntamento")
            tableMapping.ColumnMappings.Add("CodiceTipoOffertaImmobile", "CodiceTipoOffertaImmobile")
            tableMapping.ColumnMappings.Add("rowguid", "rowguid")
            Me._adapter.TableMappings.Add(tableMapping)
            Me._adapter.DeleteCommand = New System.Data.SqlServerCe.SqlCeCommand
            Me._adapter.DeleteCommand.Connection = Me.Connection
            Me._adapter.DeleteCommand.CommandText = "DELETE FROM [Preventivi] WHERE (([IdPreventivo] = @p1))"
            Me._adapter.DeleteCommand.CommandType = System.Data.CommandType.Text
            Dim param As System.Data.SqlServerCe.SqlCeParameter = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p1"
            param.DbType = System.Data.DbType.Int32
            param.IsNullable = true
            param.SourceColumn = "IdPreventivo"
            param.SourceVersion = System.Data.DataRowVersion.Original
            Me._adapter.DeleteCommand.Parameters.Add(param)
            Me._adapter.InsertCommand = New System.Data.SqlServerCe.SqlCeCommand
            Me._adapter.InsertCommand.Connection = Me.Connection
            Me._adapter.InsertCommand.CommandText = "INSERT INTO [Preventivi] ([IdCliente], [IdImmobile], [IdAgente], [Appuntamento], "& _ 
                "[CodiceTipoOffertaImmobile]) VALUES (@p1, @p2, @p3, @p4, @p5)"
            Me._adapter.InsertCommand.CommandType = System.Data.CommandType.Text
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p1"
            param.DbType = System.Data.DbType.Int32
            param.IsNullable = true
            param.SourceColumn = "IdCliente"
            Me._adapter.InsertCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p2"
            param.DbType = System.Data.DbType.Int32
            param.IsNullable = true
            param.SourceColumn = "IdImmobile"
            Me._adapter.InsertCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p3"
            param.DbType = System.Data.DbType.Int32
            param.IsNullable = true
            param.SourceColumn = "IdAgente"
            Me._adapter.InsertCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p4"
            param.DbType = System.Data.DbType.DateTime
            param.IsNullable = true
            param.SourceColumn = "Appuntamento"
            Me._adapter.InsertCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p5"
            param.IsNullable = true
            param.SourceColumn = "CodiceTipoOffertaImmobile"
            Me._adapter.InsertCommand.Parameters.Add(param)
            Me._adapter.UpdateCommand = New System.Data.SqlServerCe.SqlCeCommand
            Me._adapter.UpdateCommand.Connection = Me.Connection
            Me._adapter.UpdateCommand.CommandText = "UPDATE [Preventivi] SET [IdCliente] = @p1, [IdImmobile] = @p2, [IdAgente] = @p3, "& _ 
                "[Appuntamento] = @p4, [CodiceTipoOffertaImmobile] = @p5 WHERE (([IdPreventivo] ="& _ 
                " @p6))"
            Me._adapter.UpdateCommand.CommandType = System.Data.CommandType.Text
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p1"
            param.DbType = System.Data.DbType.Int32
            param.IsNullable = true
            param.SourceColumn = "IdCliente"
            Me._adapter.UpdateCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p2"
            param.DbType = System.Data.DbType.Int32
            param.IsNullable = true
            param.SourceColumn = "IdImmobile"
            Me._adapter.UpdateCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p3"
            param.DbType = System.Data.DbType.Int32
            param.IsNullable = true
            param.SourceColumn = "IdAgente"
            Me._adapter.UpdateCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p4"
            param.DbType = System.Data.DbType.DateTime
            param.IsNullable = true
            param.SourceColumn = "Appuntamento"
            Me._adapter.UpdateCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p5"
            param.IsNullable = true
            param.SourceColumn = "CodiceTipoOffertaImmobile"
            Me._adapter.UpdateCommand.Parameters.Add(param)
            param = New System.Data.SqlServerCe.SqlCeParameter
            param.ParameterName = "@p6"
            param.DbType = System.Data.DbType.Int32
            param.IsNullable = true
            param.SourceColumn = "IdPreventivo"
            param.SourceVersion = System.Data.DataRowVersion.Original
            Me._adapter.UpdateCommand.Parameters.Add(param)
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Private Sub InitConnection()
            Me._connection = New System.Data.SqlServerCe.SqlCeConnection
            Me._connection.ConnectionString = ("Data Source ="  _
                        + (System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly.GetName.CodeBase) + "\SmartEstate.sdf;"))
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Private Sub InitCommandCollection()
            Me._commandCollection = New System.Data.SqlServerCe.SqlCeCommand(0) {}
            Me._commandCollection(0) = New System.Data.SqlServerCe.SqlCeCommand
            Me._commandCollection(0).Connection = Me.Connection
            Me._commandCollection(0).CommandText = "SELECT [IdPreventivo], [IdCliente], [IdImmobile], [IdAgente], [Appuntamento], [Co"& _ 
                "diceTipoOffertaImmobile], [rowguid] FROM [Preventivi]"
            Me._commandCollection(0).CommandType = System.Data.CommandType.Text
        End Sub
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute(),  _
         System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Fill, true)>  _
        Public Overloads Overridable Function Fill(ByVal dataTable As SmartEstateDataSet.PreventiviDataTable) As Integer
            Me.Adapter.SelectCommand = Me.CommandCollection(0)
            If (Me.ClearBeforeFill = true) Then
                dataTable.Clear
            End If
            Dim returnValue As Integer = Me.Adapter.Fill(dataTable)
            Return returnValue
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute(),  _
         System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.[Select], true)>  _
        Public Overloads Overridable Function GetData() As SmartEstateDataSet.PreventiviDataTable
            Me.Adapter.SelectCommand = Me.CommandCollection(0)
            Dim dataTable As SmartEstateDataSet.PreventiviDataTable = New SmartEstateDataSet.PreventiviDataTable
            Me.Adapter.Fill(dataTable)
            Return dataTable
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Overloads Overridable Function Update(ByVal dataTable As SmartEstateDataSet.PreventiviDataTable) As Integer
            Return Me.Adapter.Update(dataTable)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Overloads Overridable Function Update(ByVal dataSet As SmartEstateDataSet) As Integer
            Return Me.Adapter.Update(dataSet, "Preventivi")
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Overloads Overridable Function Update(ByVal dataRow As System.Data.DataRow) As Integer
            Return Me.Adapter.Update(New System.Data.DataRow() {dataRow})
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute()>  _
        Public Overloads Overridable Function Update(ByVal dataRows() As System.Data.DataRow) As Integer
            Return Me.Adapter.Update(dataRows)
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute(),  _
         System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Delete, true)>  _
        Public Overloads Overridable Function Delete(ByVal p1 As Integer) As Integer
            Me.Adapter.DeleteCommand.Parameters(0).Value = CType(p1,Integer)
            Dim previousConnectionState As System.Data.ConnectionState = Me.Adapter.DeleteCommand.Connection.State
            If ((Me.Adapter.DeleteCommand.Connection.State And System.Data.ConnectionState.Open)  _
                        <> System.Data.ConnectionState.Open) Then
                Me.Adapter.DeleteCommand.Connection.Open
            End If
            Try 
                Dim returnValue As Integer = Me.Adapter.DeleteCommand.ExecuteNonQuery
                Return returnValue
            Finally
                If (previousConnectionState = System.Data.ConnectionState.Closed) Then
                    Me.Adapter.DeleteCommand.Connection.Close
                End If
            End Try
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute(),  _
         System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Insert, true)>  _
        Public Overloads Overridable Function Insert(ByVal p1 As Integer, ByVal p2 As Integer, ByVal p3 As Integer, ByVal p4 As System.Nullable(Of Date), ByVal p5 As String) As Integer
            Me.Adapter.InsertCommand.Parameters(0).Value = CType(p1,Integer)
            Me.Adapter.InsertCommand.Parameters(1).Value = CType(p2,Integer)
            Me.Adapter.InsertCommand.Parameters(2).Value = CType(p3,Integer)
            If (p4.HasValue = true) Then
                Me.Adapter.InsertCommand.Parameters(3).Value = CType(p4.Value,Date)
            Else
                Me.Adapter.InsertCommand.Parameters(3).Value = System.DBNull.Value
            End If
            If (p5 Is Nothing) Then
                Me.Adapter.InsertCommand.Parameters(4).Value = System.DBNull.Value
            Else
                Me.Adapter.InsertCommand.Parameters(4).Value = CType(p5,String)
            End If
            Dim previousConnectionState As System.Data.ConnectionState = Me.Adapter.InsertCommand.Connection.State
            If ((Me.Adapter.InsertCommand.Connection.State And System.Data.ConnectionState.Open)  _
                        <> System.Data.ConnectionState.Open) Then
                Me.Adapter.InsertCommand.Connection.Open
            End If
            Try 
                Dim returnValue As Integer = Me.Adapter.InsertCommand.ExecuteNonQuery
                Return returnValue
            Finally
                If (previousConnectionState = System.Data.ConnectionState.Closed) Then
                    Me.Adapter.InsertCommand.Connection.Close
                End If
            End Try
        End Function
        
        <System.Diagnostics.DebuggerNonUserCodeAttribute(),  _
         System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Update, true)>  _
        Public Overloads Overridable Function Update(ByVal p1 As Integer, ByVal p2 As Integer, ByVal p3 As Integer, ByVal p4 As System.Nullable(Of Date), ByVal p5 As String, ByVal p6 As Integer) As Integer
            Me.Adapter.UpdateCommand.Parameters(0).Value = CType(p1,Integer)
            Me.Adapter.UpdateCommand.Parameters(1).Value = CType(p2,Integer)
            Me.Adapter.UpdateCommand.Parameters(2).Value = CType(p3,Integer)
            If (p4.HasValue = true) Then
                Me.Adapter.UpdateCommand.Parameters(3).Value = CType(p4.Value,Date)
            Else
                Me.Adapter.UpdateCommand.Parameters(3).Value = System.DBNull.Value
            End If
            If (p5 Is Nothing) Then
                Me.Adapter.UpdateCommand.Parameters(4).Value = System.DBNull.Value
            Else
                Me.Adapter.UpdateCommand.Parameters(4).Value = CType(p5,String)
            End If
            Me.Adapter.UpdateCommand.Parameters(5).Value = CType(p6,Integer)
            Dim previousConnectionState As System.Data.ConnectionState = Me.Adapter.UpdateCommand.Connection.State
            If ((Me.Adapter.UpdateCommand.Connection.State And System.Data.ConnectionState.Open)  _
                        <> System.Data.ConnectionState.Open) Then
                Me.Adapter.UpdateCommand.Connection.Open
            End If
            Try 
                Dim returnValue As Integer = Me.Adapter.UpdateCommand.ExecuteNonQuery
                Return returnValue
            Finally
                If (previousConnectionState = System.Data.ConnectionState.Closed) Then
                    Me.Adapter.UpdateCommand.Connection.Close
                End If
            End Try
        End Function
    End Class
End Namespace

Namespace SmartEstateDataSetUtil
    
    Partial Public Class DesignerUtil
        
        Public Shared Function IsDesignTime() As Boolean
            'Determine if this instance is running against .NET Framework by using the MSCoreLib PublicKeyToken
            Dim mscorlibAssembly As System.Reflection.[Assembly] = GetType(Integer).Assembly
            If (Not (mscorlibAssembly) Is Nothing) Then
                If mscorlibAssembly.FullName.ToUpper.EndsWith("B77A5C561934E089") Then
                    Return true
                End If
            End If
            Return false
        End Function
        
        Public Shared Function IsRunTime() As Boolean
            'Determine if this instance is running against .NET Compact Framework by using the MSCoreLib PublicKeyToken
            Dim mscorlibAssembly As System.Reflection.[Assembly] = GetType(Integer).Assembly
            If (Not (mscorlibAssembly) Is Nothing) Then
                If mscorlibAssembly.FullName.ToUpper.EndsWith("969DB8053D3322AC") Then
                    Return true
                End If
            End If
            Return false
        End Function
    End Class
End Namespace
