Changeset 7619 for branches/ClientUserManagement
- Timestamp:
- 03/15/12 13:26:25 (12 years ago)
- 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 33 33 [TestMethod] 34 34 public void ClearDB() { 35 using (DA. ClientManagementDataContext context = new DA.ClientManagementDataContext()) {35 using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) { 36 36 context.ExecuteCommand("DELETE FROM dbo.ResourceResourceGroup"); 37 37 context.ExecuteCommand("DELETE FROM dbo.ClientLog"); -
branches/ClientUserManagement/HeuristicLab.Services.Access.DataAccess/3.3/HeuristicLab.Services.Access.DataAccess-3.3.csproj
r7367 r7619 53 53 <DependentUpon>ASPNETAuthentication.dbml</DependentUpon> 54 54 </Compile> 55 <Compile Include=" ClientManagement.designer.cs">56 <DependentUpon> ClientManagement.dbml</DependentUpon>55 <Compile Include="AccessService.designer.cs"> 56 <DependentUpon>AccessService.dbml</DependentUpon> 57 57 <DesignTime>True</DesignTime> 58 58 <AutoGen>True</AutoGen> … … 72 72 <SubType>Designer</SubType> 73 73 </None> 74 <None Include=" ClientManagement.dbml">74 <None Include="AccessService.dbml"> 75 75 <Generator>MSLinqToSQLGenerator</Generator> 76 <LastGenOutput> ClientManagement.designer.cs</LastGenOutput>76 <LastGenOutput>AccessService.designer.cs</LastGenOutput> 77 77 <SubType>Designer</SubType> 78 78 </None> … … 93 93 </ItemGroup> 94 94 <ItemGroup> 95 <None Include=" ClientManagement.dbml.layout">96 <DependentUpon> ClientManagement.dbml</DependentUpon>95 <None Include="AccessService.dbml.layout"> 96 <DependentUpon>AccessService.dbml</DependentUpon> 97 97 </None> 98 98 </ItemGroup> -
branches/ClientUserManagement/HeuristicLab.Services.Access.DataAccess/3.3/Properties/Settings.Designer.cs
r6815 r7619 2 2 // <auto-generated> 3 3 // This code was generated by a tool. 4 // Runtime Version:4.0.30319. 2374 // Runtime Version:4.0.30319.530 5 5 // 6 6 // Changes to this file may cause incorrect behavior and will be lost if … … 38 38 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 39 39 [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 "")] 42 42 public string HeuristicLab_ClientManagementConnectionString { 43 43 get { -
branches/ClientUserManagement/HeuristicLab.Services.Access.DataAccess/3.3/Properties/Settings.settings
r6815 r7619 14 14 <DesignTimeValue Profile="(Default)"><?xml version="1.0" encoding="utf-16"?> 15 15 <SerializableConnectionString xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> 16 <ConnectionString>Data Source=.;Initial Catalog=HeuristicLab. ClientManagement;Integrated Security=True</ConnectionString>16 <ConnectionString>Data Source=.;Initial Catalog=HeuristicLab.AccessService;Integrated Security=True</ConnectionString> 17 17 <ProviderName>System.Data.SqlClient</ProviderName> 18 18 </SerializableConnectionString></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> 20 20 </Setting> 21 21 </Settings> -
branches/ClientUserManagement/HeuristicLab.Services.Access.DataAccess/3.3/SQL Scripts/Create ClientManagement.sql
r6815 r7619 2 2 GO 3 3 4 /****** Object: Database [HeuristicLab. ClientManagement] Script Date: 09/19/2011 13:21:28 ******/5 CREATE DATABASE [HeuristicLab. ClientManagement] ON PRIMARY6 ( 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 ******/ 5 CREATE 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 ) 7 7 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%) 9 9 GO 10 10 11 ALTER DATABASE [HeuristicLab. ClientManagement] SET COMPATIBILITY_LEVEL = 10011 ALTER DATABASE [HeuristicLab.AccessService] SET COMPATIBILITY_LEVEL = 100 12 12 GO 13 13 14 14 IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')) 15 15 begin 16 EXEC [HeuristicLab. ClientManagement].[dbo].[sp_fulltext_database] @action = 'enable'16 EXEC [HeuristicLab.AccessService].[dbo].[sp_fulltext_database] @action = 'enable' 17 17 end 18 18 GO 19 19 20 ALTER DATABASE [HeuristicLab. ClientManagement] SET ANSI_NULL_DEFAULT OFF20 ALTER DATABASE [HeuristicLab.AccessService] SET ANSI_NULL_DEFAULT OFF 21 21 GO 22 22 23 ALTER DATABASE [HeuristicLab. ClientManagement] SET ANSI_NULLS OFF23 ALTER DATABASE [HeuristicLab.AccessService] SET ANSI_NULLS OFF 24 24 GO 25 25 26 ALTER DATABASE [HeuristicLab. ClientManagement] SET ANSI_PADDING OFF26 ALTER DATABASE [HeuristicLab.AccessService] SET ANSI_PADDING OFF 27 27 GO 28 28 29 ALTER DATABASE [HeuristicLab. ClientManagement] SET ANSI_WARNINGS OFF29 ALTER DATABASE [HeuristicLab.AccessService] SET ANSI_WARNINGS OFF 30 30 GO 31 31 32 ALTER DATABASE [HeuristicLab. ClientManagement] SET ARITHABORT OFF32 ALTER DATABASE [HeuristicLab.AccessService] SET ARITHABORT OFF 33 33 GO 34 34 35 ALTER DATABASE [HeuristicLab. ClientManagement] SET AUTO_CLOSE OFF35 ALTER DATABASE [HeuristicLab.AccessService] SET AUTO_CLOSE OFF 36 36 GO 37 37 38 ALTER DATABASE [HeuristicLab. ClientManagement] SET AUTO_CREATE_STATISTICS ON38 ALTER DATABASE [HeuristicLab.AccessService] SET AUTO_CREATE_STATISTICS ON 39 39 GO 40 40 41 ALTER DATABASE [HeuristicLab. ClientManagement] SET AUTO_SHRINK OFF41 ALTER DATABASE [HeuristicLab.AccessService] SET AUTO_SHRINK OFF 42 42 GO 43 43 44 ALTER DATABASE [HeuristicLab. ClientManagement] SET AUTO_UPDATE_STATISTICS ON44 ALTER DATABASE [HeuristicLab.AccessService] SET AUTO_UPDATE_STATISTICS ON 45 45 GO 46 46 47 ALTER DATABASE [HeuristicLab. ClientManagement] SET CURSOR_CLOSE_ON_COMMIT OFF47 ALTER DATABASE [HeuristicLab.AccessService] SET CURSOR_CLOSE_ON_COMMIT OFF 48 48 GO 49 49 50 ALTER DATABASE [HeuristicLab. ClientManagement] SET CURSOR_DEFAULT GLOBAL50 ALTER DATABASE [HeuristicLab.AccessService] SET CURSOR_DEFAULT GLOBAL 51 51 GO 52 52 53 ALTER DATABASE [HeuristicLab. ClientManagement] SET CONCAT_NULL_YIELDS_NULL OFF53 ALTER DATABASE [HeuristicLab.AccessService] SET CONCAT_NULL_YIELDS_NULL OFF 54 54 GO 55 55 56 ALTER DATABASE [HeuristicLab. ClientManagement] SET NUMERIC_ROUNDABORT OFF56 ALTER DATABASE [HeuristicLab.AccessService] SET NUMERIC_ROUNDABORT OFF 57 57 GO 58 58 59 ALTER DATABASE [HeuristicLab. ClientManagement] SET QUOTED_IDENTIFIER OFF59 ALTER DATABASE [HeuristicLab.AccessService] SET QUOTED_IDENTIFIER OFF 60 60 GO 61 61 62 ALTER DATABASE [HeuristicLab. ClientManagement] SET RECURSIVE_TRIGGERS OFF62 ALTER DATABASE [HeuristicLab.AccessService] SET RECURSIVE_TRIGGERS OFF 63 63 GO 64 64 65 ALTER DATABASE [HeuristicLab. ClientManagement] SET DISABLE_BROKER65 ALTER DATABASE [HeuristicLab.AccessService] SET DISABLE_BROKER 66 66 GO 67 67 68 ALTER DATABASE [HeuristicLab. ClientManagement] SET AUTO_UPDATE_STATISTICS_ASYNC OFF68 ALTER DATABASE [HeuristicLab.AccessService] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 69 69 GO 70 70 71 ALTER DATABASE [HeuristicLab. ClientManagement] SET DATE_CORRELATION_OPTIMIZATION OFF71 ALTER DATABASE [HeuristicLab.AccessService] SET DATE_CORRELATION_OPTIMIZATION OFF 72 72 GO 73 73 74 ALTER DATABASE [HeuristicLab. ClientManagement] SET TRUSTWORTHY OFF74 ALTER DATABASE [HeuristicLab.AccessService] SET TRUSTWORTHY OFF 75 75 GO 76 76 77 ALTER DATABASE [HeuristicLab. ClientManagement] SET ALLOW_SNAPSHOT_ISOLATION OFF77 ALTER DATABASE [HeuristicLab.AccessService] SET ALLOW_SNAPSHOT_ISOLATION OFF 78 78 GO 79 79 80 ALTER DATABASE [HeuristicLab. ClientManagement] SET PARAMETERIZATION SIMPLE80 ALTER DATABASE [HeuristicLab.AccessService] SET PARAMETERIZATION SIMPLE 81 81 GO 82 82 83 ALTER DATABASE [HeuristicLab. ClientManagement] SET READ_COMMITTED_SNAPSHOT OFF83 ALTER DATABASE [HeuristicLab.AccessService] SET READ_COMMITTED_SNAPSHOT OFF 84 84 GO 85 85 86 ALTER DATABASE [HeuristicLab. ClientManagement] SET HONOR_BROKER_PRIORITY OFF86 ALTER DATABASE [HeuristicLab.AccessService] SET HONOR_BROKER_PRIORITY OFF 87 87 GO 88 88 89 ALTER DATABASE [HeuristicLab. ClientManagement] SET READ_WRITE89 ALTER DATABASE [HeuristicLab.AccessService] SET READ_WRITE 90 90 GO 91 91 92 ALTER DATABASE [HeuristicLab. ClientManagement] SET RECOVERY FULL92 ALTER DATABASE [HeuristicLab.AccessService] SET RECOVERY FULL 93 93 GO 94 94 95 ALTER DATABASE [HeuristicLab. ClientManagement] SET MULTI_USER95 ALTER DATABASE [HeuristicLab.AccessService] SET MULTI_USER 96 96 GO 97 97 98 ALTER DATABASE [HeuristicLab. ClientManagement] SET PAGE_VERIFY CHECKSUM98 ALTER DATABASE [HeuristicLab.AccessService] SET PAGE_VERIFY CHECKSUM 99 99 GO 100 100 101 ALTER DATABASE [HeuristicLab. ClientManagement] SET DB_CHAINING OFF101 ALTER DATABASE [HeuristicLab.AccessService] SET DB_CHAINING OFF 102 102 GO 103 103 -
branches/ClientUserManagement/HeuristicLab.Services.Access.DataAccess/3.3/SQL Scripts/Create Initial Values.sql
r6852 r7619 1 USE [HeuristicLab. ClientManagement]1 USE [HeuristicLab.AccessService] 2 2 GO 3 3 4 4 /** Client Configuration **/ 5 INSERT INTO [HeuristicLab. ClientManagement].[dbo].[ClientConfiguration] (Hash, Description) VALUES ('','Custom Configuration');5 INSERT INTO [HeuristicLab.AccessService].[dbo].[ClientConfiguration] (Hash, Description) VALUES ('','Custom Configuration'); 6 6 7 7 /** 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');8 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('N/A'); 9 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Asia/Pacific Region'); 10 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Europe'); 11 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Andorra'); 12 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('United Arab Emirates'); 13 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Afghanistan'); 14 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Antigua and Barbuda'); 15 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Anguilla'); 16 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Albania'); 17 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Armenia'); 18 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Netherlands Antilles'); 19 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Angola'); 20 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Antarctica'); 21 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Argentina'); 22 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('American Samoa'); 23 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Austria'); 24 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Australia'); 25 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Aruba'); 26 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Azerbaijan'); 27 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Bosnia and Herzegovina'); 28 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Barbados'); 29 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Bangladesh'); 30 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Belgium'); 31 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Burkina Faso'); 32 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Bulgaria'); 33 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Bahrain'); 34 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Burundi'); 35 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Benin'); 36 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Bermuda'); 37 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Brunei Darussalam'); 38 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Bolivia'); 39 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Brazil'); 40 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Bahamas'); 41 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Bhutan'); 42 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Bouvet Island'); 43 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Botswana'); 44 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Belarus'); 45 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Belize'); 46 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Canada'); 47 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Cocos (Keeling) Islands'); 48 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Congo, The Democratic Republic of the'); 49 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Central African Republic'); 50 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Congo'); 51 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Switzerland'); 52 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Cote D''Ivoire'); 53 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Cook Islands'); 54 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Chile'); 55 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Cameroon'); 56 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('China'); 57 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Colombia'); 58 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Costa Rica'); 59 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Cuba'); 60 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Cape Verde'); 61 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Christmas Island'); 62 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Cyprus'); 63 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Czech Republic'); 64 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Germany'); 65 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Djibouti'); 66 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Denmark'); 67 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Dominica'); 68 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Dominican Republic'); 69 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Algeria'); 70 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Ecuador'); 71 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Estonia'); 72 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Egypt'); 73 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Western Sahara'); 74 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Eritrea'); 75 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Spain'); 76 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Ethiopia'); 77 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Finland'); 78 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Fiji'); 79 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Falkland Islands (Malvinas)'); 80 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Micronesia, Federated States of'); 81 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Faroe Islands'); 82 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('France'); 83 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('France, Metropolitan'); 84 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Gabon'); 85 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('United Kingdom'); 86 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Grenada'); 87 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Georgia'); 88 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('French Guiana'); 89 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Ghana'); 90 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Gibraltar'); 91 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Greenland'); 92 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Gambia'); 93 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Guinea'); 94 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Guadeloupe'); 95 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Equatorial Guinea'); 96 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Greece'); 97 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('South Georgia and the South Sandwich Islands'); 98 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Guatemala'); 99 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Guam'); 100 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Guinea-Bissau'); 101 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Guyana'); 102 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Hong Kong'); 103 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Heard Island and McDonald Islands'); 104 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Honduras'); 105 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Croatia'); 106 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Haiti'); 107 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Hungary'); 108 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Indonesia'); 109 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Ireland'); 110 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Israel'); 111 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('India'); 112 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('British Indian Ocean Territory'); 113 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Iraq'); 114 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Iran, Islamic Republic of'); 115 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Iceland'); 116 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Italy'); 117 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Jamaica'); 118 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Jordan'); 119 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Japan'); 120 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Kenya'); 121 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Kyrgyzstan'); 122 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Cambodia'); 123 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Kiribati'); 124 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Comoros'); 125 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Saint Kitts and Nevis'); 126 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Korea, Democratic People''s Republic of'); 127 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Korea, Republic of'); 128 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Kuwait'); 129 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Cayman Islands'); 130 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Kazakhstan'); 131 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Lao People''s Democratic Republic'); 132 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Lebanon'); 133 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Saint Lucia'); 134 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Liechtenstein'); 135 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Sri Lanka'); 136 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Liberia'); 137 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Lesotho'); 138 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Lithuania'); 139 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Luxembourg'); 140 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Latvia'); 141 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Libyan Arab Jamahiriya'); 142 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Morocco'); 143 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Monaco'); 144 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Moldova, Republic of'); 145 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Madagascar'); 146 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Marshall Islands'); 147 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Macedonia, the Former Yugoslav Republic of'); 148 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Mali'); 149 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Myanmar'); 150 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Mongolia'); 151 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Macau'); 152 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Northern Mariana Islands'); 153 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Martinique'); 154 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Mauritania'); 155 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Montserrat'); 156 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Malta'); 157 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Mauritius'); 158 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Maldives'); 159 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Malawi'); 160 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Mexico'); 161 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Malaysia'); 162 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Mozambique'); 163 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Namibia'); 164 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('New Caledonia'); 165 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Niger'); 166 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Norfolk Island'); 167 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Nigeria'); 168 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Nicaragua'); 169 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Netherlands'); 170 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Norway'); 171 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Nepal'); 172 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Nauru'); 173 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Niue'); 174 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('New Zealand'); 175 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Oman'); 176 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Panama'); 177 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Peru'); 178 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('French Polynesia'); 179 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Papua New Guinea'); 180 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Philippines'); 181 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Pakistan'); 182 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Poland'); 183 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Saint Pierre and Miquelon'); 184 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Pitcairn'); 185 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Puerto Rico'); 186 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Palestinian Territory, Occupied'); 187 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Portugal'); 188 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Palau'); 189 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Paraguay'); 190 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Qatar'); 191 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Reunion'); 192 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Romania'); 193 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Russian Federation'); 194 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Rwanda'); 195 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Saudi Arabia'); 196 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Solomon Islands'); 197 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Seychelles'); 198 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Sudan'); 199 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Sweden'); 200 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Singapore'); 201 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Saint Helena'); 202 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Slovenia'); 203 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Svalbard and Jan Mayen'); 204 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Slovakia'); 205 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Sierra Leone'); 206 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('San Marino'); 207 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Senegal'); 208 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Somalia'); 209 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Suriname'); 210 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Sao Tome and Principe'); 211 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('El Salvador'); 212 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Syrian Arab Republic'); 213 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Swaziland'); 214 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Turks and Caicos Islands'); 215 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Chad'); 216 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('French Southern Territories'); 217 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Togo'); 218 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Thailand'); 219 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Tajikistan'); 220 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Tokelau'); 221 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Turkmenistan'); 222 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Tunisia'); 223 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Tonga'); 224 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Timor-Leste'); 225 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Turkey'); 226 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Trinidad and Tobago'); 227 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Tuvalu'); 228 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Taiwan'); 229 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Tanzania, United Republic of'); 230 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Ukraine'); 231 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Uganda'); 232 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('United States Minor Outlying Islands'); 233 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('United States'); 234 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Uruguay'); 235 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Uzbekistan'); 236 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Holy See (Vatican City State)'); 237 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Saint Vincent and the Grenadines'); 238 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Venezuela'); 239 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Virgin Islands, British'); 240 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Virgin Islands, U.S.'); 241 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Vietnam'); 242 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Vanuatu'); 243 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Wallis and Futuna'); 244 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Samoa'); 245 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Yemen'); 246 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Mayotte'); 247 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Serbia'); 248 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('South Africa'); 249 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Zambia'); 250 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Montenegro'); 251 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Zimbabwe'); 252 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Anonymous Proxy'); 253 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Satellite Provider'); 254 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Other'); 255 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Aland Islands'); 256 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Guernsey'); 257 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Isle of Man'); 258 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Jersey'); 259 INSERT INTO [HeuristicLab.AccessService].[dbo].[Country] (Name) VALUES ('Saint Barthelemy'); 260 INSERT 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]1 USE [HeuristicLab.AccessService] 2 2 GO 3 3 … … 24 24 GO 25 25 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] 26 USE [HeuristicLab.AccessService] 101 27 GO 102 28 … … 122 48 GO 123 49 124 USE [HeuristicLab. ClientManagement]50 USE [HeuristicLab.AccessService] 125 51 GO 126 52 … … 146 72 GO 147 73 148 USE [HeuristicLab. ClientManagement]74 USE [HeuristicLab.AccessService] 149 75 GO 150 76 … … 170 96 GO 171 97 172 USE [HeuristicLab. ClientManagement]98 USE [HeuristicLab.AccessService] 173 99 GO 174 100 … … 196 122 GO 197 123 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] 124 USE [HeuristicLab.AccessService] 273 125 GO 274 126 … … 334 186 GO 335 187 336 USE [HeuristicLab.ClientManagement] 188 USE [HeuristicLab.AccessService] 189 GO 190 191 /****** Object: Table [dbo].[ResourceResourceGroup] Script Date: 09/27/2011 17:07:08 ******/ 192 SET ANSI_NULLS ON 193 GO 194 195 SET QUOTED_IDENTIFIER ON 196 GO 197 198 CREATE 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 208 GO 209 210 ALTER TABLE [dbo].[ResourceResourceGroup] WITH CHECK ADD CONSTRAINT [FK_ResourceResourceGroup_ResourceGroupId] FOREIGN KEY([ResourceGroupId]) 211 REFERENCES [dbo].[Resource] ([Id]) 212 GO 213 214 ALTER TABLE [dbo].[ResourceResourceGroup] CHECK CONSTRAINT [FK_ResourceResourceGroup_ResourceGroupId] 215 GO 216 217 ALTER TABLE [dbo].[ResourceResourceGroup] WITH CHECK ADD CONSTRAINT [FK_ResourceResourceGroup_ResourceId] FOREIGN KEY([ResourceId]) 218 REFERENCES [dbo].[Resource] ([Id]) 219 GO 220 221 ALTER TABLE [dbo].[ResourceResourceGroup] CHECK CONSTRAINT [FK_ResourceResourceGroup_ResourceId] 222 GO 223 224 USE [HeuristicLab.AccessService] 225 GO 226 227 /****** Object: Table [dbo].[ResourcePlugin] Script Date: 09/27/2011 17:07:01 ******/ 228 SET ANSI_NULLS ON 229 GO 230 231 SET QUOTED_IDENTIFIER ON 232 GO 233 234 CREATE 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 244 GO 245 246 ALTER TABLE [dbo].[ResourcePlugin] WITH CHECK ADD CONSTRAINT [FK_ResourcePlugin_Plugin] FOREIGN KEY([PluginId]) 247 REFERENCES [dbo].[Plugin] ([Id]) 248 GO 249 250 ALTER TABLE [dbo].[ResourcePlugin] CHECK CONSTRAINT [FK_ResourcePlugin_Plugin] 251 GO 252 253 ALTER TABLE [dbo].[ResourcePlugin] WITH CHECK ADD CONSTRAINT [FK_ResourcePlugin_Resource] FOREIGN KEY([ResourceId]) 254 REFERENCES [dbo].[Resource] ([Id]) 255 GO 256 257 ALTER TABLE [dbo].[ResourcePlugin] CHECK CONSTRAINT [FK_ResourcePlugin_Resource] 258 GO 259 260 USE [HeuristicLab.AccessService] 337 261 GO 338 262 … … 357 281 GO 358 282 359 USE [HeuristicLab. ClientManagement]283 USE [HeuristicLab.AccessService] 360 284 GO 361 285 … … 394 318 395 319 396 397 398 399 400 401 402 403 320 USE [HeuristicLab.AccessService] 321 GO 322 323 /****** Object: Table [dbo].[ClientError] Script Date: 09/27/2011 17:05:38 ******/ 324 SET ANSI_NULLS ON 325 GO 326 327 SET QUOTED_IDENTIFIER ON 328 GO 329 330 CREATE 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 344 GO 345 346 ALTER TABLE [dbo].[ClientError] WITH CHECK ADD CONSTRAINT [FK_ClientError_Resource] FOREIGN KEY([ClientId]) 347 REFERENCES [dbo].[Resource] ([Id]) 348 GO 349 350 ALTER TABLE [dbo].[ClientError] CHECK CONSTRAINT [FK_ClientError_Resource] 351 GO 352 353 ALTER TABLE [dbo].[ClientError] WITH CHECK ADD CONSTRAINT [FK_ClientError_UserGroup] FOREIGN KEY([UserId]) 354 REFERENCES [dbo].[UserGroup] ([Id]) 355 GO 356 357 ALTER TABLE [dbo].[ClientError] CHECK CONSTRAINT [FK_ClientError_UserGroup] 358 GO 359 360 ALTER TABLE [dbo].[ClientError] ADD CONSTRAINT [DF_ClientError_Id] DEFAULT (newsequentialid()) FOR [Id] 361 GO 362 363 USE [HeuristicLab.AccessService] 364 GO 365 366 /****** Object: Table [dbo].[ClientLog] Script Date: 09/27/2011 17:05:50 ******/ 367 SET ANSI_NULLS ON 368 GO 369 370 SET QUOTED_IDENTIFIER ON 371 GO 372 373 CREATE 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 384 GO 385 386 ALTER TABLE [dbo].[ClientLog] WITH CHECK ADD CONSTRAINT [FK_ClientLog_Resource] FOREIGN KEY([ResourceId]) 387 REFERENCES [dbo].[Resource] ([Id]) 388 GO 389 390 ALTER TABLE [dbo].[ClientLog] CHECK CONSTRAINT [FK_ClientLog_Resource] 391 GO 392 393 394 395 396 397 -
branches/ClientUserManagement/HeuristicLab.Services.Access.DataAccess/3.3/app.config
r6815 r7619 6 6 <add name="HeuristicLab.Services.Directoy.DataAccess.Properties.Settings.HeuristicLab_AuthenticationConnectionString" 7 7 connectionString="Data Source=.;Initial Catalog=HeuristicLab.Authentication;Integrated Security=True" 8 providerName="System.Data.SqlClient" /> 8 providerName="System.Data.SqlClient" /> 9 9 <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" 11 14 providerName="System.Data.SqlClient" /> 12 15 </connectionStrings> -
branches/ClientUserManagement/HeuristicLab.Services.Access/3.3/AccessService.cs
r7614 r7619 52 52 public bool ClientExists(Guid id) { 53 53 if (id != Guid.Empty) { 54 using (DA. ClientManagementDataContext context = new DA.ClientManagementDataContext()) {54 using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) { 55 55 return (context.Resources.Where(x => x.Id == id).Count() != 0); 56 56 } … … 60 60 61 61 public DT.Client GetClient(Guid id) { 62 using (DA. ClientManagementDataContext context = new DA.ClientManagementDataContext()) {62 using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) { 63 63 var query = from c in context.GetTable<DA.Resource>().OfType<DA.Client>() 64 64 where c.Id == id … … 73 73 74 74 public IEnumerable<DT.Client> GetClients(IEnumerable<Guid> ids) { 75 using (DA. ClientManagementDataContext context = new DA.ClientManagementDataContext()) {75 using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) { 76 76 var query = from c in context.GetTable<DA.Resource>().OfType<DA.Client>() 77 77 where ids.Contains(c.Id) … … 82 82 83 83 public IEnumerable<DT.Client> GetAllClients() { 84 using (DA. ClientManagementDataContext context = new DA.ClientManagementDataContext()) {84 using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) { 85 85 var query = from c in context.GetTable<DA.Resource>().OfType<DA.Client>() 86 86 select Convert.ToDto(c); … … 101 101 } 102 102 103 using (DA. ClientManagementDataContext context = new DA.ClientManagementDataContext()) {103 using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) { 104 104 DA.Client entity = Convert.ToEntity(client); 105 105 … … 145 145 RoleVerifier.AuthenticateForAllRoles(AccessServiceRoles.Administrator); 146 146 147 using (DA. ClientManagementDataContext context = new DA.ClientManagementDataContext()) {147 using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) { 148 148 //load client because we could get a detached object 149 149 var query = from c in context.GetTable<DA.Resource>().OfType<DA.Client>() … … 167 167 #region ClientGroup 168 168 public IEnumerable<DT.ClientGroup> GetAllClientGroups() { 169 using (DA. ClientManagementDataContext context = new DA.ClientManagementDataContext()) {169 using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) { 170 170 var query = from c in context.GetTable<DA.Resource>().OfType<DA.ClientGroup>() 171 171 select Convert.ToDto(c); … … 175 175 176 176 public IEnumerable<DT.ClientGroup> GetClientGroups(IEnumerable<Guid> ids) { 177 using (DA. ClientManagementDataContext context = new DA.ClientManagementDataContext()) {177 using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) { 178 178 var query = from c in context.GetTable<DA.Resource>().OfType<DA.ClientGroup>() 179 179 where ids.Contains(c.Id) … … 184 184 185 185 public Guid AddClientGroup(DT.ClientGroup group) { 186 using (DA. ClientManagementDataContext context = new DA.ClientManagementDataContext()) {186 using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) { 187 187 if (group.Id == Guid.Empty) 188 188 group.Id = Guid.NewGuid(); … … 202 202 RoleVerifier.AuthenticateForAllRoles(AccessServiceRoles.Administrator); 203 203 204 using (DA. ClientManagementDataContext context = new DA.ClientManagementDataContext()) {204 using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) { 205 205 //load clientGroup because we could get a detached object 206 206 var query = from c in context.GetTable<DA.Resource>().OfType<DA.ClientGroup>() … … 215 215 216 216 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()) { 218 218 DA.ResourceResourceGroup rrg = new DA.ResourceResourceGroup() { 219 219 ResourceId = resource.Id, … … 227 227 228 228 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()) { 230 230 var query = context.ResourceResourceGroups.Where(x => x.ResourceId == resource.Id && x.ResourceGroupId == group.Id); 231 231 if (query.Count() > 0) { … … 239 239 #region ClientGroupMapping 240 240 public IEnumerable<DT.ClientGroupMapping> GetClientGroupMapping() { 241 using (DA. ClientManagementDataContext context = new DA.ClientManagementDataContext()) {241 using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) { 242 242 var query = from c in context.GetTable<DA.ResourceResourceGroup>() 243 243 select Convert.ToDto(c); … … 249 249 #region Resource 250 250 public IEnumerable<DT.Resource> GetResources() { 251 using (DA. ClientManagementDataContext context = new DA.ClientManagementDataContext()) {251 using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) { 252 252 var query = from r in context.Resources 253 253 select Convert.ToDto(r); … … 259 259 #region ClientLog 260 260 public DT.ClientLog GetLastClientLog(Guid clientId) { 261 using (DA. ClientManagementDataContext context = new DA.ClientManagementDataContext()) {261 using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) { 262 262 var query = from r in context.ClientLogs 263 263 where r.ResourceId == clientId … … 268 268 269 269 public IEnumerable<DT.ClientLog> GetClientLogs(Guid clientId) { 270 using (DA. ClientManagementDataContext context = new DA.ClientManagementDataContext()) {270 using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) { 271 271 var query = from r in context.ClientLogs 272 272 where r.ResourceId == clientId … … 277 277 278 278 public IEnumerable<DT.ClientLog> GetClientLogsSince(DateTime startDate) { 279 using (DA. ClientManagementDataContext context = new DA.ClientManagementDataContext()) {279 using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) { 280 280 var query = from r in context.ClientLogs 281 281 where r.Timestamp >= startDate … … 286 286 287 287 public void AddClientLog(DT.ClientLog log) { 288 using (DA. ClientManagementDataContext context = new DA.ClientManagementDataContext()) {288 using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) { 289 289 context.ClientLogs.InsertOnSubmit(Convert.ToEntity(log)); 290 290 context.SubmitChanges(); … … 295 295 RoleVerifier.AuthenticateForAllRoles(AccessServiceRoles.Administrator); 296 296 297 using (DA. ClientManagementDataContext context = new DA.ClientManagementDataContext()) {297 using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) { 298 298 context.ClientLogs.DeleteOnSubmit(Convert.ToEntity(log)); 299 299 context.SubmitChanges(); … … 325 325 326 326 if (aspUser != null || aspMembership != null) { 327 using (DA. ClientManagementDataContext context = new DA.ClientManagementDataContext()) {327 using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) { 328 328 var query = from u in context.UserGroupBases.OfType<DA.User>() 329 329 where u.Id == userId … … 371 371 372 372 if (aspUser != null) { 373 using (DA. ClientManagementDataContext context = new DA.ClientManagementDataContext()) {373 using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) { 374 374 var query = from u in context.UserGroupBases.OfType<DA.User>() 375 375 where u.Id == userId … … 408 408 Guid userId = UserManager.CurrentUserId; 409 409 410 using (DA. ClientManagementDataContext context = new DA.ClientManagementDataContext()) {410 using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) { 411 411 //TODO: this has to be done recursive, so check if a group is in another 412 412 //group because then the user is also in this group... … … 462 462 List<Guid> accessUserGuids = null; 463 463 464 using (DA. ClientManagementDataContext context = new DA.ClientManagementDataContext()) {464 using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) { 465 465 var query = from u in context.UserGroupBases.OfType<DA.User>() 466 466 where ids.Contains(u.Id) … … 479 479 List<Guid> accessUserGuids = null; 480 480 481 using (DA. ClientManagementDataContext context = new DA.ClientManagementDataContext()) {481 using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) { 482 482 var query = from u in context.UserGroupBases.OfType<DA.User>() 483 483 where ids.Contains(u.Id) … … 507 507 accessUser.Id = aspMembership.UserId; 508 508 } 509 using (DA. ClientManagementDataContext context = new DA.ClientManagementDataContext()) {509 using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) { 510 510 context.UserGroupBases.InsertOnSubmit(accessUser); 511 511 context.SubmitChanges(); … … 527 527 accessUser.Id = userId; 528 528 529 using (DA. ClientManagementDataContext context = new DA.ClientManagementDataContext()) {529 using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) { 530 530 context.UserGroupBases.InsertOnSubmit(accessUser); 531 531 context.SubmitChanges(); … … 546 546 //delete asp.net user 547 547 Membership.DeleteUser(user.UserName); 548 using (DA. ClientManagementDataContext context = new DA.ClientManagementDataContext()) {548 using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) { 549 549 var query = context.UserGroupBases.OfType<DA.User>().Where(x => x.Id == user.Id); 550 550 if (query.Count() > 0) { … … 611 611 #region UserGroup 612 612 public IEnumerable<DT.UserGroup> GetAllUserGroups() { 613 using (DA. ClientManagementDataContext context = new DA.ClientManagementDataContext()) {613 using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) { 614 614 var query = from u in context.UserGroupBases.OfType<DA.UserGroup>() 615 615 select Convert.ToDto(u); … … 620 620 public IEnumerable<DT.UserGroup> GetUserGroupsOfUser(Guid userId) { 621 621 622 using (DA. ClientManagementDataContext context = new DA.ClientManagementDataContext()) {622 using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) { 623 623 var groupIds = from g in context.UserGroupUserGroups 624 624 where g.UserGroupId == userId … … 634 634 635 635 public IEnumerable<DT.UserGroup> GetUserGroups(IEnumerable<Guid> ids) { 636 using (DA. ClientManagementDataContext context = new DA.ClientManagementDataContext()) {636 using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) { 637 637 var query = from u in context.UserGroupBases.OfType<DA.UserGroup>() 638 638 where ids.Contains(u.Id) … … 643 643 644 644 public Guid AddUserGroup(DT.UserGroup group) { 645 using (DA. ClientManagementDataContext context = new DA.ClientManagementDataContext()) {645 using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) { 646 646 //because id is not automatically set because of user, we have to do it here manually for group 647 647 group.Id = Guid.NewGuid(); … … 659 659 RoleVerifier.AuthenticateForAllRoles(AccessServiceRoles.Administrator); 660 660 661 using (DA. ClientManagementDataContext context = new DA.ClientManagementDataContext()) {661 using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) { 662 662 context.UserGroupBases.DeleteOnSubmit(Convert.ToEntity(group)); 663 663 context.SubmitChanges(); … … 666 666 667 667 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()) { 669 669 DA.UserGroupUserGroup ugug = new DA.UserGroupUserGroup(); 670 670 ugug.UserGroupId = resource.Id; … … 676 676 677 677 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()) { 679 679 var query = from u in context.UserGroupUserGroups 680 680 where u.UserGroupId == resource.Id && u.UserGroupUserGroupId == userGroup.Id … … 689 689 690 690 public IEnumerable<DT.UserGroupBase> GetUsersAndGroups() { 691 using (DA. ClientManagementDataContext context = new DA.ClientManagementDataContext()) {691 using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) { 692 692 var query = from u in context.UserGroupBases 693 693 select Convert.ToDto(u); … … 697 697 698 698 public IEnumerable<DT.UserGroupMapping> GetUserGroupMapping() { 699 using (DA. ClientManagementDataContext context = new DA.ClientManagementDataContext()) {699 using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) { 700 700 var query = from u in context.UserGroupUserGroups 701 701 select Convert.ToDto(u); … … 720 720 var lightweightUsers = accessUserGuids.Select(x => BuildLightweightUserDto(x)); 721 721 722 using (DA. ClientManagementDataContext context = new DA.ClientManagementDataContext()) {722 using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) { 723 723 var query = from u in context.UserGroupBases.OfType<DA.UserGroup>() 724 724 select Convert.ToDto(u); … … 736 736 List<DT.UserGroupBase> result = new List<DT.UserGroupBase>(); 737 737 738 using (DA. ClientManagementDataContext context = new DA.ClientManagementDataContext()) {738 using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) { 739 739 var query = from u in context.UserGroupBases 740 740 where ids.Contains(u.Id) … … 787 787 string[] aspUsers; 788 788 789 using (DA. ClientManagementDataContext accessContext = new DA.ClientManagementDataContext()) {789 using (DA.AccessServiceDataContext accessContext = new DA.AccessServiceDataContext()) { 790 790 userIds = (from u in accessContext.UserGroupUserGroups 791 791 where u.UserGroupUserGroupId == userGroup.Id … … 809 809 string[] aspUsers; 810 810 811 using (DA. ClientManagementDataContext accessContext = new DA.ClientManagementDataContext()) {811 using (DA.AccessServiceDataContext accessContext = new DA.AccessServiceDataContext()) { 812 812 userIds = (from u in accessContext.UserGroupUserGroups 813 813 where u.UserGroupUserGroupId == userGroup.Id … … 827 827 #region Error Reporting 828 828 public void ReportError(DT.ClientError error) { 829 using (DA. ClientManagementDataContext context = new DA.ClientManagementDataContext()) {829 using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) { 830 830 context.ClientErrors.InsertOnSubmit(Convert.ToEntity(error)); 831 831 context.SubmitChanges(); … … 836 836 RoleVerifier.AuthenticateForAllRoles(AccessServiceRoles.Administrator); 837 837 838 using (DA. ClientManagementDataContext context = new DA.ClientManagementDataContext()) {838 using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) { 839 839 var query = from c in context.ClientErrors 840 840 select Convert.ToDto(c); … … 846 846 RoleVerifier.AuthenticateForAllRoles(AccessServiceRoles.Administrator); 847 847 848 using (DA. ClientManagementDataContext context = new DA.ClientManagementDataContext()) {848 using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) { 849 849 var query = from c in context.ClientErrors 850 850 where c.Timestamp >= startDate … … 857 857 RoleVerifier.AuthenticateForAllRoles(AccessServiceRoles.Administrator); 858 858 859 using (DA. ClientManagementDataContext context = new DA.ClientManagementDataContext()) {859 using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) { 860 860 var query = context.ClientErrors.Where(x => x.Id == error.Id); 861 861 if (query.Count() > 0) { -
branches/ClientUserManagement/HeuristicLab.Services.Access/3.3/HeuristicLab.Services.Access-3.3.csproj
r7367 r7619 101 101 </ProjectReference> 102 102 </ItemGroup> 103 <ItemGroup> 104 <Content Include="AccessService.svc" /> 105 </ItemGroup> 103 106 <Import Project="$(MSBuildBinPath)\Microsoft.CSharp.targets" /> 104 107 <ProjectExtensions>
Note: See TracChangeset
for help on using the changeset viewer.