Commands/Start-EFPoshModel.ps1

Function Start-EFPoshModel {
    <#
    .SYNOPSIS
    Starts a modeling of an existing database
     
    .DESCRIPTION
    Starts the modeling of an existing database
     
    .PARAMETER MSSQLServer
    SQL Server instance name
     
    .PARAMETER MSSQLDatabase
    SQL Server database
     
    .PARAMETER MSSQLIntegratedSecurity
    Integrated security
     
    .PARAMETER FilePath
    Path to output the file
     
    .PARAMETER Overwrite
    Overwrite an existing file or add to it?
     
    .PARAMETER EntitesToMap
    List of entities to map. Optional, can be provided with Add-EFPoshModelEntity also
     
    .PARAMETER AllEntities
    Switch - Will model the entire database. Only recommended for small databases
     
    .NOTES
    .Author: Ryan Ephgrave
    #>

    Param(
        [Parameter(Mandatory = $true, ParameterSetName = "MSSQL")]
        [string]$MSSQLServer,
        [Parameter(Mandatory = $true, ParameterSetName = "MSSQL")]
        [string]$MSSQLDatabase,
        [Parameter(Mandatory = $false, ParameterSetName = "MSSQL")]
        [bool]$MSSQLIntegratedSecurity = $true,
        [Parameter(Mandatory = $true, ParameterSetName = "MSSQL")]
        [string]$FilePath,
        [Parameter(Mandatory = $false, ParameterSetName = "MSSQL")]
        [switch]$Overwrite,
        [Parameter(Mandatory = $false, ParameterSetName = "MSSQL")]
        [string[]]$EntitesToMap,
        [Parameter(Mandatory = $false, ParameterSetName = "MSSQL")]
        [switch]$AllEntities,
        [Parameter(Mandatory = $false, ParameterSetName = "MSSQL")]
        [pscredential]$Credential,
        [Parameter(Mandatory = $false, ParameterSetName = "MSSQL")]
        [ValidateSet('Interactive', 'Network', 'Batch', 'Service', 'Unlock', 'NetworkCleartext', 'NewCredentials')]
        [string]$LogonType = 'Network'
    )
    Write-Verbose 'Creating new Model object'
    $ParentDirectory = ( Get-Item $PSScriptRoot ).Parent.FullName
    if($Overwrite){
        If(Test-Path $FilePath) { Remove-Item $FilePath -Force -ErrorAction Stop }
        If(Test-Path $FilePath) {
            throw "Could not remove existing file $FilePath with Remove-Item - Please remove it manually first"
            return
        }
    }
    If(-not (Test-Path $FilePath)) {
        $null = Copy-Item "$ParentDirectory\DBContexts\MSSqlTemplate.ps1" -Destination $FilePath -Force
        $Content = Get-Content $FilePath -Raw
        $Content = $Content.Replace('##Server##', $MSSQLServer).Replace('##Database##', $MSSQLDatabase).Replace("'##IntegratedSecurity##'", "`$$MSSQLIntegratedSecurity")
        $Content | Out-File $FilePath -Force -Encoding utf8
    }

    $optionalParams = @{}
    if($Credential){
        $optionalParams['Credential'] = $Credential
        $optionalParams['LogonType'] = $LogonType
    }

    $Context = & "$ParentDirectory\DBContexts\MSSqlInformationSchemasDbContext.ps1" -Server $MSSQLServer -Database $MSSQLDatabase -IntegratedSecurity $MSSQLIntegratedSecurity @optionalParams
    $TableList = @{}
    $ViewList = @{}
    $SchemaList = New-Object System.Collections.Generic.List[string]
    
    $AllTableInformation = $Context.MSSQLInformationSchemaTables.ToList()
    
    $UniqueSchemas = $AllTableInformation.TABLE_SCHEMA | Select-Object -Unique
    foreach($schema in $UniqueSchemas) { $SchemaList.Add($schema) }
    foreach($schema in $UniqueSchemas) {
        $TableList[$schema] = New-Object System.Collections.Generic.List[string]
        $ViewList[$schema] = New-Object System.Collections.Generic.List[string]
        foreach($table in $AllTableInformation) {
            if($table.TABLE_SCHEMA -eq $schema -and $table.TABLE_TYPE -ne 'View'){
                $TableList[$schema].Add($table.TABLE_NAME)
            }
            elseif($table.TABLE_SCHEMA -eq $schema) {
                $ViewList[$schema].Add($table.TABLE_NAME)
            }
        }
    }
    
    $Script:ContextFileSettings = @{
        'Context' = $Context
        'FilePath' = $FilePath
        'EntitiesToMap' = @($EntitesToMap)
        'Schemas' = $SchemaList
        'Tables' = $TableList
        'Views' = $ViewList
    }
    if($AllEntities) {
        $EntitesToMap = $AllTableInformation.TABLE_NAME
    }
    if($EntitesToMap.Count -gt 0){
        Foreach($entity in $EntitesToMap){
            Foreach($tableInfo in $AllTableInformation){
                if($tableInfo.Table_Name -eq $entity){
                    $null = Add-EFPoshModelEntity -DBSchema $tableInfo.TABLE_SCHEMA -Name $tableInfo.Table_Name
                }
            }
        }
    }
}