Free cookie consent management tool by TermsFeed Policy Generator

Changeset 7619


Ignore:
Timestamp:
03/15/12 13:26:25 (12 years ago)
Author:
ascheibe
Message:

#1648

  • added service description file
  • renamed database to correct name
  • fixed sql scripts for creating the db
Location:
branches/ClientUserManagement
Files:
4 added
3 deleted
10 edited

Legend:

Unmodified
Added
Removed

  • branches/ClientUserManagement/HeuristicLab.Services.Access-3.3.Tests/UnitTest.cs

    r7536 r7619  
    3333    [TestMethod]
    3434    public void ClearDB() {
    35       using (DA.ClientManagementDataContext context = new DA.ClientManagementDataContext()) {
     35      using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
    3636        context.ExecuteCommand("DELETE FROM dbo.ResourceResourceGroup");
    3737        context.ExecuteCommand("DELETE FROM dbo.ClientLog");

  • branches/ClientUserManagement/HeuristicLab.Services.Access.DataAccess/3.3/HeuristicLab.Services.Access.DataAccess-3.3.csproj

    r7367 r7619  
    5353      <DependentUpon>ASPNETAuthentication.dbml</DependentUpon>
    5454    </Compile>
    55     <Compile Include="ClientManagement.designer.cs">
    56       <DependentUpon>ClientManagement.dbml</DependentUpon>
     55    <Compile Include="AccessService.designer.cs">
     56      <DependentUpon>AccessService.dbml</DependentUpon>
    5757      <DesignTime>True</DesignTime>
    5858      <AutoGen>True</AutoGen>
    … …  
    7272      <SubType>Designer</SubType>
    7373    </None>
    74     <None Include="ClientManagement.dbml">
     74    <None Include="AccessService.dbml">
    7575      <Generator>MSLinqToSQLGenerator</Generator>
    76       <LastGenOutput>ClientManagement.designer.cs</LastGenOutput>
     76      <LastGenOutput>AccessService.designer.cs</LastGenOutput>
    7777      <SubType>Designer</SubType>
    7878    </None>
    … …  
    9393  </ItemGroup>
    9494  <ItemGroup>
    95     <None Include="ClientManagement.dbml.layout">
    96       <DependentUpon>ClientManagement.dbml</DependentUpon>
     95    <None Include="AccessService.dbml.layout">
     96      <DependentUpon>AccessService.dbml</DependentUpon>
    9797    </None>
    9898  </ItemGroup>

  • branches/ClientUserManagement/HeuristicLab.Services.Access.DataAccess/3.3/Properties/Settings.Designer.cs

    r6815 r7619  
    22// <auto-generated>
    33//     This code was generated by a tool.
    4 //     Runtime Version:4.0.30319.237
     4//     Runtime Version:4.0.30319.530
    55//
    66//     Changes to this file may cause incorrect behavior and will be lost if
    … …  
    3838        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
    3939        [global::System.Configuration.SpecialSettingAttribute(global::System.Configuration.SpecialSetting.ConnectionString)]
    40         [global::System.Configuration.DefaultSettingValueAttribute("Data Source=.;Initial Catalog=HeuristicLab.ClientManagement;Integrated Security=T" +
    41             "rue")]
     40        [global::System.Configuration.DefaultSettingValueAttribute("Data Source=.;Initial Catalog=HeuristicLab.AccessService;Integrated Security=True" +
     41            "")]
    4242        public string HeuristicLab_ClientManagementConnectionString {
    4343            get {

  • branches/ClientUserManagement/HeuristicLab.Services.Access.DataAccess/3.3/Properties/Settings.settings

    r6815 r7619  
    1414      <DesignTimeValue Profile="(Default)">&lt;?xml version="1.0" encoding="utf-16"?&gt;
    1515&lt;SerializableConnectionString xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"&gt;
    16   &lt;ConnectionString&gt;Data Source=.;Initial Catalog=HeuristicLab.ClientManagement;Integrated Security=True&lt;/ConnectionString&gt;
     16  &lt;ConnectionString&gt;Data Source=.;Initial Catalog=HeuristicLab.AccessService;Integrated Security=True&lt;/ConnectionString&gt;
    1717  &lt;ProviderName&gt;System.Data.SqlClient&lt;/ProviderName&gt;
    1818&lt;/SerializableConnectionString&gt;</DesignTimeValue>
    19       <Value Profile="(Default)">Data Source=.;Initial Catalog=HeuristicLab.ClientManagement;Integrated Security=True</Value>
     19      <Value Profile="(Default)">Data Source=.;Initial Catalog=HeuristicLab.AccessService;Integrated Security=True</Value>
    2020    </Setting>
    2121  </Settings>

  • branches/ClientUserManagement/HeuristicLab.Services.Access.DataAccess/3.3/SQL Scripts/Create ClientManagement.sql

    r6815 r7619  
    22GO
    33
    4 /****** Object:  Database [HeuristicLab.ClientManagement]    Script Date: 09/19/2011 13:21:28 ******/
    5 CREATE DATABASE [HeuristicLab.ClientManagement] ON  PRIMARY
    6 ( NAME = N'HeuristicLab.ClientManagement', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\HeuristicLab.ClientManagement.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
     4/****** Object:  Database [HeuristicLab.AccessService]    Script Date: 09/19/2011 13:21:28 ******/
     5CREATE DATABASE [HeuristicLab.AccessService] ON  PRIMARY
     6( NAME = N'HeuristicLab.AccessService', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\HeuristicLab.AccessService.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
    77 LOG ON
    8 ( NAME = N'HeuristicLab.ClientManagement_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\HeuristicLab.ClientManagement_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
     8( NAME = N'HeuristicLab.AccessService_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\HeuristicLab.AccessService_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
    99GO
    1010
    11 ALTER DATABASE [HeuristicLab.ClientManagement] SET COMPATIBILITY_LEVEL = 100
     11ALTER DATABASE [HeuristicLab.AccessService] SET COMPATIBILITY_LEVEL = 100
    1212GO
    1313
    1414IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
    1515begin
    16 EXEC [HeuristicLab.ClientManagement].[dbo].[sp_fulltext_database] @action = 'enable'
     16EXEC [HeuristicLab.AccessService].[dbo].[sp_fulltext_database] @action = 'enable'
    1717end
    1818GO
    1919
    20 ALTER DATABASE [HeuristicLab.ClientManagement] SET ANSI_NULL_DEFAULT OFF
     20ALTER DATABASE [HeuristicLab.AccessService] SET ANSI_NULL_DEFAULT OFF
    2121GO
    2222
    23 ALTER DATABASE [HeuristicLab.ClientManagement] SET ANSI_NULLS OFF
     23ALTER DATABASE [HeuristicLab.AccessService] SET ANSI_NULLS OFF
    2424GO
    2525
    26 ALTER DATABASE [HeuristicLab.ClientManagement] SET ANSI_PADDING OFF
     26ALTER DATABASE [HeuristicLab.AccessService] SET ANSI_PADDING OFF
    2727GO
    2828
    29 ALTER DATABASE [HeuristicLab.ClientManagement] SET ANSI_WARNINGS OFF
     29ALTER DATABASE [HeuristicLab.AccessService] SET ANSI_WARNINGS OFF
    3030GO
    3131
    32 ALTER DATABASE [HeuristicLab.ClientManagement] SET ARITHABORT OFF
     32ALTER DATABASE [HeuristicLab.AccessService] SET ARITHABORT OFF
    3333GO
    3434
    35 ALTER DATABASE [HeuristicLab.ClientManagement] SET AUTO_CLOSE OFF
     35ALTER DATABASE [HeuristicLab.AccessService] SET AUTO_CLOSE OFF
    3636GO
    3737
    38 ALTER DATABASE [HeuristicLab.ClientManagement] SET AUTO_CREATE_STATISTICS ON
     38ALTER DATABASE [HeuristicLab.AccessService] SET AUTO_CREATE_STATISTICS ON
    3939GO
    4040
    41 ALTER DATABASE [HeuristicLab.ClientManagement] SET AUTO_SHRINK OFF
     41ALTER DATABASE [HeuristicLab.AccessService] SET AUTO_SHRINK OFF
    4242GO
    4343
    44 ALTER DATABASE [HeuristicLab.ClientManagement] SET AUTO_UPDATE_STATISTICS ON
     44ALTER DATABASE [HeuristicLab.AccessService] SET AUTO_UPDATE_STATISTICS ON
    4545GO
    4646
    47 ALTER DATABASE [HeuristicLab.ClientManagement] SET CURSOR_CLOSE_ON_COMMIT OFF
     47ALTER DATABASE [HeuristicLab.AccessService] SET CURSOR_CLOSE_ON_COMMIT OFF
    4848GO
    4949
    50 ALTER DATABASE [HeuristicLab.ClientManagement] SET CURSOR_DEFAULT  GLOBAL
     50ALTER DATABASE [HeuristicLab.AccessService] SET CURSOR_DEFAULT  GLOBAL
    5151GO
    5252
    53 ALTER DATABASE [HeuristicLab.ClientManagement] SET CONCAT_NULL_YIELDS_NULL OFF
     53ALTER DATABASE [HeuristicLab.AccessService] SET CONCAT_NULL_YIELDS_NULL OFF
    5454GO
    5555
    56 ALTER DATABASE [HeuristicLab.ClientManagement] SET NUMERIC_ROUNDABORT OFF
     56ALTER DATABASE [HeuristicLab.AccessService] SET NUMERIC_ROUNDABORT OFF
    5757GO
    5858
    59 ALTER DATABASE [HeuristicLab.ClientManagement] SET QUOTED_IDENTIFIER OFF
     59ALTER DATABASE [HeuristicLab.AccessService] SET QUOTED_IDENTIFIER OFF
    6060GO
    6161
    62 ALTER DATABASE [HeuristicLab.ClientManagement] SET RECURSIVE_TRIGGERS OFF
     62ALTER DATABASE [HeuristicLab.AccessService] SET RECURSIVE_TRIGGERS OFF
    6363GO
    6464
    65 ALTER DATABASE [HeuristicLab.ClientManagement] SET  DISABLE_BROKER
     65ALTER DATABASE [HeuristicLab.AccessService] SET  DISABLE_BROKER
    6666GO
    6767
    68 ALTER DATABASE [HeuristicLab.ClientManagement] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
     68ALTER DATABASE [HeuristicLab.AccessService] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
    6969GO
    7070
    71 ALTER DATABASE [HeuristicLab.ClientManagement] SET DATE_CORRELATION_OPTIMIZATION OFF
     71ALTER DATABASE [HeuristicLab.AccessService] SET DATE_CORRELATION_OPTIMIZATION OFF
    7272GO
    7373
    74 ALTER DATABASE [HeuristicLab.ClientManagement] SET TRUSTWORTHY OFF
     74ALTER DATABASE [HeuristicLab.AccessService] SET TRUSTWORTHY OFF
    7575GO
    7676
    77 ALTER DATABASE [HeuristicLab.ClientManagement] SET ALLOW_SNAPSHOT_ISOLATION OFF
     77ALTER DATABASE [HeuristicLab.AccessService] SET ALLOW_SNAPSHOT_ISOLATION OFF
    7878GO
    7979
    80 ALTER DATABASE [HeuristicLab.ClientManagement] SET PARAMETERIZATION SIMPLE
     80ALTER DATABASE [HeuristicLab.AccessService] SET PARAMETERIZATION SIMPLE
    8181GO
    8282
    83 ALTER DATABASE [HeuristicLab.ClientManagement] SET READ_COMMITTED_SNAPSHOT OFF
     83ALTER DATABASE [HeuristicLab.AccessService] SET READ_COMMITTED_SNAPSHOT OFF
    8484GO
    8585
    86 ALTER DATABASE [HeuristicLab.ClientManagement] SET HONOR_BROKER_PRIORITY OFF
     86ALTER DATABASE [HeuristicLab.AccessService] SET HONOR_BROKER_PRIORITY OFF
    8787GO
    8888
    89 ALTER DATABASE [HeuristicLab.ClientManagement] SET  READ_WRITE
     89ALTER DATABASE [HeuristicLab.AccessService] SET  READ_WRITE
    9090GO
    9191
    92 ALTER DATABASE [HeuristicLab.ClientManagement] SET RECOVERY FULL
     92ALTER DATABASE [HeuristicLab.AccessService] SET RECOVERY FULL
    9393GO
    9494
    95 ALTER DATABASE [HeuristicLab.ClientManagement] SET  MULTI_USER
     95ALTER DATABASE [HeuristicLab.AccessService] SET  MULTI_USER
    9696GO
    9797
    98 ALTER DATABASE [HeuristicLab.ClientManagement] SET PAGE_VERIFY CHECKSUM 
     98ALTER DATABASE [HeuristicLab.AccessService] SET PAGE_VERIFY CHECKSUM 
    9999GO
    100100
    101 ALTER DATABASE [HeuristicLab.ClientManagement] SET DB_CHAINING OFF
     101ALTER DATABASE [HeuristicLab.AccessService] SET DB_CHAINING OFF
    102102GO
    103103

  • branches/ClientUserManagement/HeuristicLab.Services.Access.DataAccess/3.3/SQL Scripts/Create Initial Values.sql

    r6852 r7619  
    1 USE [HeuristicLab.ClientManagement]
     1USE [HeuristicLab.AccessService]
    22GO
    33
    44/** Client Configuration **/
    5 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[ClientConfiguration] (Hash, Description) VALUES ('','Custom Configuration');
     5INSERT INTO [HeuristicLab.AccessService].[dbo].[ClientConfiguration] (Hash, Description) VALUES ('','Custom Configuration');
    66
    77/** Country **/
    8 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('N/A');
    9 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Asia/Pacific Region');
    10 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Europe');
    11 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Andorra');
    12 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('United Arab Emirates');
    13 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Afghanistan');
    14 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Antigua and Barbuda');
    15 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Anguilla');
    16 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Albania');
    17 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Armenia');
    18 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Netherlands Antilles');
    19 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Angola');
    20 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Antarctica');
    21 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Argentina');
    22 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('American Samoa');
    23 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Austria');
    24 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Australia');
    25 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Aruba');
    26 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Azerbaijan');
    27 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Bosnia and Herzegovina');
    28 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Barbados');
    29 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Bangladesh');
    30 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Belgium');
    31 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Burkina Faso');
    32 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Bulgaria');
    33 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Bahrain');
    34 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Burundi');
    35 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Benin');
    36 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Bermuda');
    37 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Brunei Darussalam');
    38 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Bolivia');
    39 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Brazil');
    40 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Bahamas');
    41 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Bhutan');
    42 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Bouvet Island');
    43 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Botswana');
    44 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Belarus');
    45 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Belize');
    46 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Canada');
    47 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Cocos (Keeling) Islands');
    48 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Congo, The Democratic Republic of the');
    49 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Central African Republic');
    50 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Congo');
    51 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Switzerland');
    52 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Cote D''Ivoire');
    53 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Cook Islands');
    54 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Chile');
    55 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Cameroon');
    56 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('China');
    57 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Colombia');
    58 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Costa Rica');
    59 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Cuba');
    60 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Cape Verde');
    61 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Christmas Island');
    62 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Cyprus');
    63 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Czech Republic');
    64 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Germany');
    65 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Djibouti');
    66 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Denmark');
    67 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Dominica');
    68 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Dominican Republic');
    69 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Algeria');
    70 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Ecuador');
    71 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Estonia');
    72 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Egypt');
    73 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Western Sahara');
    74 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Eritrea');
    75 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Spain');
    76 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Ethiopia');
    77 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Finland');
    78 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Fiji');
    79 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Falkland Islands (Malvinas)');
    80 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Micronesia, Federated States of');
    81 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Faroe Islands');
    82 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('France');
    83 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('France, Metropolitan');
    84 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Gabon');
    85 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('United Kingdom');
    86 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Grenada');
    87 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Georgia');
    88 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('French Guiana');
    89 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Ghana');
    90 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Gibraltar');
    91 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Greenland');
    92 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Gambia');
    93 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Guinea');
    94 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Guadeloupe');
    95 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Equatorial Guinea');
    96 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Greece');
    97 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('South Georgia and the South Sandwich Islands');
    98 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Guatemala');
    99 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Guam');
    100 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Guinea-Bissau');
    101 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Guyana');
    102 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Hong Kong');
    103 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Heard Island and McDonald Islands');
    104 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Honduras');
    105 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Croatia');
    106 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Haiti');
    107 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Hungary');
    108 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Indonesia');
    109 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Ireland');
    110 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Israel');
    111 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('India');
    112 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('British Indian Ocean Territory');
    113 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Iraq');
    114 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Iran, Islamic Republic of');
    115 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Iceland');
    116 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Italy');
    117 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Jamaica');
    118 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Jordan');
    119 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Japan');
    120 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Kenya');
    121 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Kyrgyzstan');
    122 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Cambodia');
    123 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Kiribati');
    124 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Comoros');
    125 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Saint Kitts and Nevis');
    126 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Korea, Democratic People''s Republic of');
    127 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Korea, Republic of');
    128 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Kuwait');
    129 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Cayman Islands');
    130 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Kazakhstan');
    131 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Lao People''s Democratic Republic');
    132 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Lebanon');
    133 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Saint Lucia');
    134 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Liechtenstein');
    135 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Sri Lanka');
    136 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Liberia');
    137 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Lesotho');
    138 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Lithuania');
    139 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Luxembourg');
    140 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Latvia');
    141 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Libyan Arab Jamahiriya');
    142 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Morocco');
    143 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Monaco');
    144 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Moldova, Republic of');
    145 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Madagascar');
    146 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Marshall Islands');
    147 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Macedonia, the Former Yugoslav Republic of');
    148 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Mali');
    149 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Myanmar');
    150 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Mongolia');
    151 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Macau');
    152 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Northern Mariana Islands');
    153 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Martinique');
    154 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Mauritania');
    155 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Montserrat');
    156 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Malta');
    157 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Mauritius');
    158 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Maldives');
    159 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Malawi');
    160 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Mexico');
    161 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Malaysia');
    162 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Mozambique');
    163 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Namibia');
    164 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('New Caledonia');
    165 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Niger');
    166 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Norfolk Island');
    167 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Nigeria');
    168 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Nicaragua');
    169 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Netherlands');
    170 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Norway');
    171 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Nepal');
    172 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Nauru');
    173 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Niue');
    174 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('New Zealand');
    175 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Oman');
    176 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Panama');
    177 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Peru');
    178 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('French Polynesia');
    179 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Papua New Guinea');
    180 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Philippines');
    181 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Pakistan');
    182 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Poland');
    183 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Saint Pierre and Miquelon');
    184 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Pitcairn');
    185 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Puerto Rico');
    186 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Palestinian Territory, Occupied');
    187 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Portugal');
    188 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Palau');
    189 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Paraguay');
    190 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Qatar');
    191 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Reunion');
    192 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Romania');
    193 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Russian Federation');
    194 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Rwanda');
    195 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Saudi Arabia');
    196 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Solomon Islands');
    197 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Seychelles');
    198 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Sudan');
    199 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Sweden');
    200 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Singapore');
    201 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Saint Helena');
    202 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Slovenia');
    203 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Svalbard and Jan Mayen');
    204 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Slovakia');
    205 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Sierra Leone');
    206 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('San Marino');
    207 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Senegal');
    208 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Somalia');
    209 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Suriname');
    210 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Sao Tome and Principe');
    211 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('El Salvador');
    212 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Syrian Arab Republic');
    213 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Swaziland');
    214 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Turks and Caicos Islands');
    215 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Chad');
    216 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('French Southern Territories');
    217 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Togo');
    218 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Thailand');
    219 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Tajikistan');
    220 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Tokelau');
    221 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Turkmenistan');
    222 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Tunisia');
    223 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Tonga');
    224 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Timor-Leste');
    225 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Turkey');
    226 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Trinidad and Tobago');
    227 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Tuvalu');
    228 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Taiwan');
    229 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Tanzania, United Republic of');
    230 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Ukraine');
    231 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Uganda');
    232 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('United States Minor Outlying Islands');
    233 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('United States');
    234 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Uruguay');
    235 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Uzbekistan');
    236 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Holy See (Vatican City State)');
    237 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Saint Vincent and the Grenadines');
    238 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Venezuela');
    239 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Virgin Islands, British');
    240 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Virgin Islands, U.S.');
    241 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Vietnam');
    242 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Vanuatu');
    243 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Wallis and Futuna');
    244 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Samoa');
    245 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Yemen');
    246 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Mayotte');
    247 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Serbia');
    248 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('South Africa');
    249 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Zambia');
    250 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Montenegro');
    251 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Zimbabwe');
    252 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Anonymous Proxy');
    253 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Satellite Provider');
    254 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Other');
    255 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Aland Islands');
    256 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Guernsey');
    257 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Isle of Man');
    258 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Jersey');
    259 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Saint Barthelemy');
    260 INSERT INTO [HeuristicLab.ClientManagement].[dbo].[Country] (Name) VALUES ('Saint Martin');
     8INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('N/A');
     9INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Asia/Pacific Region');
     10INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Europe');
     11INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Andorra');
     12INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('United Arab Emirates');
     13INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Afghanistan');
     14INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Antigua and Barbuda');
     15INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Anguilla');
     16INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Albania');
     17INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Armenia');
     18INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Netherlands Antilles');
     19INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Angola');
     20INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Antarctica');
     21INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Argentina');
     22INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('American Samoa');
     23INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Austria');
     24INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Australia');
     25INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Aruba');
     26INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Azerbaijan');
     27INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Bosnia and Herzegovina');
     28INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Barbados');
     29INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Bangladesh');
     30INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Belgium');
     31INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Burkina Faso');
     32INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Bulgaria');
     33INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Bahrain');
     34INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Burundi');
     35INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Benin');
     36INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Bermuda');
     37INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Brunei Darussalam');
     38INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Bolivia');
     39INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Brazil');
     40INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Bahamas');
     41INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Bhutan');
     42INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Bouvet Island');
     43INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Botswana');
     44INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Belarus');
     45INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Belize');
     46INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Canada');
     47INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Cocos (Keeling) Islands');
     48INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Congo, The Democratic Republic of the');
     49INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Central African Republic');
     50INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Congo');
     51INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Switzerland');
     52INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Cote D''Ivoire');
     53INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Cook Islands');
     54INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Chile');
     55INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Cameroon');
     56INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('China');
     57INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Colombia');
     58INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Costa Rica');
     59INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Cuba');
     60INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Cape Verde');
     61INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Christmas Island');
     62INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Cyprus');
     63INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Czech Republic');
     64INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Germany');
     65INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Djibouti');
     66INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Denmark');
     67INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Dominica');
     68INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Dominican Republic');
     69INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Algeria');
     70INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Ecuador');
     71INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Estonia');
     72INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Egypt');
     73INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Western Sahara');
     74INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Eritrea');
     75INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Spain');
     76INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Ethiopia');
     77INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Finland');
     78INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Fiji');
     79INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Falkland Islands (Malvinas)');
     80INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Micronesia, Federated States of');
     81INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Faroe Islands');
     82INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('France');
     83INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('France, Metropolitan');
     84INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Gabon');
     85INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('United Kingdom');
     86INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Grenada');
     87INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Georgia');
     88INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('French Guiana');
     89INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Ghana');
     90INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Gibraltar');
     91INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Greenland');
     92INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Gambia');
     93INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Guinea');
     94INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Guadeloupe');
     95INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Equatorial Guinea');
     96INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Greece');
     97INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('South Georgia and the South Sandwich Islands');
     98INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Guatemala');
     99INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Guam');
     100INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Guinea-Bissau');
     101INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Guyana');
     102INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Hong Kong');
     103INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Heard Island and McDonald Islands');
     104INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Honduras');
     105INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Croatia');
     106INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Haiti');
     107INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Hungary');
     108INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Indonesia');
     109INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Ireland');
     110INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Israel');
     111INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('India');
     112INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('British Indian Ocean Territory');
     113INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Iraq');
     114INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Iran, Islamic Republic of');
     115INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Iceland');
     116INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Italy');
     117INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Jamaica');
     118INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Jordan');
     119INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Japan');
     120INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Kenya');
     121INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Kyrgyzstan');
     122INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Cambodia');
     123INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Kiribati');
     124INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Comoros');
     125INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Saint Kitts and Nevis');
     126INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Korea, Democratic People''s Republic of');
     127INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Korea, Republic of');
     128INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Kuwait');
     129INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Cayman Islands');
     130INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Kazakhstan');
     131INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Lao People''s Democratic Republic');
     132INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Lebanon');
     133INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Saint Lucia');
     134INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Liechtenstein');
     135INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Sri Lanka');
     136INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Liberia');
     137INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Lesotho');
     138INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Lithuania');
     139INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Luxembourg');
     140INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Latvia');
     141INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Libyan Arab Jamahiriya');
     142INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Morocco');
     143INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Monaco');
     144INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Moldova, Republic of');
     145INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Madagascar');
     146INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Marshall Islands');
     147INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Macedonia, the Former Yugoslav Republic of');
     148INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Mali');
     149INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Myanmar');
     150INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Mongolia');
     151INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Macau');
     152INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Northern Mariana Islands');
     153INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Martinique');
     154INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Mauritania');
     155INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Montserrat');
     156INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Malta');
     157INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Mauritius');
     158INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Maldives');
     159INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Malawi');
     160INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Mexico');
     161INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Malaysia');
     162INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Mozambique');
     163INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Namibia');
     164INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('New Caledonia');
     165INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Niger');
     166INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Norfolk Island');
     167INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Nigeria');
     168INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Nicaragua');
     169INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Netherlands');
     170INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Norway');
     171INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Nepal');
     172INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Nauru');
     173INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Niue');
     174INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('New Zealand');
     175INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Oman');
     176INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Panama');
     177INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Peru');
     178INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('French Polynesia');
     179INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Papua New Guinea');
     180INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Philippines');
     181INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Pakistan');
     182INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Poland');
     183INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Saint Pierre and Miquelon');
     184INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Pitcairn');
     185INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Puerto Rico');
     186INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Palestinian Territory, Occupied');
     187INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Portugal');
     188INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Palau');
     189INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Paraguay');
     190INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Qatar');
     191INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Reunion');
     192INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Romania');
     193INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Russian Federation');
     194INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Rwanda');
     195INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Saudi Arabia');
     196INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Solomon Islands');
     197INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Seychelles');
     198INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Sudan');
     199INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Sweden');
     200INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Singapore');
     201INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Saint Helena');
     202INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Slovenia');
     203INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Svalbard and Jan Mayen');
     204INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Slovakia');
     205INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Sierra Leone');
     206INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('San Marino');
     207INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Senegal');
     208INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Somalia');
     209INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Suriname');
     210INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Sao Tome and Principe');
     211INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('El Salvador');
     212INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Syrian Arab Republic');
     213INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Swaziland');
     214INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Turks and Caicos Islands');
     215INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Chad');
     216INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('French Southern Territories');
     217INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Togo');
     218INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Thailand');
     219INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Tajikistan');
     220INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Tokelau');
     221INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Turkmenistan');
     222INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Tunisia');
     223INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Tonga');
     224INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Timor-Leste');
     225INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Turkey');
     226INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Trinidad and Tobago');
     227INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Tuvalu');
     228INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Taiwan');
     229INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Tanzania, United Republic of');
     230INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Ukraine');
     231INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Uganda');
     232INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('United States Minor Outlying Islands');
     233INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('United States');
     234INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Uruguay');
     235INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Uzbekistan');
     236INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Holy See (Vatican City State)');
     237INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Saint Vincent and the Grenadines');
     238INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Venezuela');
     239INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Virgin Islands, British');
     240INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Virgin Islands, U.S.');
     241INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Vietnam');
     242INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Vanuatu');
     243INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Wallis and Futuna');
     244INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Samoa');
     245INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Yemen');
     246INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Mayotte');
     247INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Serbia');
     248INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('South Africa');
     249INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Zambia');
     250INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Montenegro');
     251INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Zimbabwe');
     252INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Anonymous Proxy');
     253INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Satellite Provider');
     254INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Other');
     255INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Aland Islands');
     256INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Guernsey');
     257INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Isle of Man');
     258INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Jersey');
     259INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Saint Barthelemy');
     260INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Saint Martin');

  • branches/ClientUserManagement/HeuristicLab.Services.Access.DataAccess/3.3/SQL Scripts/Initialize ClientManagement.sql

    r7534 r7619  
    1 USE [HeuristicLab.ClientManagement]
     1USE [HeuristicLab.AccessService]
    22GO
    33
    … …  
    2424GO
    2525
    26 USE [HeuristicLab.ClientManagement]
    27 GO
    28 
    29 /****** Object:  Table [dbo].[ClientError]    Script Date: 09/27/2011 17:05:38 ******/
    30 SET ANSI_NULLS ON
    31 GO
    32 
    33 SET QUOTED_IDENTIFIER ON
    34 GO
    35 
    36 CREATE TABLE [dbo].[ClientError](
    37   [Id] [uniqueidentifier] NOT NULL,
    38   [Timestamp] [datetime] NOT NULL,
    39   [Exception] [nvarchar](max) NULL,
    40   [UserComment] [nvarchar](max) NULL,
    41   [ConfigDump] [nvarchar](max) NULL,
    42   [ClientId] [uniqueidentifier] NULL,
    43   [UserId] [uniqueidentifier] NULL,
    44  CONSTRAINT [PK_ClientError] PRIMARY KEY CLUSTERED
    45 (
    46   [Id] ASC
    47 )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
    48 ) ON [PRIMARY]
    49 
    50 GO
    51 
    52 ALTER TABLE [dbo].[ClientError]  WITH CHECK ADD  CONSTRAINT [FK_ClientError_Resource] FOREIGN KEY([ClientId])
    53 REFERENCES [dbo].[Resource] ([Id])
    54 GO
    55 
    56 ALTER TABLE [dbo].[ClientError] CHECK CONSTRAINT [FK_ClientError_Resource]
    57 GO
    58 
    59 ALTER TABLE [dbo].[ClientError]  WITH CHECK ADD  CONSTRAINT [FK_ClientError_UserGroup] FOREIGN KEY([UserId])
    60 REFERENCES [dbo].[UserGroup] ([Id])
    61 GO
    62 
    63 ALTER TABLE [dbo].[ClientError] CHECK CONSTRAINT [FK_ClientError_UserGroup]
    64 GO
    65 
    66 ALTER TABLE [dbo].[ClientError] ADD  CONSTRAINT [DF_ClientError_Id]  DEFAULT (newsequentialid()) FOR [Id]
    67 GO
    68 
    69 USE [HeuristicLab.ClientManagement]
    70 GO
    71 
    72 /****** Object:  Table [dbo].[ClientLog]    Script Date: 09/27/2011 17:05:50 ******/
    73 SET ANSI_NULLS ON
    74 GO
    75 
    76 SET QUOTED_IDENTIFIER ON
    77 GO
    78 
    79 CREATE TABLE [dbo].[ClientLog](
    80   [Timestamp] [datetime] NOT NULL,
    81   [ResourceId] [uniqueidentifier] NOT NULL,
    82   [Message] [nvarchar](max) NULL,
    83  CONSTRAINT [PK_ClientLog] PRIMARY KEY CLUSTERED
    84 (
    85   [Timestamp] ASC,
    86   [ResourceId] ASC
    87 )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
    88 ) ON [PRIMARY]
    89 
    90 GO
    91 
    92 ALTER TABLE [dbo].[ClientLog]  WITH CHECK ADD  CONSTRAINT [FK_ClientLog_Resource] FOREIGN KEY([ResourceId])
    93 REFERENCES [dbo].[Resource] ([Id])
    94 GO
    95 
    96 ALTER TABLE [dbo].[ClientLog] CHECK CONSTRAINT [FK_ClientLog_Resource]
    97 GO
    98 
    99 
    100 USE [HeuristicLab.ClientManagement]
     26USE [HeuristicLab.AccessService]
    10127GO
    10228
    … …  
    12248GO
    12349
    124 USE [HeuristicLab.ClientManagement]
     50USE [HeuristicLab.AccessService]
    12551GO
    12652
    … …  
    14672GO
    14773
    148 USE [HeuristicLab.ClientManagement]
     74USE [HeuristicLab.AccessService]
    14975GO
    15076
    … …  
    17096GO
    17197
    172 USE [HeuristicLab.ClientManagement]
     98USE [HeuristicLab.AccessService]
    17399GO
    174100
    … …  
    196122GO
    197123
    198 
    199 USE [HeuristicLab.ClientManagement]
    200 GO
    201 
    202 /****** Object:  Table [dbo].[ResourcePlugin]    Script Date: 09/27/2011 17:07:01 ******/
    203 SET ANSI_NULLS ON
    204 GO
    205 
    206 SET QUOTED_IDENTIFIER ON
    207 GO
    208 
    209 CREATE TABLE [dbo].[ResourcePlugin](
    210   [ResourceId] [uniqueidentifier] NOT NULL,
    211   [PluginId] [uniqueidentifier] NOT NULL,
    212  CONSTRAINT [PK_ResourcePlugin] PRIMARY KEY CLUSTERED
    213 (
    214   [ResourceId] ASC,
    215   [PluginId] ASC
    216 )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
    217 ) ON [PRIMARY]
    218 
    219 GO
    220 
    221 ALTER TABLE [dbo].[ResourcePlugin]  WITH CHECK ADD  CONSTRAINT [FK_ResourcePlugin_Plugin] FOREIGN KEY([PluginId])
    222 REFERENCES [dbo].[Plugin] ([Id])
    223 GO
    224 
    225 ALTER TABLE [dbo].[ResourcePlugin] CHECK CONSTRAINT [FK_ResourcePlugin_Plugin]
    226 GO
    227 
    228 ALTER TABLE [dbo].[ResourcePlugin]  WITH CHECK ADD  CONSTRAINT [FK_ResourcePlugin_Resource] FOREIGN KEY([ResourceId])
    229 REFERENCES [dbo].[Resource] ([Id])
    230 GO
    231 
    232 ALTER TABLE [dbo].[ResourcePlugin] CHECK CONSTRAINT [FK_ResourcePlugin_Resource]
    233 GO
    234 
    235 
    236 USE [HeuristicLab.ClientManagement]
    237 GO
    238 
    239 /****** Object:  Table [dbo].[ResourceResourceGroup]    Script Date: 09/27/2011 17:07:08 ******/
    240 SET ANSI_NULLS ON
    241 GO
    242 
    243 SET QUOTED_IDENTIFIER ON
    244 GO
    245 
    246 CREATE TABLE [dbo].[ResourceResourceGroup](
    247   [ResourceId] [uniqueidentifier] NOT NULL,
    248   [ResourceGroupId] [uniqueidentifier] NOT NULL,
    249  CONSTRAINT [PK_ResourceResourceGroup_Id] PRIMARY KEY CLUSTERED
    250 (
    251   [ResourceId] ASC,
    252   [ResourceGroupId] ASC
    253 )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
    254 ) ON [PRIMARY]
    255 
    256 GO
    257 
    258 ALTER TABLE [dbo].[ResourceResourceGroup]  WITH CHECK ADD  CONSTRAINT [FK_ResourceResourceGroup_ResourceGroupId] FOREIGN KEY([ResourceGroupId])
    259 REFERENCES [dbo].[Resource] ([Id])
    260 GO
    261 
    262 ALTER TABLE [dbo].[ResourceResourceGroup] CHECK CONSTRAINT [FK_ResourceResourceGroup_ResourceGroupId]
    263 GO
    264 
    265 ALTER TABLE [dbo].[ResourceResourceGroup]  WITH CHECK ADD  CONSTRAINT [FK_ResourceResourceGroup_ResourceId] FOREIGN KEY([ResourceId])
    266 REFERENCES [dbo].[Resource] ([Id])
    267 GO
    268 
    269 ALTER TABLE [dbo].[ResourceResourceGroup] CHECK CONSTRAINT [FK_ResourceResourceGroup_ResourceId]
    270 GO
    271 
    272 USE [HeuristicLab.ClientManagement]
     124USE [HeuristicLab.AccessService]
    273125GO
    274126
    … …  
    334186GO
    335187
    336 USE [HeuristicLab.ClientManagement]
     188USE [HeuristicLab.AccessService]
     189GO
     190
     191/****** Object:  Table [dbo].[ResourceResourceGroup]    Script Date: 09/27/2011 17:07:08 ******/
     192SET ANSI_NULLS ON
     193GO
     194
     195SET QUOTED_IDENTIFIER ON
     196GO
     197
     198CREATE TABLE [dbo].[ResourceResourceGroup](
     199  [ResourceId] [uniqueidentifier] NOT NULL,
     200  [ResourceGroupId] [uniqueidentifier] NOT NULL,
     201 CONSTRAINT [PK_ResourceResourceGroup_Id] PRIMARY KEY CLUSTERED
     202(
     203  [ResourceId] ASC,
     204  [ResourceGroupId] ASC
     205)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
     206) ON [PRIMARY]
     207
     208GO
     209
     210ALTER TABLE [dbo].[ResourceResourceGroup]  WITH CHECK ADD  CONSTRAINT [FK_ResourceResourceGroup_ResourceGroupId] FOREIGN KEY([ResourceGroupId])
     211REFERENCES [dbo].[Resource] ([Id])
     212GO
     213
     214ALTER TABLE [dbo].[ResourceResourceGroup] CHECK CONSTRAINT [FK_ResourceResourceGroup_ResourceGroupId]
     215GO
     216
     217ALTER TABLE [dbo].[ResourceResourceGroup]  WITH CHECK ADD  CONSTRAINT [FK_ResourceResourceGroup_ResourceId] FOREIGN KEY([ResourceId])
     218REFERENCES [dbo].[Resource] ([Id])
     219GO
     220
     221ALTER TABLE [dbo].[ResourceResourceGroup] CHECK CONSTRAINT [FK_ResourceResourceGroup_ResourceId]
     222GO
     223
     224USE [HeuristicLab.AccessService]
     225GO
     226
     227/****** Object:  Table [dbo].[ResourcePlugin]    Script Date: 09/27/2011 17:07:01 ******/
     228SET ANSI_NULLS ON
     229GO
     230
     231SET QUOTED_IDENTIFIER ON
     232GO
     233
     234CREATE TABLE [dbo].[ResourcePlugin](
     235  [ResourceId] [uniqueidentifier] NOT NULL,
     236  [PluginId] [uniqueidentifier] NOT NULL,
     237 CONSTRAINT [PK_ResourcePlugin] PRIMARY KEY CLUSTERED
     238(
     239  [ResourceId] ASC,
     240  [PluginId] ASC
     241)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
     242) ON [PRIMARY]
     243
     244GO
     245
     246ALTER TABLE [dbo].[ResourcePlugin]  WITH CHECK ADD  CONSTRAINT [FK_ResourcePlugin_Plugin] FOREIGN KEY([PluginId])
     247REFERENCES [dbo].[Plugin] ([Id])
     248GO
     249
     250ALTER TABLE [dbo].[ResourcePlugin] CHECK CONSTRAINT [FK_ResourcePlugin_Plugin]
     251GO
     252
     253ALTER TABLE [dbo].[ResourcePlugin]  WITH CHECK ADD  CONSTRAINT [FK_ResourcePlugin_Resource] FOREIGN KEY([ResourceId])
     254REFERENCES [dbo].[Resource] ([Id])
     255GO
     256
     257ALTER TABLE [dbo].[ResourcePlugin] CHECK CONSTRAINT [FK_ResourcePlugin_Resource]
     258GO
     259
     260USE [HeuristicLab.AccessService]
    337261GO
    338262
    … …  
    357281GO
    358282
    359 USE [HeuristicLab.ClientManagement]
     283USE [HeuristicLab.AccessService]
    360284GO
    361285
    … …  
    394318
    395319
    396 
    397 
    398 
    399 
    400 
    401 
    402 
    403 
     320USE [HeuristicLab.AccessService]
     321GO
     322
     323/****** Object:  Table [dbo].[ClientError]    Script Date: 09/27/2011 17:05:38 ******/
     324SET ANSI_NULLS ON
     325GO
     326
     327SET QUOTED_IDENTIFIER ON
     328GO
     329
     330CREATE TABLE [dbo].[ClientError](
     331  [Id] [uniqueidentifier] NOT NULL,
     332  [Timestamp] [datetime] NOT NULL,
     333  [Exception] [nvarchar](max) NULL,
     334  [UserComment] [nvarchar](max) NULL,
     335  [ConfigDump] [nvarchar](max) NULL,
     336  [ClientId] [uniqueidentifier] NULL,
     337  [UserId] [uniqueidentifier] NULL,
     338 CONSTRAINT [PK_ClientError] PRIMARY KEY CLUSTERED
     339(
     340  [Id] ASC
     341)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
     342) ON [PRIMARY]
     343
     344GO
     345
     346ALTER TABLE [dbo].[ClientError]  WITH CHECK ADD  CONSTRAINT [FK_ClientError_Resource] FOREIGN KEY([ClientId])
     347REFERENCES [dbo].[Resource] ([Id])
     348GO
     349
     350ALTER TABLE [dbo].[ClientError] CHECK CONSTRAINT [FK_ClientError_Resource]
     351GO
     352
     353ALTER TABLE [dbo].[ClientError]  WITH CHECK ADD  CONSTRAINT [FK_ClientError_UserGroup] FOREIGN KEY([UserId])
     354REFERENCES [dbo].[UserGroup] ([Id])
     355GO
     356
     357ALTER TABLE [dbo].[ClientError] CHECK CONSTRAINT [FK_ClientError_UserGroup]
     358GO
     359
     360ALTER TABLE [dbo].[ClientError] ADD  CONSTRAINT [DF_ClientError_Id]  DEFAULT (newsequentialid()) FOR [Id]
     361GO
     362
     363USE [HeuristicLab.AccessService]
     364GO
     365
     366/****** Object:  Table [dbo].[ClientLog]    Script Date: 09/27/2011 17:05:50 ******/
     367SET ANSI_NULLS ON
     368GO
     369
     370SET QUOTED_IDENTIFIER ON
     371GO
     372
     373CREATE TABLE [dbo].[ClientLog](
     374  [Timestamp] [datetime] NOT NULL,
     375  [ResourceId] [uniqueidentifier] NOT NULL,
     376  [Message] [nvarchar](max) NULL,
     377 CONSTRAINT [PK_ClientLog] PRIMARY KEY CLUSTERED
     378(
     379  [Timestamp] ASC,
     380  [ResourceId] ASC
     381)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
     382) ON [PRIMARY]
     383
     384GO
     385
     386ALTER TABLE [dbo].[ClientLog]  WITH CHECK ADD  CONSTRAINT [FK_ClientLog_Resource] FOREIGN KEY([ResourceId])
     387REFERENCES [dbo].[Resource] ([Id])
     388GO
     389
     390ALTER TABLE [dbo].[ClientLog] CHECK CONSTRAINT [FK_ClientLog_Resource]
     391GO
     392
     393
     394
     395
     396
     397

  • branches/ClientUserManagement/HeuristicLab.Services.Access.DataAccess/3.3/app.config

    r6815 r7619  
    66        <add name="HeuristicLab.Services.Directoy.DataAccess.Properties.Settings.HeuristicLab_AuthenticationConnectionString"
    77            connectionString="Data Source=.;Initial Catalog=HeuristicLab.Authentication;Integrated Security=True"
    8             providerName="System.Data.SqlClient" />       
     8            providerName="System.Data.SqlClient" />
    99        <add name="HeuristicLab.Services.Access.DataAccess.Properties.Settings.HeuristicLab_ClientManagementConnectionString"
    10             connectionString="Data Source=.;Initial Catalog=HeuristicLab.ClientManagement;Integrated Security=True"
     10            connectionString="Data Source=.;Initial Catalog=HeuristicLab.AccessService;Integrated Security=True"
     11            providerName="System.Data.SqlClient" />
     12        <add name="HeuristicLab.Services.Access.DataAccess.Properties.Settings.HeuristicLab_AuthenticationConnectionString"
     13            connectionString="Data Source=.;Initial Catalog=HeuristicLab.Authentication;Integrated Security=True"
    1114            providerName="System.Data.SqlClient" />
    1215    </connectionStrings>

  • branches/ClientUserManagement/HeuristicLab.Services.Access/3.3/AccessService.cs

    r7614 r7619  
    5252    public bool ClientExists(Guid id) {
    5353      if (id != Guid.Empty) {
    54         using (DA.ClientManagementDataContext context = new DA.ClientManagementDataContext()) {
     54        using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
    5555          return (context.Resources.Where(x => x.Id == id).Count() != 0);
    5656        }
    … …  
    6060
    6161    public DT.Client GetClient(Guid id) {
    62       using (DA.ClientManagementDataContext context = new DA.ClientManagementDataContext()) {
     62      using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
    6363        var query = from c in context.GetTable<DA.Resource>().OfType<DA.Client>()
    6464                    where c.Id == id
    … …  
    7373
    7474    public IEnumerable<DT.Client> GetClients(IEnumerable<Guid> ids) {
    75       using (DA.ClientManagementDataContext context = new DA.ClientManagementDataContext()) {
     75      using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
    7676        var query = from c in context.GetTable<DA.Resource>().OfType<DA.Client>()
    7777                    where ids.Contains(c.Id)
    … …  
    8282
    8383    public IEnumerable<DT.Client> GetAllClients() {
    84       using (DA.ClientManagementDataContext context = new DA.ClientManagementDataContext()) {
     84      using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
    8585        var query = from c in context.GetTable<DA.Resource>().OfType<DA.Client>()
    8686                    select Convert.ToDto(c);
    … …  
    101101      }
    102102
    103       using (DA.ClientManagementDataContext context = new DA.ClientManagementDataContext()) {
     103      using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
    104104        DA.Client entity = Convert.ToEntity(client);
    105105
    … …  
    145145      RoleVerifier.AuthenticateForAllRoles(AccessServiceRoles.Administrator);
    146146
    147       using (DA.ClientManagementDataContext context = new DA.ClientManagementDataContext()) {
     147      using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
    148148        //load client because we could get a detached object
    149149        var query = from c in context.GetTable<DA.Resource>().OfType<DA.Client>()
    … …  
    167167    #region ClientGroup
    168168    public IEnumerable<DT.ClientGroup> GetAllClientGroups() {
    169       using (DA.ClientManagementDataContext context = new DA.ClientManagementDataContext()) {
     169      using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
    170170        var query = from c in context.GetTable<DA.Resource>().OfType<DA.ClientGroup>()
    171171                    select Convert.ToDto(c);
    … …  
    175175
    176176    public IEnumerable<DT.ClientGroup> GetClientGroups(IEnumerable<Guid> ids) {
    177       using (DA.ClientManagementDataContext context = new DA.ClientManagementDataContext()) {
     177      using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
    178178        var query = from c in context.GetTable<DA.Resource>().OfType<DA.ClientGroup>()
    179179                    where ids.Contains(c.Id)
    … …  
    184184
    185185    public Guid AddClientGroup(DT.ClientGroup group) {
    186       using (DA.ClientManagementDataContext context = new DA.ClientManagementDataContext()) {
     186      using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
    187187        if (group.Id == Guid.Empty)
    188188          group.Id = Guid.NewGuid();
    … …  
    202202      RoleVerifier.AuthenticateForAllRoles(AccessServiceRoles.Administrator);
    203203
    204       using (DA.ClientManagementDataContext context = new DA.ClientManagementDataContext()) {
     204      using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
    205205        //load clientGroup because we could get a detached object
    206206        var query = from c in context.GetTable<DA.Resource>().OfType<DA.ClientGroup>()
    … …  
    215215
    216216    public void AddResourceToGroup(DT.Resource resource, DT.ClientGroup group) {
    217       using (DA.ClientManagementDataContext context = new DA.ClientManagementDataContext()) {
     217      using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
    218218        DA.ResourceResourceGroup rrg = new DA.ResourceResourceGroup() {
    219219          ResourceId = resource.Id,
    … …  
    227227
    228228    public void RemoveResourceFromGroup(DT.Resource resource, DT.ClientGroup group) {
    229       using (DA.ClientManagementDataContext context = new DA.ClientManagementDataContext()) {
     229      using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
    230230        var query = context.ResourceResourceGroups.Where(x => x.ResourceId == resource.Id && x.ResourceGroupId == group.Id);
    231231        if (query.Count() > 0) {
    … …  
    239239    #region ClientGroupMapping
    240240    public IEnumerable<DT.ClientGroupMapping> GetClientGroupMapping() {
    241       using (DA.ClientManagementDataContext context = new DA.ClientManagementDataContext()) {
     241      using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
    242242        var query = from c in context.GetTable<DA.ResourceResourceGroup>()
    243243                    select Convert.ToDto(c);
    … …  
    249249    #region Resource
    250250    public IEnumerable<DT.Resource> GetResources() {
    251       using (DA.ClientManagementDataContext context = new DA.ClientManagementDataContext()) {
     251      using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
    252252        var query = from r in context.Resources
    253253                    select Convert.ToDto(r);
    … …  
    259259    #region ClientLog
    260260    public DT.ClientLog GetLastClientLog(Guid clientId) {
    261       using (DA.ClientManagementDataContext context = new DA.ClientManagementDataContext()) {
     261      using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
    262262        var query = from r in context.ClientLogs
    263263                    where r.ResourceId == clientId
    … …  
    268268
    269269    public IEnumerable<DT.ClientLog> GetClientLogs(Guid clientId) {
    270       using (DA.ClientManagementDataContext context = new DA.ClientManagementDataContext()) {
     270      using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
    271271        var query = from r in context.ClientLogs
    272272                    where r.ResourceId == clientId
    … …  
    277277
    278278    public IEnumerable<DT.ClientLog> GetClientLogsSince(DateTime startDate) {
    279       using (DA.ClientManagementDataContext context = new DA.ClientManagementDataContext()) {
     279      using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
    280280        var query = from r in context.ClientLogs
    281281                    where r.Timestamp >= startDate
    … …  
    286286
    287287    public void AddClientLog(DT.ClientLog log) {
    288       using (DA.ClientManagementDataContext context = new DA.ClientManagementDataContext()) {
     288      using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
    289289        context.ClientLogs.InsertOnSubmit(Convert.ToEntity(log));
    290290        context.SubmitChanges();
    … …  
    295295      RoleVerifier.AuthenticateForAllRoles(AccessServiceRoles.Administrator);
    296296
    297       using (DA.ClientManagementDataContext context = new DA.ClientManagementDataContext()) {
     297      using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
    298298        context.ClientLogs.DeleteOnSubmit(Convert.ToEntity(log));
    299299        context.SubmitChanges();
    … …  
    325325
    326326      if (aspUser != null || aspMembership != null) {
    327         using (DA.ClientManagementDataContext context = new DA.ClientManagementDataContext()) {
     327        using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
    328328          var query = from u in context.UserGroupBases.OfType<DA.User>()
    329329                      where u.Id == userId
    … …  
    371371
    372372      if (aspUser != null) {
    373         using (DA.ClientManagementDataContext context = new DA.ClientManagementDataContext()) {
     373        using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
    374374          var query = from u in context.UserGroupBases.OfType<DA.User>()
    375375                      where u.Id == userId
    … …  
    408408      Guid userId = UserManager.CurrentUserId;
    409409
    410       using (DA.ClientManagementDataContext context = new DA.ClientManagementDataContext()) {
     410      using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
    411411        //TODO: this has to be done recursive, so check if a group is in another
    412412        //group because then the user is also in this group...
    … …  
    462462      List<Guid> accessUserGuids = null;
    463463
    464       using (DA.ClientManagementDataContext context = new DA.ClientManagementDataContext()) {
     464      using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
    465465        var query = from u in context.UserGroupBases.OfType<DA.User>()
    466466                    where ids.Contains(u.Id)
    … …  
    479479      List<Guid> accessUserGuids = null;
    480480
    481       using (DA.ClientManagementDataContext context = new DA.ClientManagementDataContext()) {
     481      using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
    482482        var query = from u in context.UserGroupBases.OfType<DA.User>()
    483483                    where ids.Contains(u.Id)
    … …  
    507507          accessUser.Id = aspMembership.UserId;
    508508        }
    509         using (DA.ClientManagementDataContext context = new DA.ClientManagementDataContext()) {
     509        using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
    510510          context.UserGroupBases.InsertOnSubmit(accessUser);
    511511          context.SubmitChanges();
    … …  
    527527        accessUser.Id = userId;
    528528
    529         using (DA.ClientManagementDataContext context = new DA.ClientManagementDataContext()) {
     529        using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
    530530          context.UserGroupBases.InsertOnSubmit(accessUser);
    531531          context.SubmitChanges();
    … …  
    546546        //delete asp.net user
    547547        Membership.DeleteUser(user.UserName);
    548         using (DA.ClientManagementDataContext context = new DA.ClientManagementDataContext()) {
     548        using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
    549549          var query = context.UserGroupBases.OfType<DA.User>().Where(x => x.Id == user.Id);
    550550          if (query.Count() > 0) {
    … …  
    611611    #region UserGroup
    612612    public IEnumerable<DT.UserGroup> GetAllUserGroups() {
    613       using (DA.ClientManagementDataContext context = new DA.ClientManagementDataContext()) {
     613      using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
    614614        var query = from u in context.UserGroupBases.OfType<DA.UserGroup>()
    615615                    select Convert.ToDto(u);
    … …  
    620620    public IEnumerable<DT.UserGroup> GetUserGroupsOfUser(Guid userId) {
    621621
    622       using (DA.ClientManagementDataContext context = new DA.ClientManagementDataContext()) {
     622      using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
    623623        var groupIds = from g in context.UserGroupUserGroups
    624624                       where g.UserGroupId == userId
    … …  
    634634
    635635    public IEnumerable<DT.UserGroup> GetUserGroups(IEnumerable<Guid> ids) {
    636       using (DA.ClientManagementDataContext context = new DA.ClientManagementDataContext()) {
     636      using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
    637637        var query = from u in context.UserGroupBases.OfType<DA.UserGroup>()
    638638                    where ids.Contains(u.Id)
    … …  
    643643
    644644    public Guid AddUserGroup(DT.UserGroup group) {
    645       using (DA.ClientManagementDataContext context = new DA.ClientManagementDataContext()) {
     645      using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
    646646        //because id is not automatically set because of user, we have to do it here manually for group
    647647        group.Id = Guid.NewGuid();
    … …  
    659659      RoleVerifier.AuthenticateForAllRoles(AccessServiceRoles.Administrator);
    660660
    661       using (DA.ClientManagementDataContext context = new DA.ClientManagementDataContext()) {
     661      using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
    662662        context.UserGroupBases.DeleteOnSubmit(Convert.ToEntity(group));
    663663        context.SubmitChanges();
    … …  
    666666
    667667    public void AddUserGroupBaseToGroup(DT.UserGroupBase resource, DT.UserGroup group) {
    668       using (DA.ClientManagementDataContext context = new DA.ClientManagementDataContext()) {
     668      using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
    669669        DA.UserGroupUserGroup ugug = new DA.UserGroupUserGroup();
    670670        ugug.UserGroupId = resource.Id;
    … …  
    676676
    677677    public void RemoveUserGroupBaseFromGroup(DT.UserGroupBase resource, DT.UserGroup userGroup) {
    678       using (DA.ClientManagementDataContext context = new DA.ClientManagementDataContext()) {
     678      using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
    679679        var query = from u in context.UserGroupUserGroups
    680680                    where u.UserGroupId == resource.Id && u.UserGroupUserGroupId == userGroup.Id
    … …  
    689689
    690690    public IEnumerable<DT.UserGroupBase> GetUsersAndGroups() {
    691       using (DA.ClientManagementDataContext context = new DA.ClientManagementDataContext()) {
     691      using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
    692692        var query = from u in context.UserGroupBases
    693693                    select Convert.ToDto(u);
    … …  
    697697
    698698    public IEnumerable<DT.UserGroupMapping> GetUserGroupMapping() {
    699       using (DA.ClientManagementDataContext context = new DA.ClientManagementDataContext()) {
     699      using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
    700700        var query = from u in context.UserGroupUserGroups
    701701                    select Convert.ToDto(u);
    … …  
    720720      var lightweightUsers = accessUserGuids.Select(x => BuildLightweightUserDto(x));
    721721
    722       using (DA.ClientManagementDataContext context = new DA.ClientManagementDataContext()) {
     722      using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
    723723        var query = from u in context.UserGroupBases.OfType<DA.UserGroup>()
    724724                    select Convert.ToDto(u);
    … …  
    736736      List<DT.UserGroupBase> result = new List<DT.UserGroupBase>();
    737737
    738       using (DA.ClientManagementDataContext context = new DA.ClientManagementDataContext()) {
     738      using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
    739739        var query = from u in context.UserGroupBases
    740740                    where ids.Contains(u.Id)
    … …  
    787787      string[] aspUsers;
    788788
    789       using (DA.ClientManagementDataContext accessContext = new DA.ClientManagementDataContext()) {
     789      using (DA.AccessServiceDataContext accessContext = new DA.AccessServiceDataContext()) {
    790790        userIds = (from u in accessContext.UserGroupUserGroups
    791791                   where u.UserGroupUserGroupId == userGroup.Id
    … …  
    809809      string[] aspUsers;
    810810
    811       using (DA.ClientManagementDataContext accessContext = new DA.ClientManagementDataContext()) {
     811      using (DA.AccessServiceDataContext accessContext = new DA.AccessServiceDataContext()) {
    812812        userIds = (from u in accessContext.UserGroupUserGroups
    813813                   where u.UserGroupUserGroupId == userGroup.Id
    … …  
    827827    #region Error Reporting
    828828    public void ReportError(DT.ClientError error) {
    829       using (DA.ClientManagementDataContext context = new DA.ClientManagementDataContext()) {
     829      using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
    830830        context.ClientErrors.InsertOnSubmit(Convert.ToEntity(error));
    831831        context.SubmitChanges();
    … …  
    836836      RoleVerifier.AuthenticateForAllRoles(AccessServiceRoles.Administrator);
    837837
    838       using (DA.ClientManagementDataContext context = new DA.ClientManagementDataContext()) {
     838      using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
    839839        var query = from c in context.ClientErrors
    840840                    select Convert.ToDto(c);
    … …  
    846846      RoleVerifier.AuthenticateForAllRoles(AccessServiceRoles.Administrator);
    847847
    848       using (DA.ClientManagementDataContext context = new DA.ClientManagementDataContext()) {
     848      using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
    849849        var query = from c in context.ClientErrors
    850850                    where c.Timestamp >= startDate
    … …  
    857857      RoleVerifier.AuthenticateForAllRoles(AccessServiceRoles.Administrator);
    858858
    859       using (DA.ClientManagementDataContext context = new DA.ClientManagementDataContext()) {
     859      using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) {
    860860        var query = context.ClientErrors.Where(x => x.Id == error.Id);
    861861        if (query.Count() > 0) {

  • branches/ClientUserManagement/HeuristicLab.Services.Access/3.3/HeuristicLab.Services.Access-3.3.csproj

    r7367 r7619  
    101101    </ProjectReference>
    102102  </ItemGroup>
     103  <ItemGroup>
     104    <Content Include="AccessService.svc" />
     105  </ItemGroup>
    103106  <Import Project="$(MSBuildBinPath)\Microsoft.CSharp.targets" />
    104107  <ProjectExtensions>
Note: See TracChangeset for help on using the changeset viewer.