Context Navigation

source: trunk/sources/HeuristicLab.Hive.Server.ADODataAccess/3.2/dsHiveServer.xsd @ 1601

Visit:

Last change on this file since 1601 was 1601, checked in by svonolfe, 16 years ago
Fixed maxLen problem with strings (#372)
File size: 153.4 KB

Line
1	<?xml version="1.0" encoding="utf-8"?>
2	<xs:schema id="dsHiveServer" targetNamespace="http://tempuri.org/dsHiveServer.xsd" xmlns:mstns="http://tempuri.org/dsHiveServer.xsd" xmlns="http://tempuri.org/dsHiveServer.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
3	<xs:annotation>
4	<xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
5	<DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
6	<Connections>
7	<Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="HiveServerConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="HiveServerConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.HeuristicLab.Hive.Server.ADODataAccess.Properties.Settings.GlobalReference.Default.HiveServerConnectionString" Provider="System.Data.SqlClient" />
8	</Connections>
9	<Tables>
10	<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ClientTableAdapter" GeneratorDataComponentClassName="ClientTableAdapter" Name="Client" UserDataComponentName="ClientTableAdapter">
11	<MainSource>
12	<DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="[HeuristicLab.Hive_DBTesting].dbo.Client" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
13	<DeleteCommand>
14	<DbCommand CommandType="Text" ModifiedByUser="false">
15	<CommandText>DELETE FROM [dbo].[Client] WHERE (([ResourceId] = @Original_ResourceId) AND ((@IsNull_CPUSpeed = 1 AND [CPUSpeed] IS NULL) OR ([CPUSpeed] = @Original_CPUSpeed)) AND ((@IsNull_Memory = 1 AND [Memory] IS NULL) OR ([Memory] = @Original_Memory)) AND ((@IsNull_Login = 1 AND [Login] IS NULL) OR ([Login] = @Original_Login)) AND ((@IsNull_Status = 1 AND [Status] IS NULL) OR ([Status] = @Original_Status)) AND ((@IsNull_ClientConfigId = 1 AND [ClientConfigId] IS NULL) OR ([ClientConfigId] = @Original_ClientConfigId)) AND ((@IsNull_NumberOfCores = 1 AND [NumberOfCores] IS NULL) OR ([NumberOfCores] = @Original_NumberOfCores)) AND ((@IsNull_NumberOfFreeCores = 1 AND [NumberOfFreeCores] IS NULL) OR ([NumberOfFreeCores] = @Original_NumberOfFreeCores)) AND ((@IsNull_FreeMemory = 1 AND [FreeMemory] IS NULL) OR ([FreeMemory] = @Original_FreeMemory)))</CommandText>
16	<Parameters>
17	<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ResourceId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ResourceId" SourceColumnNullMapping="false" SourceVersion="Original" />
18	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CPUSpeed" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CPUSpeed" SourceColumnNullMapping="true" SourceVersion="Original" />
19	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CPUSpeed" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CPUSpeed" SourceColumnNullMapping="false" SourceVersion="Original" />
20	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Memory" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Memory" SourceColumnNullMapping="true" SourceVersion="Original" />
21	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Memory" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Memory" SourceColumnNullMapping="false" SourceVersion="Original" />
22	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Login" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="true" SourceVersion="Original" />
23	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Login" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="false" SourceVersion="Original" />
24	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Status" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="true" SourceVersion="Original" />
25	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Original" />
26	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ClientConfigId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ClientConfigId" SourceColumnNullMapping="true" SourceVersion="Original" />
27	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ClientConfigId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ClientConfigId" SourceColumnNullMapping="false" SourceVersion="Original" />
28	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NumberOfCores" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumberOfCores" SourceColumnNullMapping="true" SourceVersion="Original" />
29	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_NumberOfCores" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumberOfCores" SourceColumnNullMapping="false" SourceVersion="Original" />
30	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NumberOfFreeCores" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumberOfFreeCores" SourceColumnNullMapping="true" SourceVersion="Original" />
31	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_NumberOfFreeCores" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumberOfFreeCores" SourceColumnNullMapping="false" SourceVersion="Original" />
32	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FreeMemory" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FreeMemory" SourceColumnNullMapping="true" SourceVersion="Original" />
33	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FreeMemory" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FreeMemory" SourceColumnNullMapping="false" SourceVersion="Original" />
34	</Parameters>
35	</DbCommand>
36	</DeleteCommand>
37	<InsertCommand>
38	<DbCommand CommandType="Text" ModifiedByUser="false">
39	<CommandText>INSERT INTO [dbo].[Client] ([ResourceId], [CPUSpeed], [Memory], [Login], [Status], [ClientConfigId], [NumberOfCores], [NumberOfFreeCores], [FreeMemory]) VALUES (@ResourceId, @CPUSpeed, @Memory, @Login, @Status, @ClientConfigId, @NumberOfCores, @NumberOfFreeCores, @FreeMemory);
40	SELECT ResourceId, CPUSpeed, Memory, Login, Status, ClientConfigId, NumberOfCores, NumberOfFreeCores, FreeMemory FROM Client WHERE (ResourceId = @ResourceId)</CommandText>
41	<Parameters>
42	<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ResourceId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ResourceId" SourceColumnNullMapping="false" SourceVersion="Current" />
43	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CPUSpeed" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CPUSpeed" SourceColumnNullMapping="false" SourceVersion="Current" />
44	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Memory" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Memory" SourceColumnNullMapping="false" SourceVersion="Current" />
45	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Login" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="false" SourceVersion="Current" />
46	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Current" />
47	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ClientConfigId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ClientConfigId" SourceColumnNullMapping="false" SourceVersion="Current" />
48	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumberOfCores" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumberOfCores" SourceColumnNullMapping="false" SourceVersion="Current" />
49	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumberOfFreeCores" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumberOfFreeCores" SourceColumnNullMapping="false" SourceVersion="Current" />
50	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FreeMemory" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FreeMemory" SourceColumnNullMapping="false" SourceVersion="Current" />
51	</Parameters>
52	</DbCommand>
53	</InsertCommand>
54	<SelectCommand>
55	<DbCommand CommandType="Text" ModifiedByUser="true">
56	<CommandText>SELECT * FROM dbo.Client</CommandText>
57	<Parameters />
58	</DbCommand>
59	</SelectCommand>
60	<UpdateCommand>
61	<DbCommand CommandType="Text" ModifiedByUser="false">
62	<CommandText>UPDATE [dbo].[Client] SET [ResourceId] = @ResourceId, [CPUSpeed] = @CPUSpeed, [Memory] = @Memory, [Login] = @Login, [Status] = @Status, [ClientConfigId] = @ClientConfigId, [NumberOfCores] = @NumberOfCores, [NumberOfFreeCores] = @NumberOfFreeCores, [FreeMemory] = @FreeMemory WHERE (([ResourceId] = @Original_ResourceId) AND ((@IsNull_CPUSpeed = 1 AND [CPUSpeed] IS NULL) OR ([CPUSpeed] = @Original_CPUSpeed)) AND ((@IsNull_Memory = 1 AND [Memory] IS NULL) OR ([Memory] = @Original_Memory)) AND ((@IsNull_Login = 1 AND [Login] IS NULL) OR ([Login] = @Original_Login)) AND ((@IsNull_Status = 1 AND [Status] IS NULL) OR ([Status] = @Original_Status)) AND ((@IsNull_ClientConfigId = 1 AND [ClientConfigId] IS NULL) OR ([ClientConfigId] = @Original_ClientConfigId)) AND ((@IsNull_NumberOfCores = 1 AND [NumberOfCores] IS NULL) OR ([NumberOfCores] = @Original_NumberOfCores)) AND ((@IsNull_NumberOfFreeCores = 1 AND [NumberOfFreeCores] IS NULL) OR ([NumberOfFreeCores] = @Original_NumberOfFreeCores)) AND ((@IsNull_FreeMemory = 1 AND [FreeMemory] IS NULL) OR ([FreeMemory] = @Original_FreeMemory)));
63	SELECT ResourceId, CPUSpeed, Memory, Login, Status, ClientConfigId, NumberOfCores, NumberOfFreeCores, FreeMemory FROM Client WHERE (ResourceId = @ResourceId)</CommandText>
64	<Parameters>
65	<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ResourceId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ResourceId" SourceColumnNullMapping="false" SourceVersion="Current" />
66	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CPUSpeed" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CPUSpeed" SourceColumnNullMapping="false" SourceVersion="Current" />
67	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Memory" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Memory" SourceColumnNullMapping="false" SourceVersion="Current" />
68	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Login" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="false" SourceVersion="Current" />
69	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Current" />
70	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ClientConfigId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ClientConfigId" SourceColumnNullMapping="false" SourceVersion="Current" />
71	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumberOfCores" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumberOfCores" SourceColumnNullMapping="false" SourceVersion="Current" />
72	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumberOfFreeCores" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumberOfFreeCores" SourceColumnNullMapping="false" SourceVersion="Current" />
73	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FreeMemory" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FreeMemory" SourceColumnNullMapping="false" SourceVersion="Current" />
74	<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ResourceId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ResourceId" SourceColumnNullMapping="false" SourceVersion="Original" />
75	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CPUSpeed" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CPUSpeed" SourceColumnNullMapping="true" SourceVersion="Original" />
76	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CPUSpeed" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CPUSpeed" SourceColumnNullMapping="false" SourceVersion="Original" />
77	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Memory" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Memory" SourceColumnNullMapping="true" SourceVersion="Original" />
78	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Memory" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Memory" SourceColumnNullMapping="false" SourceVersion="Original" />
79	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Login" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="true" SourceVersion="Original" />
80	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Login" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="false" SourceVersion="Original" />
81	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Status" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="true" SourceVersion="Original" />
82	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Original" />
83	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ClientConfigId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ClientConfigId" SourceColumnNullMapping="true" SourceVersion="Original" />
84	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ClientConfigId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ClientConfigId" SourceColumnNullMapping="false" SourceVersion="Original" />
85	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NumberOfCores" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumberOfCores" SourceColumnNullMapping="true" SourceVersion="Original" />
86	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_NumberOfCores" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumberOfCores" SourceColumnNullMapping="false" SourceVersion="Original" />
87	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NumberOfFreeCores" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumberOfFreeCores" SourceColumnNullMapping="true" SourceVersion="Original" />
88	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_NumberOfFreeCores" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumberOfFreeCores" SourceColumnNullMapping="false" SourceVersion="Original" />
89	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FreeMemory" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FreeMemory" SourceColumnNullMapping="true" SourceVersion="Original" />
90	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FreeMemory" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FreeMemory" SourceColumnNullMapping="false" SourceVersion="Original" />
91	</Parameters>
92	</DbCommand>
93	</UpdateCommand>
94	</DbSource>
95	</MainSource>
96	<Mappings>
97	<Mapping SourceColumn="ResourceId" DataSetColumn="ResourceId" />
98	<Mapping SourceColumn="CPUSpeed" DataSetColumn="CPUSpeed" />
99	<Mapping SourceColumn="Memory" DataSetColumn="Memory" />
100	<Mapping SourceColumn="Login" DataSetColumn="Login" />
101	<Mapping SourceColumn="Status" DataSetColumn="Status" />
102	<Mapping SourceColumn="ClientConfigId" DataSetColumn="ClientConfigId" />
103	<Mapping SourceColumn="NumberOfCores" DataSetColumn="NumberOfCores" />
104	<Mapping SourceColumn="NumberOfFreeCores" DataSetColumn="NumberOfFreeCores" />
105	<Mapping SourceColumn="FreeMemory" DataSetColumn="FreeMemory" />
106	</Mappings>
107	<Sources>
108	<DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="[HeuristicLab.Hive_DBTesting].dbo.Client" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByActive" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByActive" GeneratorSourceName="FillByActive" GetMethodModifier="Public" GetMethodName="GetDataByActive" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByActive" UserSourceName="FillByActive">
109	<SelectCommand>
110	<DbCommand CommandType="Text" ModifiedByUser="true">
111	<CommandText>SELECT CPUSpeed, ClientConfigId, FreeMemory, Login, Memory, NumberOfCores, NumberOfFreeCores, ResourceId, Status FROM Client WHERE (Status <> 'offline')</CommandText>
112	<Parameters />
113	</DbCommand>
114	</SelectCommand>
115	</DbSource>
116	<DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="[HeuristicLab.Hive_DBTesting].dbo.Client" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillById" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataById" GeneratorSourceName="FillById" GetMethodModifier="Public" GetMethodName="GetDataById" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataById" UserSourceName="FillById">
117	<SelectCommand>
118	<DbCommand CommandType="Text" ModifiedByUser="true">
119	<CommandText>SELECT CPUSpeed, ClientConfigId, FreeMemory, Login, Memory, NumberOfCores, NumberOfFreeCores, ResourceId, Status FROM Client WHERE (ResourceId = @Id)</CommandText>
120	<Parameters>
121	<Parameter AllowDbNull="false" AutogeneratedName="Id" ColumnName="ResourceId" DataSourceName="[HeuristicLab.Hive].dbo.Client" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="ResourceId" SourceColumnNullMapping="false" SourceVersion="Current" />
122	</Parameters>
123	</DbCommand>
124	</SelectCommand>
125	</DbSource>
126	</Sources>
127	</TableAdapter>
128	<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ResourceTableAdapter" GeneratorDataComponentClassName="ResourceTableAdapter" Name="Resource" UserDataComponentName="ResourceTableAdapter">
129	<MainSource>
130	<DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="[HeuristicLab.Hive_DBTesting].dbo.Resource" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
131	<DeleteCommand>
132	<DbCommand CommandType="Text" ModifiedByUser="false">
133	<CommandText>DELETE FROM [dbo].[Resource] WHERE (([ResourceId] = @Original_ResourceId))</CommandText>
134	<Parameters>
135	<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ResourceId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ResourceId" SourceColumnNullMapping="false" SourceVersion="Original" />
136	</Parameters>
137	</DbCommand>
138	</DeleteCommand>
139	<InsertCommand>
140	<DbCommand CommandType="Text" ModifiedByUser="false">
141	<CommandText>INSERT INTO [dbo].[Resource] ([ResourceId], [Name]) VALUES (@ResourceId, @Name);
142	SELECT ResourceId, Name FROM Resource WHERE (ResourceId = @ResourceId)</CommandText>
143	<Parameters>
144	<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ResourceId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ResourceId" SourceColumnNullMapping="false" SourceVersion="Current" />
145	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
146	</Parameters>
147	</DbCommand>
148	</InsertCommand>
149	<SelectCommand>
150	<DbCommand CommandType="Text" ModifiedByUser="true">
151	<CommandText>SELECT * FROM dbo.Resource</CommandText>
152	<Parameters />
153	</DbCommand>
154	</SelectCommand>
155	<UpdateCommand>
156	<DbCommand CommandType="Text" ModifiedByUser="false">
157	<CommandText>UPDATE [dbo].[Resource] SET [ResourceId] = @ResourceId, [Name] = @Name WHERE (([ResourceId] = @Original_ResourceId));
158	SELECT ResourceId, Name FROM Resource WHERE (ResourceId = @ResourceId)</CommandText>
159	<Parameters>
160	<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ResourceId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ResourceId" SourceColumnNullMapping="false" SourceVersion="Current" />
161	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
162	<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ResourceId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ResourceId" SourceColumnNullMapping="false" SourceVersion="Original" />
163	</Parameters>
164	</DbCommand>
165	</UpdateCommand>
166	</DbSource>
167	</MainSource>
168	<Mappings>
169	<Mapping SourceColumn="ResourceId" DataSetColumn="ResourceId" />
170	<Mapping SourceColumn="Name" DataSetColumn="Name" />
171	</Mappings>
172	<Sources>
173	<DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="[HeuristicLab.Hive_DBTesting].dbo.Resource" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByActive" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByActive" GeneratorSourceName="FillByActive" GetMethodModifier="Public" GetMethodName="GetDataByActive" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByActive" UserSourceName="FillByActive">
174	<SelectCommand>
175	<DbCommand CommandType="Text" ModifiedByUser="true">
176	<CommandText>SELECT Resource.Name, Resource.ResourceId FROM Resource INNER JOIN Client ON Resource.ResourceId = Client.ResourceId WHERE (Client.Status <> 'offline')</CommandText>
177	<Parameters />
178	</DbCommand>
179	</SelectCommand>
180	</DbSource>
181	<DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="[HeuristicLab.Hive_DBTesting].dbo.Resource" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillById" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataById" GeneratorSourceName="FillById" GetMethodModifier="Public" GetMethodName="GetDataById" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataById" UserSourceName="FillById">
182	<SelectCommand>
183	<DbCommand CommandType="Text" ModifiedByUser="true">
184	<CommandText>SELECT Name, ResourceId FROM Resource WHERE (ResourceId = @ID)</CommandText>
185	<Parameters>
186	<Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ResourceId" DataSourceName="[HeuristicLab.Hive].dbo.Resource" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="ResourceId" SourceColumnNullMapping="false" SourceVersion="Current" />
187	</Parameters>
188	</DbCommand>
189	</SelectCommand>
190	</DbSource>
191	<DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="[HeuristicLab.Hive_DBTesting].dbo.Resource" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByName" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByName" GeneratorSourceName="FillByName" GetMethodModifier="Public" GetMethodName="GetDataByName" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByName" UserSourceName="FillByName">
192	<SelectCommand>
193	<DbCommand CommandType="Text" ModifiedByUser="true">
194	<CommandText>SELECT Name, ResourceId FROM Resource WHERE (Name = @Name)</CommandText>
195	<Parameters>
196	<Parameter AllowDbNull="true" AutogeneratedName="Name" ColumnName="Name" DataSourceName="[HeuristicLab.Hive].dbo.Resource" DataTypeServer="varchar(18)" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="18" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
197	</Parameters>
198	</DbCommand>
199	</SelectCommand>
200	</DbSource>
201	</Sources>
202	</TableAdapter>
203	<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ClientGroupTableAdapter" GeneratorDataComponentClassName="ClientGroupTableAdapter" Name="ClientGroup" UserDataComponentName="ClientGroupTableAdapter">
204	<MainSource>
205	<DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="[HeuristicLab.Hive].dbo.ClientGroup" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
206	<DeleteCommand>
207	<DbCommand CommandType="Text" ModifiedByUser="false">
208	<CommandText>DELETE FROM [dbo].[ClientGroup] WHERE (([ResourceId] = @Original_ResourceId))</CommandText>
209	<Parameters>
210	<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ResourceId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ResourceId" SourceColumnNullMapping="false" SourceVersion="Original" />
211	</Parameters>
212	</DbCommand>
213	</DeleteCommand>
214	<InsertCommand>
215	<DbCommand CommandType="Text" ModifiedByUser="false">
216	<CommandText>INSERT INTO [dbo].[ClientGroup] ([ResourceId]) VALUES (@ResourceId);
217	SELECT ResourceId FROM ClientGroup WHERE (ResourceId = @ResourceId)</CommandText>
218	<Parameters>
219	<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ResourceId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ResourceId" SourceColumnNullMapping="false" SourceVersion="Current" />
220	</Parameters>
221	</DbCommand>
222	</InsertCommand>
223	<SelectCommand>
224	<DbCommand CommandType="Text" ModifiedByUser="true">
225	<CommandText>SELECT * FROM dbo.ClientGroup</CommandText>
226	<Parameters />
227	</DbCommand>
228	</SelectCommand>
229	<UpdateCommand>
230	<DbCommand CommandType="Text" ModifiedByUser="false">
231	<CommandText>UPDATE [dbo].[ClientGroup] SET [ResourceId] = @ResourceId WHERE (([ResourceId] = @Original_ResourceId));
232	SELECT ResourceId FROM ClientGroup WHERE (ResourceId = @ResourceId)</CommandText>
233	<Parameters>
234	<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ResourceId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ResourceId" SourceColumnNullMapping="false" SourceVersion="Current" />
235	<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ResourceId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ResourceId" SourceColumnNullMapping="false" SourceVersion="Original" />
236	</Parameters>
237	</DbCommand>
238	</UpdateCommand>
239	</DbSource>
240	</MainSource>
241	<Mappings>
242	<Mapping SourceColumn="ResourceId" DataSetColumn="ResourceId" />
243	</Mappings>
244	<Sources>
245	<DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="[HeuristicLab.Hive].dbo.ClientGroup" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillById" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataById" GeneratorSourceName="FillById" GetMethodModifier="Public" GetMethodName="GetDataById" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataById" UserSourceName="FillById">
246	<SelectCommand>
247	<DbCommand CommandType="Text" ModifiedByUser="true">
248	<CommandText>SELECT * FROM dbo.ClientGroup WHERE ResourceId = @Id</CommandText>
249	<Parameters>
250	<Parameter AllowDbNull="false" AutogeneratedName="Id" ColumnName="ResourceId" DataSourceName="[HeuristicLab.Hive].dbo.ClientGroup" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="ResourceId" SourceColumnNullMapping="false" SourceVersion="Current" />
251	</Parameters>
252	</DbCommand>
253	</SelectCommand>
254	</DbSource>
255	</Sources>
256	</TableAdapter>
257	<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ClientGroup_ResourceTableAdapter" GeneratorDataComponentClassName="ClientGroup_ResourceTableAdapter" Name="ClientGroup_Resource" UserDataComponentName="ClientGroup_ResourceTableAdapter">
258	<MainSource>
259	<DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="[HeuristicLab.Hive_DBTesting].dbo.ClientGroup_Resource" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
260	<DeleteCommand>
261	<DbCommand CommandType="Text" ModifiedByUser="false">
262	<CommandText>DELETE FROM [dbo].[ClientGroup_Resource] WHERE (([ClientGroupId] = @Original_ClientGroupId) AND ([ResourceId] = @Original_ResourceId))</CommandText>
263	<Parameters>
264	<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ClientGroupId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ClientGroupId" SourceColumnNullMapping="false" SourceVersion="Original" />
265	<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ResourceId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ResourceId" SourceColumnNullMapping="false" SourceVersion="Original" />
266	</Parameters>
267	</DbCommand>
268	</DeleteCommand>
269	<InsertCommand>
270	<DbCommand CommandType="Text" ModifiedByUser="false">
271	<CommandText>INSERT INTO [dbo].[ClientGroup_Resource] ([ClientGroupId], [ResourceId]) VALUES (@ClientGroupId, @ResourceId);
272	SELECT ClientGroupId, ResourceId FROM ClientGroup_Resource WHERE (ClientGroupId = @ClientGroupId) AND (ResourceId = @ResourceId)</CommandText>
273	<Parameters>
274	<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ClientGroupId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ClientGroupId" SourceColumnNullMapping="false" SourceVersion="Current" />
275	<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ResourceId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ResourceId" SourceColumnNullMapping="false" SourceVersion="Current" />
276	</Parameters>
277	</DbCommand>
278	</InsertCommand>
279	<SelectCommand>
280	<DbCommand CommandType="Text" ModifiedByUser="true">
281	<CommandText>SELECT * FROM dbo.ClientGroup_Resource</CommandText>
282	<Parameters />
283	</DbCommand>
284	</SelectCommand>
285	<UpdateCommand>
286	<DbCommand CommandType="Text" ModifiedByUser="false">
287	<CommandText>UPDATE [dbo].[ClientGroup_Resource] SET [ClientGroupId] = @ClientGroupId, [ResourceId] = @ResourceId WHERE (([ClientGroupId] = @Original_ClientGroupId) AND ([ResourceId] = @Original_ResourceId));
288	SELECT ClientGroupId, ResourceId FROM ClientGroup_Resource WHERE (ClientGroupId = @ClientGroupId) AND (ResourceId = @ResourceId)</CommandText>
289	<Parameters>
290	<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ClientGroupId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ClientGroupId" SourceColumnNullMapping="false" SourceVersion="Current" />
291	<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ResourceId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ResourceId" SourceColumnNullMapping="false" SourceVersion="Current" />
292	<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ClientGroupId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ClientGroupId" SourceColumnNullMapping="false" SourceVersion="Original" />
293	<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ResourceId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ResourceId" SourceColumnNullMapping="false" SourceVersion="Original" />
294	</Parameters>
295	</DbCommand>
296	</UpdateCommand>
297	</DbSource>
298	</MainSource>
299	<Mappings>
300	<Mapping SourceColumn="ClientGroupId" DataSetColumn="ClientGroupId" />
301	<Mapping SourceColumn="ResourceId" DataSetColumn="ResourceId" />
302	</Mappings>
303	<Sources>
304	<DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="[HeuristicLab.Hive_DBTesting].dbo.ClientGroup_Resource" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByClientGroupId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByClientGroupId" GeneratorSourceName="FillByClientGroupId" GetMethodModifier="Public" GetMethodName="GetDataByClientGroupId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByClientGroupId" UserSourceName="FillByClientGroupId">
305	<SelectCommand>
306	<DbCommand CommandType="Text" ModifiedByUser="true">
307	<CommandText>SELECT ClientGroupId, ResourceId FROM ClientGroup_Resource WHERE (ClientGroupId = @Id)</CommandText>
308	<Parameters>
309	<Parameter AllowDbNull="false" AutogeneratedName="Id" ColumnName="ClientGroupId" DataSourceName="[HeuristicLab.Hive].dbo.ClientGroup_Resource" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="ClientGroupId" SourceColumnNullMapping="false" SourceVersion="Current" />
310	</Parameters>
311	</DbCommand>
312	</SelectCommand>
313	</DbSource>
314	<DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="[HeuristicLab.Hive_DBTesting].dbo.ClientGroup_Resource" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByClientGroupResourceId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByClientGroupResourceId" GeneratorSourceName="FillByClientGroupResourceId" GetMethodModifier="Public" GetMethodName="GetDataByClientGroupResourceId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByClientGroupResourceId" UserSourceName="FillByClientGroupResourceId">
315	<SelectCommand>
316	<DbCommand CommandType="Text" ModifiedByUser="true">
317	<CommandText>SELECT ClientGroupId, ResourceId FROM ClientGroup_Resource WHERE (ClientGroupId = @ClientGroupId) AND (ResourceId = @ResourceId)</CommandText>
318	<Parameters>
319	<Parameter AllowDbNull="false" AutogeneratedName="ClientGroupId" ColumnName="ClientGroupId" DataSourceName="[HeuristicLab.Hive].dbo.ClientGroup_Resource" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@ClientGroupId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="ClientGroupId" SourceColumnNullMapping="false" SourceVersion="Current" />
320	<Parameter AllowDbNull="false" AutogeneratedName="ResourceId" ColumnName="ResourceId" DataSourceName="[HeuristicLab.Hive].dbo.ClientGroup_Resource" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@ResourceId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="ResourceId" SourceColumnNullMapping="false" SourceVersion="Current" />
321	</Parameters>
322	</DbCommand>
323	</SelectCommand>
324	</DbSource>
325	<DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="[HeuristicLab.Hive_DBTesting].dbo.ClientGroup_Resource" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByResourceId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByResourceId" GeneratorSourceName="FillByResourceId" GetMethodModifier="Public" GetMethodName="GetDataByResourceId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByResourceId" UserSourceName="FillByResourceId">
326	<SelectCommand>
327	<DbCommand CommandType="Text" ModifiedByUser="true">
328	<CommandText>SELECT ClientGroupId, ResourceId FROM ClientGroup_Resource WHERE (ResourceId = @ResourceId)</CommandText>
329	<Parameters>
330	<Parameter AllowDbNull="false" AutogeneratedName="ResourceId" ColumnName="ResourceId" DataSourceName="[HeuristicLab.Hive].dbo.ClientGroup_Resource" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@ResourceId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="ResourceId" SourceColumnNullMapping="false" SourceVersion="Current" />
331	</Parameters>
332	</DbCommand>
333	</SelectCommand>
334	</DbSource>
335	</Sources>
336	</TableAdapter>
337	<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="JobTableAdapter" GeneratorDataComponentClassName="JobTableAdapter" Name="Job" UserDataComponentName="JobTableAdapter">
338	<MainSource>
339	<DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="[HeuristicLab.Hive_DBTesting].dbo.Job" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByStateCoresMemory" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByStateCoresMemory" GeneratorSourceName="FillByStateCoresMemory" GetMethodModifier="Public" GetMethodName="GetDataByStateCoresMemory" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByStateCoresMemory" UserSourceName="FillByStateCoresMemory">
340	<DeleteCommand>
341	<DbCommand CommandType="Text" ModifiedByUser="false">
342	<CommandText>DELETE FROM [dbo].[Job] WHERE (([JobId] = @Original_JobId) AND ((@IsNull_ParentJobId = 1 AND [ParentJobId] IS NULL) OR ([ParentJobId] = @Original_ParentJobId)) AND ((@IsNull_JobState = 1 AND [JobState] IS NULL) OR ([JobState] = @Original_JobState)) AND ((@IsNull_ResourceId = 1 AND [ResourceId] IS NULL) OR ([ResourceId] = @Original_ResourceId)) AND ((@IsNull_Percentage = 1 AND [Percentage] IS NULL) OR ([Percentage] = @Original_Percentage)) AND ((@IsNull_DateCreated = 1 AND [DateCreated] IS NULL) OR ([DateCreated] = @Original_DateCreated)) AND ((@IsNull_DateCalculated = 1 AND [DateCalculated] IS NULL) OR ([DateCalculated] = @Original_DateCalculated)) AND ((@IsNull_Priority = 1 AND [Priority] IS NULL) OR ([Priority] = @Original_Priority)) AND ((@IsNull_ProjectId = 1 AND [ProjectId] IS NULL) OR ([ProjectId] = @Original_ProjectId)) AND ((@IsNull_UserId = 1 AND [UserId] IS NULL) OR ([UserId] = @Original_UserId)) AND ((@IsNull_CoresNeeded = 1 AND [CoresNeeded] IS NULL) OR ([CoresNeeded] = @Original_CoresNeeded)) AND ((@IsNull_MemoryNeeded = 1 AND [MemoryNeeded] IS NULL) OR ([MemoryNeeded] = @Original_MemoryNeeded)))</CommandText>
343	<Parameters>
344	<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_JobId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="JobId" SourceColumnNullMapping="false" SourceVersion="Original" />
345	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ParentJobId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ParentJobId" SourceColumnNullMapping="true" SourceVersion="Original" />
346	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ParentJobId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ParentJobId" SourceColumnNullMapping="false" SourceVersion="Original" />
347	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JobState" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JobState" SourceColumnNullMapping="true" SourceVersion="Original" />
348	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_JobState" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="JobState" SourceColumnNullMapping="false" SourceVersion="Original" />
349	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ResourceId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ResourceId" SourceColumnNullMapping="true" SourceVersion="Original" />
350	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ResourceId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ResourceId" SourceColumnNullMapping="false" SourceVersion="Original" />
351	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Percentage" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Percentage" SourceColumnNullMapping="true" SourceVersion="Original" />
352	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Percentage" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Percentage" SourceColumnNullMapping="false" SourceVersion="Original" />
353	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DateCreated" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DateCreated" SourceColumnNullMapping="true" SourceVersion="Original" />
354	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DateCreated" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateCreated" SourceColumnNullMapping="false" SourceVersion="Original" />
355	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DateCalculated" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DateCalculated" SourceColumnNullMapping="true" SourceVersion="Original" />
356	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DateCalculated" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateCalculated" SourceColumnNullMapping="false" SourceVersion="Original" />
357	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Priority" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Priority" SourceColumnNullMapping="true" SourceVersion="Original" />
358	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Priority" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Priority" SourceColumnNullMapping="false" SourceVersion="Original" />
359	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ProjectId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProjectId" SourceColumnNullMapping="true" SourceVersion="Original" />
360	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ProjectId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ProjectId" SourceColumnNullMapping="false" SourceVersion="Original" />
361	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserId" SourceColumnNullMapping="true" SourceVersion="Original" />
362	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_UserId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="UserId" SourceColumnNullMapping="false" SourceVersion="Original" />
363	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CoresNeeded" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CoresNeeded" SourceColumnNullMapping="true" SourceVersion="Original" />
364	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CoresNeeded" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CoresNeeded" SourceColumnNullMapping="false" SourceVersion="Original" />
365	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MemoryNeeded" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MemoryNeeded" SourceColumnNullMapping="true" SourceVersion="Original" />
366	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_MemoryNeeded" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MemoryNeeded" SourceColumnNullMapping="false" SourceVersion="Original" />
367	</Parameters>
368	</DbCommand>
369	</DeleteCommand>
370	<InsertCommand>
371	<DbCommand CommandType="Text" ModifiedByUser="false">
372	<CommandText>INSERT INTO [dbo].[Job] ([JobId], [ParentJobId], [JobState], [ResourceId], [Percentage], [SerializedJob], [DateCreated], [DateCalculated], [Priority], [ProjectId], [UserId], [CoresNeeded], [MemoryNeeded]) VALUES (@JobId, @ParentJobId, @JobState, @ResourceId, @Percentage, @SerializedJob, @DateCreated, @DateCalculated, @Priority, @ProjectId, @UserId, @CoresNeeded, @MemoryNeeded);
373	SELECT JobId, ParentJobId, JobState, ResourceId, Percentage, SerializedJob, DateCreated, DateCalculated, Priority, ProjectId, UserId, CoresNeeded, MemoryNeeded FROM Job WHERE (JobId = @JobId) ORDER BY Priority</CommandText>
374	<Parameters>
375	<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@JobId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="JobId" SourceColumnNullMapping="false" SourceVersion="Current" />
376	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ParentJobId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ParentJobId" SourceColumnNullMapping="false" SourceVersion="Current" />
377	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@JobState" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="JobState" SourceColumnNullMapping="false" SourceVersion="Current" />
378	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ResourceId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ResourceId" SourceColumnNullMapping="false" SourceVersion="Current" />
379	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Percentage" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Percentage" SourceColumnNullMapping="false" SourceVersion="Current" />
380	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@SerializedJob" Precision="0" ProviderType="VarBinary" Scale="0" Size="0" SourceColumn="SerializedJob" SourceColumnNullMapping="false" SourceVersion="Current" />
381	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateCreated" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateCreated" SourceColumnNullMapping="false" SourceVersion="Current" />
382	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateCalculated" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateCalculated" SourceColumnNullMapping="false" SourceVersion="Current" />
383	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Priority" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Priority" SourceColumnNullMapping="false" SourceVersion="Current" />
384	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ProjectId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ProjectId" SourceColumnNullMapping="false" SourceVersion="Current" />
385	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@UserId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="UserId" SourceColumnNullMapping="false" SourceVersion="Current" />
386	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CoresNeeded" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CoresNeeded" SourceColumnNullMapping="false" SourceVersion="Current" />
387	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MemoryNeeded" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MemoryNeeded" SourceColumnNullMapping="false" SourceVersion="Current" />
388	</Parameters>
389	</DbCommand>
390	</InsertCommand>
391	<SelectCommand>
392	<DbCommand CommandType="Text" ModifiedByUser="true">
393	<CommandText>SELECT * FROM dbo.Job WHERE JobState = @State AND CoresNeeded <= @CoresNeeded AND MemoryNeeded <= @MemoryNeeded ORDER BY Priority</CommandText>
394	<Parameters>
395	<Parameter AllowDbNull="true" AutogeneratedName="State" ColumnName="JobState" DataSourceName="[HeuristicLab.Hive_DBTesting].dbo.Job" DataTypeServer="varchar(18)" DbType="AnsiString" Direction="Input" ParameterName="@State" Precision="0" ProviderType="VarChar" Scale="0" Size="18" SourceColumn="JobState" SourceColumnNullMapping="false" SourceVersion="Current" />
396	<Parameter AllowDbNull="true" AutogeneratedName="CoresNeeded" ColumnName="CoresNeeded" DataSourceName="[HeuristicLab.Hive_DBTesting].dbo.Job" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CoresNeeded" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CoresNeeded" SourceColumnNullMapping="false" SourceVersion="Current" />
397	<Parameter AllowDbNull="true" AutogeneratedName="MemoryNeeded" ColumnName="MemoryNeeded" DataSourceName="[HeuristicLab.Hive_DBTesting].dbo.Job" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@MemoryNeeded" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="MemoryNeeded" SourceColumnNullMapping="false" SourceVersion="Current" />
398	</Parameters>
399	</DbCommand>
400	</SelectCommand>
401	<UpdateCommand>
402	<DbCommand CommandType="Text" ModifiedByUser="false">
403	<CommandText>UPDATE [dbo].[Job] SET [JobId] = @JobId, [ParentJobId] = @ParentJobId, [JobState] = @JobState, [ResourceId] = @ResourceId, [Percentage] = @Percentage, [SerializedJob] = @SerializedJob, [DateCreated] = @DateCreated, [DateCalculated] = @DateCalculated, [Priority] = @Priority, [ProjectId] = @ProjectId, [UserId] = @UserId, [CoresNeeded] = @CoresNeeded, [MemoryNeeded] = @MemoryNeeded WHERE (([JobId] = @Original_JobId) AND ((@IsNull_ParentJobId = 1 AND [ParentJobId] IS NULL) OR ([ParentJobId] = @Original_ParentJobId)) AND ((@IsNull_JobState = 1 AND [JobState] IS NULL) OR ([JobState] = @Original_JobState)) AND ((@IsNull_ResourceId = 1 AND [ResourceId] IS NULL) OR ([ResourceId] = @Original_ResourceId)) AND ((@IsNull_Percentage = 1 AND [Percentage] IS NULL) OR ([Percentage] = @Original_Percentage)) AND ((@IsNull_DateCreated = 1 AND [DateCreated] IS NULL) OR ([DateCreated] = @Original_DateCreated)) AND ((@IsNull_DateCalculated = 1 AND [DateCalculated] IS NULL) OR ([DateCalculated] = @Original_DateCalculated)) AND ((@IsNull_Priority = 1 AND [Priority] IS NULL) OR ([Priority] = @Original_Priority)) AND ((@IsNull_ProjectId = 1 AND [ProjectId] IS NULL) OR ([ProjectId] = @Original_ProjectId)) AND ((@IsNull_UserId = 1 AND [UserId] IS NULL) OR ([UserId] = @Original_UserId)) AND ((@IsNull_CoresNeeded = 1 AND [CoresNeeded] IS NULL) OR ([CoresNeeded] = @Original_CoresNeeded)) AND ((@IsNull_MemoryNeeded = 1 AND [MemoryNeeded] IS NULL) OR ([MemoryNeeded] = @Original_MemoryNeeded)));
404	SELECT JobId, ParentJobId, JobState, ResourceId, Percentage, SerializedJob, DateCreated, DateCalculated, Priority, ProjectId, UserId, CoresNeeded, MemoryNeeded FROM Job WHERE (JobId = @JobId) ORDER BY Priority</CommandText>
405	<Parameters>
406	<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@JobId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="JobId" SourceColumnNullMapping="false" SourceVersion="Current" />
407	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ParentJobId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ParentJobId" SourceColumnNullMapping="false" SourceVersion="Current" />
408	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@JobState" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="JobState" SourceColumnNullMapping="false" SourceVersion="Current" />
409	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ResourceId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ResourceId" SourceColumnNullMapping="false" SourceVersion="Current" />
410	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Percentage" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Percentage" SourceColumnNullMapping="false" SourceVersion="Current" />
411	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@SerializedJob" Precision="0" ProviderType="VarBinary" Scale="0" Size="0" SourceColumn="SerializedJob" SourceColumnNullMapping="false" SourceVersion="Current" />
412	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateCreated" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateCreated" SourceColumnNullMapping="false" SourceVersion="Current" />
413	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateCalculated" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateCalculated" SourceColumnNullMapping="false" SourceVersion="Current" />
414	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Priority" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Priority" SourceColumnNullMapping="false" SourceVersion="Current" />
415	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ProjectId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ProjectId" SourceColumnNullMapping="false" SourceVersion="Current" />
416	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@UserId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="UserId" SourceColumnNullMapping="false" SourceVersion="Current" />
417	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CoresNeeded" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CoresNeeded" SourceColumnNullMapping="false" SourceVersion="Current" />
418	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MemoryNeeded" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MemoryNeeded" SourceColumnNullMapping="false" SourceVersion="Current" />
419	<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_JobId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="JobId" SourceColumnNullMapping="false" SourceVersion="Original" />
420	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ParentJobId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ParentJobId" SourceColumnNullMapping="true" SourceVersion="Original" />
421	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ParentJobId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ParentJobId" SourceColumnNullMapping="false" SourceVersion="Original" />
422	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JobState" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JobState" SourceColumnNullMapping="true" SourceVersion="Original" />
423	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_JobState" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="JobState" SourceColumnNullMapping="false" SourceVersion="Original" />
424	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ResourceId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ResourceId" SourceColumnNullMapping="true" SourceVersion="Original" />
425	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ResourceId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ResourceId" SourceColumnNullMapping="false" SourceVersion="Original" />
426	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Percentage" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Percentage" SourceColumnNullMapping="true" SourceVersion="Original" />
427	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Percentage" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Percentage" SourceColumnNullMapping="false" SourceVersion="Original" />
428	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DateCreated" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DateCreated" SourceColumnNullMapping="true" SourceVersion="Original" />
429	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DateCreated" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateCreated" SourceColumnNullMapping="false" SourceVersion="Original" />
430	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DateCalculated" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DateCalculated" SourceColumnNullMapping="true" SourceVersion="Original" />
431	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DateCalculated" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateCalculated" SourceColumnNullMapping="false" SourceVersion="Original" />
432	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Priority" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Priority" SourceColumnNullMapping="true" SourceVersion="Original" />
433	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Priority" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Priority" SourceColumnNullMapping="false" SourceVersion="Original" />
434	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ProjectId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProjectId" SourceColumnNullMapping="true" SourceVersion="Original" />
435	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ProjectId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ProjectId" SourceColumnNullMapping="false" SourceVersion="Original" />
436	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserId" SourceColumnNullMapping="true" SourceVersion="Original" />
437	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_UserId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="UserId" SourceColumnNullMapping="false" SourceVersion="Original" />
438	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CoresNeeded" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CoresNeeded" SourceColumnNullMapping="true" SourceVersion="Original" />
439	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CoresNeeded" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CoresNeeded" SourceColumnNullMapping="false" SourceVersion="Original" />
440	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MemoryNeeded" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MemoryNeeded" SourceColumnNullMapping="true" SourceVersion="Original" />
441	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_MemoryNeeded" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MemoryNeeded" SourceColumnNullMapping="false" SourceVersion="Original" />
442	</Parameters>
443	</DbCommand>
444	</UpdateCommand>
445	</DbSource>
446	</MainSource>
447	<Mappings>
448	<Mapping SourceColumn="JobId" DataSetColumn="JobId" />
449	<Mapping SourceColumn="ParentJobId" DataSetColumn="ParentJobId" />
450	<Mapping SourceColumn="JobState" DataSetColumn="JobState" />
451	<Mapping SourceColumn="ResourceId" DataSetColumn="ResourceId" />
452	<Mapping SourceColumn="Percentage" DataSetColumn="Percentage" />
453	<Mapping SourceColumn="SerializedJob" DataSetColumn="SerializedJob" />
454	<Mapping SourceColumn="DateCreated" DataSetColumn="DateCreated" />
455	<Mapping SourceColumn="DateCalculated" DataSetColumn="DateCalculated" />
456	<Mapping SourceColumn="Priority" DataSetColumn="Priority" />
457	<Mapping SourceColumn="ProjectId" DataSetColumn="ProjectId" />
458	<Mapping SourceColumn="UserId" DataSetColumn="UserId" />
459	<Mapping SourceColumn="CoresNeeded" DataSetColumn="CoresNeeded" />
460	<Mapping SourceColumn="MemoryNeeded" DataSetColumn="MemoryNeeded" />
461	</Mappings>
462	<Sources>
463	<DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="[HeuristicLab.Hive_DBTesting].dbo.Job" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
464	<SelectCommand>
465	<DbCommand CommandType="Text" ModifiedByUser="true">
466	<CommandText>SELECT CoresNeeded, DateCalculated, DateCreated, JobId, JobState, MemoryNeeded, ParentJobId, Percentage, Priority, ProjectId, ResourceId, SerializedJob, UserId FROM Job</CommandText>
467	<Parameters />
468	</DbCommand>
469	</SelectCommand>
470	</DbSource>
471	<DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="[HeuristicLab.Hive_DBTesting].dbo.Job" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByActive" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByActive" GeneratorSourceName="FillByActive" GetMethodModifier="Public" GetMethodName="GetDataByActive" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByActive" UserSourceName="FillByActive">
472	<SelectCommand>
473	<DbCommand CommandType="Text" ModifiedByUser="true">
474	<CommandText>SELECT CoresNeeded, DateCalculated, DateCreated, JobId, JobState, MemoryNeeded, ParentJobId, Percentage, Priority, ProjectId, ResourceId, SerializedJob, UserId FROM Job WHERE (JobState = 'calculating') OR (JobState = 'idle')</CommandText>
475	<Parameters />
476	</DbCommand>
477	</SelectCommand>
478	</DbSource>
479	<DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="[HeuristicLab.Hive_DBTesting].dbo.Job" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByCalculatingClient" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByCalculatingClient" GeneratorSourceName="FillByCalculatingClient" GetMethodModifier="Public" GetMethodName="GetDataByCalculatingClient" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByCalculatingClient" UserSourceName="FillByCalculatingClient">
480	<SelectCommand>
481	<DbCommand CommandType="Text" ModifiedByUser="true">
482	<CommandText>SELECT CoresNeeded, DateCalculated, DateCreated, JobId, JobState, MemoryNeeded, ParentJobId, Percentage, Priority, ProjectId, ResourceId, SerializedJob, UserId FROM Job WHERE ((JobState = 'calculating') OR (JobState = 'abort') OR (JobState = 'requestSnapshot ')) AND (ResourceId = @ResourceId)</CommandText>
483	<Parameters>
484	<Parameter AllowDbNull="true" AutogeneratedName="ResourceId" ColumnName="ResourceId" DataSourceName="[HeuristicLab.Hive_DBTesting].dbo.Job" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@ResourceId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="ResourceId" SourceColumnNullMapping="false" SourceVersion="Current" />
485	</Parameters>
486	</DbCommand>
487	</SelectCommand>
488	</DbSource>
489	<DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="[HeuristicLab.Hive_DBTesting].dbo.Job" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByClient" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByClient" GeneratorSourceName="FillByClient" GetMethodModifier="Public" GetMethodName="GetDataByClient" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByClient" UserSourceName="FillByClient">
490	<SelectCommand>
491	<DbCommand CommandType="Text" ModifiedByUser="true">
492	<CommandText>SELECT CoresNeeded, DateCalculated, DateCreated, JobId, JobState, MemoryNeeded, ParentJobId, Percentage, Priority, ProjectId, ResourceId, SerializedJob, UserId FROM Job WHERE (ResourceId = @ResourceId)</CommandText>
493	<Parameters>
494	<Parameter AllowDbNull="true" AutogeneratedName="ResourceId" ColumnName="ResourceId" DataSourceName="[HeuristicLab.Hive].dbo.Job" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@ResourceId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="ResourceId" SourceColumnNullMapping="false" SourceVersion="Current" />
495	</Parameters>
496	</DbCommand>
497	</SelectCommand>
498	</DbSource>
499	<DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="[HeuristicLab.Hive_DBTesting].dbo.Job" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillById" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataById" GeneratorSourceName="FillById" GetMethodModifier="Public" GetMethodName="GetDataById" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataById" UserSourceName="FillById">
500	<SelectCommand>
501	<DbCommand CommandType="Text" ModifiedByUser="true">
502	<CommandText>SELECT CoresNeeded, DateCalculated, DateCreated, JobId, JobState, MemoryNeeded, ParentJobId, Percentage, Priority, ProjectId, ResourceId, SerializedJob, UserId FROM Job WHERE (JobId = @Id)</CommandText>
503	<Parameters>
504	<Parameter AllowDbNull="false" AutogeneratedName="Id" ColumnName="JobId" DataSourceName="[HeuristicLab.Hive].dbo.Job" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="JobId" SourceColumnNullMapping="false" SourceVersion="Current" />
505	</Parameters>
506	</DbCommand>
507	</SelectCommand>
508	</DbSource>
509	<DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="[HeuristicLab.Hive_DBTesting].dbo.Job" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByJob" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByJob" GeneratorSourceName="FillByJob" GetMethodModifier="Public" GetMethodName="GetDataByJob" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByJob" UserSourceName="FillByJob">
510	<SelectCommand>
511	<DbCommand CommandType="Text" ModifiedByUser="true">
512	<CommandText>SELECT CoresNeeded, DateCalculated, DateCreated, JobId, JobState, MemoryNeeded, ParentJobId, Percentage, Priority, ProjectId, ResourceId, SerializedJob, UserId FROM Job WHERE (JobId = @Id)</CommandText>
513	<Parameters>
514	<Parameter AllowDbNull="false" AutogeneratedName="Id" ColumnName="JobId" DataSourceName="[HeuristicLab.Hive].dbo.Job" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="JobId" SourceColumnNullMapping="false" SourceVersion="Current" />
515	</Parameters>
516	</DbCommand>
517	</SelectCommand>
518	</DbSource>
519	<DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="[HeuristicLab.Hive_DBTesting].dbo.Job" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByParentJob" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByParentJob" GeneratorSourceName="FillByParentJob" GetMethodModifier="Public" GetMethodName="GetDataByParentJob" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByParentJob" UserSourceName="FillByParentJob">
520	<SelectCommand>
521	<DbCommand CommandType="Text" ModifiedByUser="true">
522	<CommandText>SELECT CoresNeeded, DateCalculated, DateCreated, JobId, JobState, MemoryNeeded, ParentJobId, Percentage, Priority, ProjectId, ResourceId, SerializedJob, UserId FROM Job WHERE (ParentJobId = @Id)</CommandText>
523	<Parameters>
524	<Parameter AllowDbNull="true" AutogeneratedName="Id" ColumnName="ParentJobId" DataSourceName="[HeuristicLab.Hive].dbo.Job" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="ParentJobId" SourceColumnNullMapping="false" SourceVersion="Current" />
525	</Parameters>
526	</DbCommand>
527	</SelectCommand>
528	</DbSource>
529	<DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="[HeuristicLab.Hive_DBTesting].dbo.Job" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByState" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByState" GeneratorSourceName="FillByState" GetMethodModifier="Public" GetMethodName="GetDataByState" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByState" UserSourceName="FillByState">
530	<SelectCommand>
531	<DbCommand CommandType="Text" ModifiedByUser="true">
532	<CommandText>SELECT CoresNeeded, DateCalculated, DateCreated, JobId, JobState, MemoryNeeded, ParentJobId, Percentage, Priority, ProjectId, ResourceId, SerializedJob, UserId FROM Job WHERE (JobState = @State)</CommandText>
533	<Parameters>
534	<Parameter AllowDbNull="true" AutogeneratedName="State" ColumnName="JobState" DataSourceName="[HeuristicLab.Hive].dbo.Job" DataTypeServer="varchar(18)" DbType="AnsiString" Direction="Input" ParameterName="@State" Precision="0" ProviderType="VarChar" Scale="0" Size="18" SourceColumn="JobState" SourceColumnNullMapping="false" SourceVersion="Current" />
535	</Parameters>
536	</DbCommand>
537	</SelectCommand>
538	</DbSource>
539	<DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="[HeuristicLab.Hive_DBTesting].dbo.Job" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByUser" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByUser" GeneratorSourceName="FillByUser" GetMethodModifier="Public" GetMethodName="GetDataByUser" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByUser" UserSourceName="FillByUser">
540	<SelectCommand>
541	<DbCommand CommandType="Text" ModifiedByUser="true">
542	<CommandText>SELECT CoresNeeded, DateCalculated, DateCreated, JobId, JobState, MemoryNeeded, ParentJobId, Percentage, Priority, ProjectId, ResourceId, SerializedJob, UserId FROM Job WHERE (UserId = @UserId)</CommandText>
543	<Parameters>
544	<Parameter AllowDbNull="true" AutogeneratedName="UserId" ColumnName="UserId" DataSourceName="[HeuristicLab.Hive].dbo.Job" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@UserId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="UserId" SourceColumnNullMapping="false" SourceVersion="Current" />
545	</Parameters>
546	</DbCommand>
547	</SelectCommand>
548	</DbSource>
549	</Sources>
550	</TableAdapter>
551	<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="JobResultTableAdapter" GeneratorDataComponentClassName="JobResultTableAdapter" Name="JobResult" UserDataComponentName="JobResultTableAdapter">
552	<MainSource>
553	<DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="[HeuristicLab.Hive_DBTesting].dbo.JobResult" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
554	<DeleteCommand>
555	<DbCommand CommandType="Text" ModifiedByUser="false">
556	<CommandText>DELETE FROM [dbo].[JobResult] WHERE (([JobResultId] = @Original_JobResultId) AND ((@IsNull_JobId = 1 AND [JobId] IS NULL) OR ([JobId] = @Original_JobId)) AND ((@IsNull_Percentage = 1 AND [Percentage] IS NULL) OR ([Percentage] = @Original_Percentage)) AND ((@IsNull_ResourceId = 1 AND [ResourceId] IS NULL) OR ([ResourceId] = @Original_ResourceId)) AND ((@IsNull_DateFinished = 1 AND [DateFinished] IS NULL) OR ([DateFinished] = @Original_DateFinished)))</CommandText>
557	<Parameters>
558	<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_JobResultId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="JobResultId" SourceColumnNullMapping="false" SourceVersion="Original" />
559	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JobId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JobId" SourceColumnNullMapping="true" SourceVersion="Original" />
560	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_JobId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="JobId" SourceColumnNullMapping="false" SourceVersion="Original" />
561	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Percentage" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Percentage" SourceColumnNullMapping="true" SourceVersion="Original" />
562	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Percentage" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Percentage" SourceColumnNullMapping="false" SourceVersion="Original" />
563	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ResourceId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ResourceId" SourceColumnNullMapping="true" SourceVersion="Original" />
564	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ResourceId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ResourceId" SourceColumnNullMapping="false" SourceVersion="Original" />
565	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DateFinished" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DateFinished" SourceColumnNullMapping="true" SourceVersion="Original" />
566	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DateFinished" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateFinished" SourceColumnNullMapping="false" SourceVersion="Original" />
567	</Parameters>
568	</DbCommand>
569	</DeleteCommand>
570	<InsertCommand>
571	<DbCommand CommandType="Text" ModifiedByUser="false">
572	<CommandText>INSERT INTO [dbo].[JobResult] ([JobResultId], [JobId], [JobResult], [Message], [Percentage], [ResourceId], [DateFinished]) VALUES (@JobResultId, @JobId, @JobResult, @Message, @Percentage, @ResourceId, @DateFinished);
573	SELECT JobResultId, JobId, JobResult, Message, Percentage, ResourceId, DateFinished FROM JobResult WHERE (JobResultId = @JobResultId)</CommandText>
574	<Parameters>
575	<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@JobResultId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="JobResultId" SourceColumnNullMapping="false" SourceVersion="Current" />
576	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@JobId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="JobId" SourceColumnNullMapping="false" SourceVersion="Current" />
577	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@JobResult" Precision="0" ProviderType="VarBinary" Scale="0" Size="0" SourceColumn="JobResult" SourceColumnNullMapping="false" SourceVersion="Current" />
578	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Message" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Message" SourceColumnNullMapping="false" SourceVersion="Current" />
579	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Percentage" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Percentage" SourceColumnNullMapping="false" SourceVersion="Current" />
580	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ResourceId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ResourceId" SourceColumnNullMapping="false" SourceVersion="Current" />
581	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateFinished" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateFinished" SourceColumnNullMapping="false" SourceVersion="Current" />
582	</Parameters>
583	</DbCommand>
584	</InsertCommand>
585	<SelectCommand>
586	<DbCommand CommandType="Text" ModifiedByUser="true">
587	<CommandText>SELECT * FROM dbo.JobResult</CommandText>
588	<Parameters />
589	</DbCommand>
590	</SelectCommand>
591	<UpdateCommand>
592	<DbCommand CommandType="Text" ModifiedByUser="false">
593	<CommandText>UPDATE [dbo].[JobResult] SET [JobResultId] = @JobResultId, [JobId] = @JobId, [JobResult] = @JobResult, [Message] = @Message, [Percentage] = @Percentage, [ResourceId] = @ResourceId, [DateFinished] = @DateFinished WHERE (([JobResultId] = @Original_JobResultId) AND ((@IsNull_JobId = 1 AND [JobId] IS NULL) OR ([JobId] = @Original_JobId)) AND ((@IsNull_Percentage = 1 AND [Percentage] IS NULL) OR ([Percentage] = @Original_Percentage)) AND ((@IsNull_ResourceId = 1 AND [ResourceId] IS NULL) OR ([ResourceId] = @Original_ResourceId)) AND ((@IsNull_DateFinished = 1 AND [DateFinished] IS NULL) OR ([DateFinished] = @Original_DateFinished)));
594	SELECT JobResultId, JobId, JobResult, Message, Percentage, ResourceId, DateFinished FROM JobResult WHERE (JobResultId = @JobResultId)</CommandText>
595	<Parameters>
596	<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@JobResultId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="JobResultId" SourceColumnNullMapping="false" SourceVersion="Current" />
597	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@JobId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="JobId" SourceColumnNullMapping="false" SourceVersion="Current" />
598	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@JobResult" Precision="0" ProviderType="VarBinary" Scale="0" Size="0" SourceColumn="JobResult" SourceColumnNullMapping="false" SourceVersion="Current" />
599	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Message" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Message" SourceColumnNullMapping="false" SourceVersion="Current" />
600	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Percentage" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Percentage" SourceColumnNullMapping="false" SourceVersion="Current" />
601	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ResourceId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ResourceId" SourceColumnNullMapping="false" SourceVersion="Current" />
602	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateFinished" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateFinished" SourceColumnNullMapping="false" SourceVersion="Current" />
603	<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_JobResultId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="JobResultId" SourceColumnNullMapping="false" SourceVersion="Original" />
604	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JobId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JobId" SourceColumnNullMapping="true" SourceVersion="Original" />
605	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_JobId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="JobId" SourceColumnNullMapping="false" SourceVersion="Original" />
606	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Percentage" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Percentage" SourceColumnNullMapping="true" SourceVersion="Original" />
607	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Percentage" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Percentage" SourceColumnNullMapping="false" SourceVersion="Original" />
608	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ResourceId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ResourceId" SourceColumnNullMapping="true" SourceVersion="Original" />
609	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ResourceId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ResourceId" SourceColumnNullMapping="false" SourceVersion="Original" />
610	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DateFinished" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DateFinished" SourceColumnNullMapping="true" SourceVersion="Original" />
611	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DateFinished" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateFinished" SourceColumnNullMapping="false" SourceVersion="Original" />
612	</Parameters>
613	</DbCommand>
614	</UpdateCommand>
615	</DbSource>
616	</MainSource>
617	<Mappings>
618	<Mapping SourceColumn="JobResultId" DataSetColumn="JobResultId" />
619	<Mapping SourceColumn="JobId" DataSetColumn="JobId" />
620	<Mapping SourceColumn="JobResult" DataSetColumn="JobResult" />
621	<Mapping SourceColumn="Message" DataSetColumn="Message" />
622	<Mapping SourceColumn="Percentage" DataSetColumn="Percentage" />
623	<Mapping SourceColumn="ResourceId" DataSetColumn="ResourceId" />
624	<Mapping SourceColumn="DateFinished" DataSetColumn="DateFinished" />
625	</Mappings>
626	<Sources>
627	<DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="[HeuristicLab.Hive_DBTesting].dbo.JobResult" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillById" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataById" GeneratorSourceName="FillById" GetMethodModifier="Public" GetMethodName="GetDataById" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataById" UserSourceName="FillById">
628	<SelectCommand>
629	<DbCommand CommandType="Text" ModifiedByUser="true">
630	<CommandText>SELECT DateFinished, JobId, JobResult, JobResultId, Message, Percentage, ResourceId FROM JobResult WHERE (JobResultId = @Id)</CommandText>
631	<Parameters>
632	<Parameter AllowDbNull="false" AutogeneratedName="Id" ColumnName="JobResultId" DataSourceName="[HeuristicLab.Hive].dbo.JobResult" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="JobResultId" SourceColumnNullMapping="false" SourceVersion="Current" />
633	</Parameters>
634	</DbCommand>
635	</SelectCommand>
636	</DbSource>
637	<DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="[HeuristicLab.Hive_DBTesting].dbo.JobResult" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByJob" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByJob" GeneratorSourceName="FillByJob" GetMethodModifier="Public" GetMethodName="GetDataByJob" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByJob" UserSourceName="FillByJob">
638	<SelectCommand>
639	<DbCommand CommandType="Text" ModifiedByUser="true">
640	<CommandText>SELECT DateFinished, JobId, JobResult, JobResultId, Message, Percentage, ResourceId FROM JobResult WHERE (JobId = @JobId)</CommandText>
641	<Parameters>
642	<Parameter AllowDbNull="true" AutogeneratedName="JobId" ColumnName="JobId" DataSourceName="[HeuristicLab.Hive].dbo.JobResult" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@JobId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="JobId" SourceColumnNullMapping="false" SourceVersion="Current" />
643	</Parameters>
644	</DbCommand>
645	</SelectCommand>
646	</DbSource>
647	</Sources>
648	</TableAdapter>
649	<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RequiredPluginsTableAdapter" GeneratorDataComponentClassName="RequiredPluginsTableAdapter" Name="RequiredPlugins" UserDataComponentName="RequiredPluginsTableAdapter">
650	<MainSource>
651	<DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="[HeuristicLab.Hive_DBTesting].dbo.RequiredPlugins" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
652	<DeleteCommand>
653	<DbCommand CommandType="Text" ModifiedByUser="false">
654	<CommandText>DELETE FROM [dbo].[RequiredPlugins] WHERE (([JobId] = @Original_JobId) AND ([PluginId] = @Original_PluginId))</CommandText>
655	<Parameters>
656	<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_JobId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="JobId" SourceColumnNullMapping="false" SourceVersion="Original" />
657	<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_PluginId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PluginId" SourceColumnNullMapping="false" SourceVersion="Original" />
658	</Parameters>
659	</DbCommand>
660	</DeleteCommand>
661	<InsertCommand>
662	<DbCommand CommandType="Text" ModifiedByUser="false">
663	<CommandText>INSERT INTO [dbo].[RequiredPlugins] ([JobId], [PluginId]) VALUES (@JobId, @PluginId);
664	SELECT JobId, PluginId FROM RequiredPlugins WHERE (JobId = @JobId) AND (PluginId = @PluginId)</CommandText>
665	<Parameters>
666	<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@JobId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="JobId" SourceColumnNullMapping="false" SourceVersion="Current" />
667	<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@PluginId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PluginId" SourceColumnNullMapping="false" SourceVersion="Current" />
668	</Parameters>
669	</DbCommand>
670	</InsertCommand>
671	<SelectCommand>
672	<DbCommand CommandType="Text" ModifiedByUser="false">
673	<CommandText>SELECT JobId, PluginId FROM dbo.RequiredPlugins</CommandText>
674	<Parameters />
675	</DbCommand>
676	</SelectCommand>
677	<UpdateCommand>
678	<DbCommand CommandType="Text" ModifiedByUser="false">
679	<CommandText>UPDATE [dbo].[RequiredPlugins] SET [JobId] = @JobId, [PluginId] = @PluginId WHERE (([JobId] = @Original_JobId) AND ([PluginId] = @Original_PluginId));
680	SELECT JobId, PluginId FROM RequiredPlugins WHERE (JobId = @JobId) AND (PluginId = @PluginId)</CommandText>
681	<Parameters>
682	<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@JobId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="JobId" SourceColumnNullMapping="false" SourceVersion="Current" />
683	<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@PluginId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PluginId" SourceColumnNullMapping="false" SourceVersion="Current" />
684	<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_JobId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="JobId" SourceColumnNullMapping="false" SourceVersion="Original" />
685	<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_PluginId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PluginId" SourceColumnNullMapping="false" SourceVersion="Original" />
686	</Parameters>
687	</DbCommand>
688	</UpdateCommand>
689	</DbSource>
690	</MainSource>
691	<Mappings>
692	<Mapping SourceColumn="JobId" DataSetColumn="JobId" />
693	<Mapping SourceColumn="PluginId" DataSetColumn="PluginId" />
694	</Mappings>
695	<Sources>
696	<DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="[HeuristicLab.Hive_DBTesting].dbo.RequiredPlugins" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillById" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataById" GeneratorSourceName="FillById" GetMethodModifier="Public" GetMethodName="GetDataById" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataById" UserSourceName="FillById">
697	<SelectCommand>
698	<DbCommand CommandType="Text" ModifiedByUser="true">
699	<CommandText>SELECT * FROM dbo.RequiredPlugins WHERE JobId = @JobId</CommandText>
700	<Parameters>
701	<Parameter AllowDbNull="false" AutogeneratedName="JobId" ColumnName="JobId" DataSourceName="[HeuristicLab.Hive_DBTesting].dbo.RequiredPlugins" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@JobId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="JobId" SourceColumnNullMapping="false" SourceVersion="Current" />
702	</Parameters>
703	</DbCommand>
704	</SelectCommand>
705	</DbSource>
706	</Sources>
707	</TableAdapter>
708	<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PluginInfoTableAdapter" GeneratorDataComponentClassName="PluginInfoTableAdapter" Name="PluginInfo" UserDataComponentName="PluginInfoTableAdapter">
709	<MainSource>
710	<DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="[HeuristicLab.Hive_DBTesting].dbo.PluginInfo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
711	<DeleteCommand>
712	<DbCommand CommandType="Text" ModifiedByUser="false">
713	<CommandText>DELETE FROM [PluginInfo] WHERE (([PluginId] = @Original_PluginId) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_Version = 1 AND [Version] IS NULL) OR ([Version] = @Original_Version)) AND ((@IsNull_BuildDate = 1 AND [BuildDate] IS NULL) OR ([BuildDate] = @Original_BuildDate)))</CommandText>
714	<Parameters>
715	<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_PluginId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PluginId" SourceColumnNullMapping="false" SourceVersion="Original" />
716	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="true" SourceVersion="Original" />
717	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
718	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Version" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Version" SourceColumnNullMapping="true" SourceVersion="Original" />
719	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Version" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Version" SourceColumnNullMapping="false" SourceVersion="Original" />
720	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BuildDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BuildDate" SourceColumnNullMapping="true" SourceVersion="Original" />
721	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_BuildDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="BuildDate" SourceColumnNullMapping="false" SourceVersion="Original" />
722	</Parameters>
723	</DbCommand>
724	</DeleteCommand>
725	<InsertCommand>
726	<DbCommand CommandType="Text" ModifiedByUser="false">
727	<CommandText>INSERT INTO [PluginInfo] ([PluginId], [Name], [Version], [BuildDate]) VALUES (@PluginId, @Name, @Version, @BuildDate);
728	SELECT PluginId, Name, Version, BuildDate FROM PluginInfo WHERE (PluginId = @PluginId)</CommandText>
729	<Parameters>
730	<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@PluginId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PluginId" SourceColumnNullMapping="false" SourceVersion="Current" />
731	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
732	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Version" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Version" SourceColumnNullMapping="false" SourceVersion="Current" />
733	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@BuildDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="BuildDate" SourceColumnNullMapping="false" SourceVersion="Current" />
734	</Parameters>
735	</DbCommand>
736	</InsertCommand>
737	<SelectCommand>
738	<DbCommand CommandType="Text" ModifiedByUser="true">
739	<CommandText>SELECT * FROM PluginInfo</CommandText>
740	<Parameters />
741	</DbCommand>
742	</SelectCommand>
743	<UpdateCommand>
744	<DbCommand CommandType="Text" ModifiedByUser="false">
745	<CommandText>UPDATE [PluginInfo] SET [PluginId] = @PluginId, [Name] = @Name, [Version] = @Version, [BuildDate] = @BuildDate WHERE (([PluginId] = @Original_PluginId) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_Version = 1 AND [Version] IS NULL) OR ([Version] = @Original_Version)) AND ((@IsNull_BuildDate = 1 AND [BuildDate] IS NULL) OR ([BuildDate] = @Original_BuildDate)));
746	SELECT PluginId, Name, Version, BuildDate FROM PluginInfo WHERE (PluginId = @PluginId)</CommandText>
747	<Parameters>
748	<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@PluginId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PluginId" SourceColumnNullMapping="false" SourceVersion="Current" />
749	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
750	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Version" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Version" SourceColumnNullMapping="false" SourceVersion="Current" />
751	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@BuildDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="BuildDate" SourceColumnNullMapping="false" SourceVersion="Current" />
752	<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_PluginId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PluginId" SourceColumnNullMapping="false" SourceVersion="Original" />
753	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="true" SourceVersion="Original" />
754	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
755	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Version" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Version" SourceColumnNullMapping="true" SourceVersion="Original" />
756	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Version" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Version" SourceColumnNullMapping="false" SourceVersion="Original" />
757	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BuildDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BuildDate" SourceColumnNullMapping="true" SourceVersion="Original" />
758	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_BuildDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="BuildDate" SourceColumnNullMapping="false" SourceVersion="Original" />
759	</Parameters>
760	</DbCommand>
761	</UpdateCommand>
762	</DbSource>
763	</MainSource>
764	<Mappings>
765	<Mapping SourceColumn="PluginId" DataSetColumn="PluginId" />
766	<Mapping SourceColumn="Name" DataSetColumn="Name" />
767	<Mapping SourceColumn="Version" DataSetColumn="Version" />
768	<Mapping SourceColumn="BuildDate" DataSetColumn="BuildDate" />
769	</Mappings>
770	<Sources>
771	<DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="[HeuristicLab.Hive_DBTesting].dbo.PluginInfo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillById" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataById" GeneratorSourceName="FillById" GetMethodModifier="Public" GetMethodName="GetDataById" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataById" UserSourceName="FillById">
772	<SelectCommand>
773	<DbCommand CommandType="Text" ModifiedByUser="true">
774	<CommandText>SELECT BuildDate, Name, PluginId, Version FROM PluginInfo WHERE (PluginId = @Id)</CommandText>
775	<Parameters>
776	<Parameter AllowDbNull="false" AutogeneratedName="Id" ColumnName="PluginId" DataSourceName="[HeuristicLab.Hive_DBTesting].dbo.PluginInfo" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="PluginId" SourceColumnNullMapping="false" SourceVersion="Current" />
777	</Parameters>
778	</DbCommand>
779	</SelectCommand>
780	</DbSource>
781	<DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="[HeuristicLab.Hive_DBTesting].dbo.PluginInfo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByNameVersionBuilddate" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByNameVersionBuilddate" GeneratorSourceName="FillByNameVersionBuilddate" GetMethodModifier="Public" GetMethodName="GetDataByNameVersionBuilddate" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByNameVersionBuilddate" UserSourceName="FillByNameVersionBuilddate">
782	<SelectCommand>
783	<DbCommand CommandType="Text" ModifiedByUser="true">
784	<CommandText>SELECT BuildDate, Name, PluginId, Version FROM PluginInfo WHERE (Name = @Name) AND (Version = @Version) AND (BuildDate = @BuildDate)</CommandText>
785	<Parameters>
786	<Parameter AllowDbNull="true" AutogeneratedName="Name" ColumnName="Name" DataSourceName="[HeuristicLab.Hive_DBTesting].dbo.PluginInfo" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
787	<Parameter AllowDbNull="true" AutogeneratedName="Version" ColumnName="Version" DataSourceName="[HeuristicLab.Hive_DBTesting].dbo.PluginInfo" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@Version" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="Version" SourceColumnNullMapping="false" SourceVersion="Current" />
788	<Parameter AllowDbNull="true" AutogeneratedName="BuildDate" ColumnName="BuildDate" DataSourceName="[HeuristicLab.Hive_DBTesting].dbo.PluginInfo" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@BuildDate" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="BuildDate" SourceColumnNullMapping="false" SourceVersion="Current" />
789	</Parameters>
790	</DbCommand>
791	</SelectCommand>
792	</DbSource>
793	<DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="[HeuristicLab.Hive_DBTesting].dbo.PluginInfo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByOrphaned" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByOrphaned" GeneratorSourceName="FillByOrphaned" GetMethodModifier="Public" GetMethodName="GetDataByOrphaned" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByOrphaned" UserSourceName="FillByOrphaned">
794	<SelectCommand>
795	<DbCommand CommandType="Text" ModifiedByUser="true">
796	<CommandText>SELECT BuildDate, Name, PluginId, Version FROM PluginInfo WHERE (NOT EXISTS (SELECT JobId, PluginId FROM RequiredPlugins WHERE (PluginId = PluginInfo.PluginId)))</CommandText>
797	<Parameters />
798	</DbCommand>
799	</SelectCommand>
800	</DbSource>
801	</Sources>
802	</TableAdapter>
803	</Tables>
804	<Sources />
805	</DataSource>
806	</xs:appinfo>
807	</xs:annotation>
808	<xs:element name="dsHiveServer" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="dsHiveServer" msprop:Generator_DataSetName="dsHiveServer" msprop:EnableTableAdapterManager="true">
809	<xs:complexType>
810	<xs:choice minOccurs="0" maxOccurs="unbounded">
811	<xs:element name="Client" msprop:Generator_UserTableName="Client" msprop:Generator_RowDeletedName="ClientRowDeleted" msprop:Generator_RowChangedName="ClientRowChanged" msprop:Generator_RowClassName="ClientRow" msprop:Generator_RowChangingName="ClientRowChanging" msprop:Generator_RowEvArgName="ClientRowChangeEvent" msprop:Generator_RowEvHandlerName="ClientRowChangeEventHandler" msprop:Generator_TableClassName="ClientDataTable" msprop:Generator_TableVarName="tableClient" msprop:Generator_RowDeletingName="ClientRowDeleting" msprop:Generator_TablePropName="Client">
812	<xs:complexType>
813	<xs:sequence>
814	<xs:element name="ResourceId" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="ResourceId" msprop:Generator_ColumnPropNameInRow="ResourceId" msprop:Generator_ColumnVarNameInTable="columnResourceId" msprop:Generator_ColumnPropNameInTable="ResourceIdColumn" type="xs:string" />
815	<xs:element name="CPUSpeed" msprop:Generator_UserColumnName="CPUSpeed" msprop:Generator_ColumnPropNameInRow="CPUSpeed" msprop:Generator_ColumnVarNameInTable="columnCPUSpeed" msprop:Generator_ColumnPropNameInTable="CPUSpeedColumn" type="xs:int" minOccurs="0" />
816	<xs:element name="Memory" msprop:Generator_UserColumnName="Memory" msprop:Generator_ColumnPropNameInRow="Memory" msprop:Generator_ColumnVarNameInTable="columnMemory" msprop:Generator_ColumnPropNameInTable="MemoryColumn" type="xs:int" minOccurs="0" />
817	<xs:element name="Login" msprop:Generator_UserColumnName="Login" msprop:Generator_ColumnPropNameInRow="Login" msprop:Generator_ColumnVarNameInTable="columnLogin" msprop:Generator_ColumnPropNameInTable="LoginColumn" type="xs:dateTime" minOccurs="0" />
818	<xs:element name="Status" msprop:Generator_UserColumnName="Status" msprop:Generator_ColumnPropNameInRow="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInTable="StatusColumn" minOccurs="0">
819	<xs:simpleType>
820	<xs:restriction base="xs:string">
821	<xs:maxLength value="18" />
822	</xs:restriction>
823	</xs:simpleType>
824	</xs:element>
825	<xs:element name="ClientConfigId" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="ClientConfigId" msprop:Generator_ColumnPropNameInRow="ClientConfigId" msprop:Generator_ColumnVarNameInTable="columnClientConfigId" msprop:Generator_ColumnPropNameInTable="ClientConfigIdColumn" type="xs:string" minOccurs="0" />
826	<xs:element name="NumberOfCores" msprop:Generator_UserColumnName="NumberOfCores" msprop:Generator_ColumnPropNameInRow="NumberOfCores" msprop:Generator_ColumnVarNameInTable="columnNumberOfCores" msprop:Generator_ColumnPropNameInTable="NumberOfCoresColumn" type="xs:int" minOccurs="0" />
827	<xs:element name="NumberOfFreeCores" msprop:Generator_UserColumnName="NumberOfFreeCores" msprop:Generator_ColumnVarNameInTable="columnNumberOfFreeCores" msprop:Generator_ColumnPropNameInRow="NumberOfFreeCores" msprop:Generator_ColumnPropNameInTable="NumberOfFreeCoresColumn" type="xs:int" minOccurs="0" />
828	<xs:element name="FreeMemory" msprop:Generator_UserColumnName="FreeMemory" msprop:Generator_ColumnVarNameInTable="columnFreeMemory" msprop:Generator_ColumnPropNameInRow="FreeMemory" msprop:Generator_ColumnPropNameInTable="FreeMemoryColumn" type="xs:int" minOccurs="0" />
829	</xs:sequence>
830	</xs:complexType>
831	</xs:element>
832	<xs:element name="Resource" msprop:Generator_UserTableName="Resource" msprop:Generator_RowDeletedName="ResourceRowDeleted" msprop:Generator_RowChangedName="ResourceRowChanged" msprop:Generator_RowClassName="ResourceRow" msprop:Generator_RowChangingName="ResourceRowChanging" msprop:Generator_RowEvArgName="ResourceRowChangeEvent" msprop:Generator_RowEvHandlerName="ResourceRowChangeEventHandler" msprop:Generator_TableClassName="ResourceDataTable" msprop:Generator_TableVarName="tableResource" msprop:Generator_RowDeletingName="ResourceRowDeleting" msprop:Generator_TablePropName="Resource">
833	<xs:complexType>
834	<xs:sequence>
835	<xs:element name="ResourceId" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="ResourceId" msprop:Generator_ColumnPropNameInRow="ResourceId" msprop:Generator_ColumnVarNameInTable="columnResourceId" msprop:Generator_ColumnPropNameInTable="ResourceIdColumn" type="xs:string" />
836	<xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn" minOccurs="0">
837	<xs:simpleType>
838	<xs:restriction base="xs:string">
839	<xs:maxLength value="100" />
840	</xs:restriction>
841	</xs:simpleType>
842	</xs:element>
843	</xs:sequence>
844	</xs:complexType>
845	</xs:element>
846	<xs:element name="ClientGroup" msprop:Generator_UserTableName="ClientGroup" msprop:Generator_RowDeletedName="ClientGroupRowDeleted" msprop:Generator_RowChangedName="ClientGroupRowChanged" msprop:Generator_RowClassName="ClientGroupRow" msprop:Generator_RowChangingName="ClientGroupRowChanging" msprop:Generator_RowEvArgName="ClientGroupRowChangeEvent" msprop:Generator_RowEvHandlerName="ClientGroupRowChangeEventHandler" msprop:Generator_TableClassName="ClientGroupDataTable" msprop:Generator_TableVarName="tableClientGroup" msprop:Generator_RowDeletingName="ClientGroupRowDeleting" msprop:Generator_TablePropName="ClientGroup">
847	<xs:complexType>
848	<xs:sequence>
849	<xs:element name="ResourceId" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="ResourceId" msprop:Generator_ColumnPropNameInRow="ResourceId" msprop:Generator_ColumnVarNameInTable="columnResourceId" msprop:Generator_ColumnPropNameInTable="ResourceIdColumn" type="xs:string" />
850	</xs:sequence>
851	</xs:complexType>
852	</xs:element>
853	<xs:element name="ClientGroup_Resource" msprop:Generator_UserTableName="ClientGroup_Resource" msprop:Generator_RowDeletedName="ClientGroup_ResourceRowDeleted" msprop:Generator_RowChangedName="ClientGroup_ResourceRowChanged" msprop:Generator_RowClassName="ClientGroup_ResourceRow" msprop:Generator_RowChangingName="ClientGroup_ResourceRowChanging" msprop:Generator_RowEvArgName="ClientGroup_ResourceRowChangeEvent" msprop:Generator_RowEvHandlerName="ClientGroup_ResourceRowChangeEventHandler" msprop:Generator_TableClassName="ClientGroup_ResourceDataTable" msprop:Generator_TableVarName="tableClientGroup_Resource" msprop:Generator_RowDeletingName="ClientGroup_ResourceRowDeleting" msprop:Generator_TablePropName="ClientGroup_Resource">
854	<xs:complexType>
855	<xs:sequence>
856	<xs:element name="ClientGroupId" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="ClientGroupId" msprop:Generator_ColumnVarNameInTable="columnClientGroupId" msprop:Generator_ColumnPropNameInRow="ClientGroupId" msprop:Generator_ColumnPropNameInTable="ClientGroupIdColumn" type="xs:string" />
857	<xs:element name="ResourceId" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="ResourceId" msprop:Generator_ColumnVarNameInTable="columnResourceId" msprop:Generator_ColumnPropNameInRow="ResourceId" msprop:Generator_ColumnPropNameInTable="ResourceIdColumn" type="xs:string" />
858	</xs:sequence>
859	</xs:complexType>
860	</xs:element>
861	<xs:element name="Job" msprop:Generator_UserTableName="Job" msprop:Generator_RowDeletedName="JobRowDeleted" msprop:Generator_RowChangedName="JobRowChanged" msprop:Generator_RowClassName="JobRow" msprop:Generator_RowChangingName="JobRowChanging" msprop:Generator_RowEvArgName="JobRowChangeEvent" msprop:Generator_RowEvHandlerName="JobRowChangeEventHandler" msprop:Generator_TableClassName="JobDataTable" msprop:Generator_TableVarName="tableJob" msprop:Generator_RowDeletingName="JobRowDeleting" msprop:Generator_TablePropName="Job">
862	<xs:complexType>
863	<xs:sequence>
864	<xs:element name="JobId" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="JobId" msprop:Generator_ColumnVarNameInTable="columnJobId" msprop:Generator_ColumnPropNameInRow="JobId" msprop:Generator_ColumnPropNameInTable="JobIdColumn" type="xs:string" />
865	<xs:element name="ParentJobId" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="ParentJobId" msprop:Generator_ColumnVarNameInTable="columnParentJobId" msprop:Generator_ColumnPropNameInRow="ParentJobId" msprop:Generator_ColumnPropNameInTable="ParentJobIdColumn" type="xs:string" minOccurs="0" />
866	<xs:element name="JobState" msprop:Generator_UserColumnName="JobState" msprop:Generator_ColumnVarNameInTable="columnJobState" msprop:Generator_ColumnPropNameInRow="JobState" msprop:Generator_ColumnPropNameInTable="JobStateColumn" minOccurs="0">
867	<xs:simpleType>
868	<xs:restriction base="xs:string">
869	<xs:maxLength value="18" />
870	</xs:restriction>
871	</xs:simpleType>
872	</xs:element>
873	<xs:element name="ResourceId" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="ResourceId" msprop:Generator_ColumnVarNameInTable="columnResourceId" msprop:Generator_ColumnPropNameInRow="ResourceId" msprop:Generator_ColumnPropNameInTable="ResourceIdColumn" type="xs:string" minOccurs="0" />
874	<xs:element name="Percentage" msprop:Generator_UserColumnName="Percentage" msprop:Generator_ColumnVarNameInTable="columnPercentage" msprop:Generator_ColumnPropNameInRow="Percentage" msprop:Generator_ColumnPropNameInTable="PercentageColumn" type="xs:double" minOccurs="0" />
875	<xs:element name="SerializedJob" msprop:Generator_UserColumnName="SerializedJob" msprop:Generator_ColumnVarNameInTable="columnSerializedJob" msprop:Generator_ColumnPropNameInRow="SerializedJob" msprop:Generator_ColumnPropNameInTable="SerializedJobColumn" type="xs:base64Binary" minOccurs="0" />
876	<xs:element name="DateCreated" msprop:Generator_UserColumnName="DateCreated" msprop:Generator_ColumnVarNameInTable="columnDateCreated" msprop:Generator_ColumnPropNameInRow="DateCreated" msprop:Generator_ColumnPropNameInTable="DateCreatedColumn" type="xs:dateTime" minOccurs="0" />
877	<xs:element name="DateCalculated" msprop:Generator_UserColumnName="DateCalculated" msprop:Generator_ColumnVarNameInTable="columnDateCalculated" msprop:Generator_ColumnPropNameInRow="DateCalculated" msprop:Generator_ColumnPropNameInTable="DateCalculatedColumn" type="xs:dateTime" minOccurs="0" />
878	<xs:element name="Priority" msprop:Generator_UserColumnName="Priority" msprop:Generator_ColumnVarNameInTable="columnPriority" msprop:Generator_ColumnPropNameInRow="Priority" msprop:Generator_ColumnPropNameInTable="PriorityColumn" type="xs:int" minOccurs="0" />
879	<xs:element name="ProjectId" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="ProjectId" msprop:Generator_ColumnVarNameInTable="columnProjectId" msprop:Generator_ColumnPropNameInRow="ProjectId" msprop:Generator_ColumnPropNameInTable="ProjectIdColumn" type="xs:string" minOccurs="0" />
880	<xs:element name="UserId" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="UserId" msprop:Generator_ColumnVarNameInTable="columnUserId" msprop:Generator_ColumnPropNameInRow="UserId" msprop:Generator_ColumnPropNameInTable="UserIdColumn" type="xs:string" minOccurs="0" />
881	<xs:element name="CoresNeeded" msprop:Generator_UserColumnName="CoresNeeded" msprop:Generator_ColumnVarNameInTable="columnCoresNeeded" msprop:Generator_ColumnPropNameInRow="CoresNeeded" msprop:Generator_ColumnPropNameInTable="CoresNeededColumn" type="xs:int" minOccurs="0" />
882	<xs:element name="MemoryNeeded" msprop:Generator_UserColumnName="MemoryNeeded" msprop:Generator_ColumnVarNameInTable="columnMemoryNeeded" msprop:Generator_ColumnPropNameInRow="MemoryNeeded" msprop:Generator_ColumnPropNameInTable="MemoryNeededColumn" type="xs:int" minOccurs="0" />
883	</xs:sequence>
884	</xs:complexType>
885	</xs:element>
886	<xs:element name="JobResult" msprop:Generator_UserTableName="JobResult" msprop:Generator_RowDeletedName="JobResultRowDeleted" msprop:Generator_RowChangedName="JobResultRowChanged" msprop:Generator_RowClassName="JobResultRow" msprop:Generator_RowChangingName="JobResultRowChanging" msprop:Generator_RowEvArgName="JobResultRowChangeEvent" msprop:Generator_RowEvHandlerName="JobResultRowChangeEventHandler" msprop:Generator_TableClassName="JobResultDataTable" msprop:Generator_TableVarName="tableJobResult" msprop:Generator_RowDeletingName="JobResultRowDeleting" msprop:Generator_TablePropName="JobResult">
887	<xs:complexType>
888	<xs:sequence>
889	<xs:element name="JobResultId" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="JobResultId" msprop:Generator_ColumnVarNameInTable="columnJobResultId" msprop:Generator_ColumnPropNameInRow="JobResultId" msprop:Generator_ColumnPropNameInTable="JobResultIdColumn" type="xs:string" />
890	<xs:element name="JobId" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="JobId" msprop:Generator_ColumnVarNameInTable="columnJobId" msprop:Generator_ColumnPropNameInRow="JobId" msprop:Generator_ColumnPropNameInTable="JobIdColumn" type="xs:string" minOccurs="0" />
891	<xs:element name="JobResult" msprop:Generator_UserColumnName="JobResult" msprop:Generator_ColumnVarNameInTable="columnJobResult" msprop:Generator_ColumnPropNameInRow="JobResult" msprop:Generator_ColumnPropNameInTable="JobResultColumn" type="xs:base64Binary" minOccurs="0" />
892	<xs:element name="Message" msprop:Generator_UserColumnName="Message" msprop:Generator_ColumnVarNameInTable="columnMessage" msprop:Generator_ColumnPropNameInRow="Message" msprop:Generator_ColumnPropNameInTable="MessageColumn" minOccurs="0">
893	<xs:simpleType>
894	<xs:restriction base="xs:string">
895	<xs:maxLength value="2147483647" />
896	</xs:restriction>
897	</xs:simpleType>
898	</xs:element>
899	<xs:element name="Percentage" msprop:Generator_UserColumnName="Percentage" msprop:Generator_ColumnVarNameInTable="columnPercentage" msprop:Generator_ColumnPropNameInRow="Percentage" msprop:Generator_ColumnPropNameInTable="PercentageColumn" type="xs:double" minOccurs="0" />
900	<xs:element name="ResourceId" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="ResourceId" msprop:Generator_ColumnVarNameInTable="columnResourceId" msprop:Generator_ColumnPropNameInRow="ResourceId" msprop:Generator_ColumnPropNameInTable="ResourceIdColumn" type="xs:string" minOccurs="0" />
901	<xs:element name="DateFinished" msprop:Generator_UserColumnName="DateFinished" msprop:Generator_ColumnVarNameInTable="columnDateFinished" msprop:Generator_ColumnPropNameInRow="DateFinished" msprop:Generator_ColumnPropNameInTable="DateFinishedColumn" type="xs:dateTime" minOccurs="0" />
902	</xs:sequence>
903	</xs:complexType>
904	</xs:element>
905	<xs:element name="RequiredPlugins" msprop:Generator_UserTableName="RequiredPlugins" msprop:Generator_RowDeletedName="RequiredPluginsRowDeleted" msprop:Generator_RowChangedName="RequiredPluginsRowChanged" msprop:Generator_RowClassName="RequiredPluginsRow" msprop:Generator_RowChangingName="RequiredPluginsRowChanging" msprop:Generator_RowEvArgName="RequiredPluginsRowChangeEvent" msprop:Generator_RowEvHandlerName="RequiredPluginsRowChangeEventHandler" msprop:Generator_TableClassName="RequiredPluginsDataTable" msprop:Generator_TableVarName="tableRequiredPlugins" msprop:Generator_RowDeletingName="RequiredPluginsRowDeleting" msprop:Generator_TablePropName="RequiredPlugins">
906	<xs:complexType>
907	<xs:sequence>
908	<xs:element name="JobId" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="JobId" msprop:Generator_ColumnVarNameInTable="columnJobId" msprop:Generator_ColumnPropNameInRow="JobId" msprop:Generator_ColumnPropNameInTable="JobIdColumn" type="xs:string" />
909	<xs:element name="PluginId" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="PluginId" msprop:Generator_ColumnVarNameInTable="columnPluginId" msprop:Generator_ColumnPropNameInRow="PluginId" msprop:Generator_ColumnPropNameInTable="PluginIdColumn" type="xs:string" />
910	</xs:sequence>
911	</xs:complexType>
912	</xs:element>
913	<xs:element name="PluginInfo" msprop:Generator_UserTableName="PluginInfo" msprop:Generator_RowDeletedName="PluginInfoRowDeleted" msprop:Generator_RowChangedName="PluginInfoRowChanged" msprop:Generator_RowClassName="PluginInfoRow" msprop:Generator_RowChangingName="PluginInfoRowChanging" msprop:Generator_RowEvArgName="PluginInfoRowChangeEvent" msprop:Generator_RowEvHandlerName="PluginInfoRowChangeEventHandler" msprop:Generator_TableClassName="PluginInfoDataTable" msprop:Generator_TableVarName="tablePluginInfo" msprop:Generator_RowDeletingName="PluginInfoRowDeleting" msprop:Generator_TablePropName="PluginInfo">
914	<xs:complexType>
915	<xs:sequence>
916	<xs:element name="PluginId" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="PluginId" msprop:Generator_ColumnPropNameInRow="PluginId" msprop:Generator_ColumnVarNameInTable="columnPluginId" msprop:Generator_ColumnPropNameInTable="PluginIdColumn" type="xs:string" />
917	<xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn" minOccurs="0">
918	<xs:simpleType>
919	<xs:restriction base="xs:string">
920	<xs:maxLength value="100" />
921	</xs:restriction>
922	</xs:simpleType>
923	</xs:element>
924	<xs:element name="Version" msprop:Generator_UserColumnName="Version" msprop:Generator_ColumnPropNameInRow="Version" msprop:Generator_ColumnVarNameInTable="columnVersion" msprop:Generator_ColumnPropNameInTable="VersionColumn" minOccurs="0">
925	<xs:simpleType>
926	<xs:restriction base="xs:string">
927	<xs:maxLength value="100" />
928	</xs:restriction>
929	</xs:simpleType>
930	</xs:element>
931	<xs:element name="BuildDate" msprop:Generator_UserColumnName="BuildDate" msprop:Generator_ColumnPropNameInRow="BuildDate" msprop:Generator_ColumnVarNameInTable="columnBuildDate" msprop:Generator_ColumnPropNameInTable="BuildDateColumn" type="xs:dateTime" minOccurs="0" />
932	</xs:sequence>
933	</xs:complexType>
934	</xs:element>
935	</xs:choice>
936	</xs:complexType>
937	<xs:unique name="Constraint1" msdata:PrimaryKey="true">
938	<xs:selector xpath=".//mstns:Client" />
939	<xs:field xpath="mstns:ResourceId" />
940	</xs:unique>
941	<xs:unique name="Resource_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
942	<xs:selector xpath=".//mstns:Resource" />
943	<xs:field xpath="mstns:ResourceId" />
944	</xs:unique>
945	<xs:unique name="ClientGroup_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
946	<xs:selector xpath=".//mstns:ClientGroup" />
947	<xs:field xpath="mstns:ResourceId" />
948	</xs:unique>
949	<xs:unique name="ClientGroup_Resource_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
950	<xs:selector xpath=".//mstns:ClientGroup_Resource" />
951	<xs:field xpath="mstns:ClientGroupId" />
952	<xs:field xpath="mstns:ResourceId" />
953	</xs:unique>
954	<xs:unique name="Job_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
955	<xs:selector xpath=".//mstns:Job" />
956	<xs:field xpath="mstns:JobId" />
957	</xs:unique>
958	<xs:unique name="JobResult_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
959	<xs:selector xpath=".//mstns:JobResult" />
960	<xs:field xpath="mstns:JobResultId" />
961	</xs:unique>
962	<xs:unique name="RequiredPlugins_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
963	<xs:selector xpath=".//mstns:RequiredPlugins" />
964	<xs:field xpath="mstns:JobId" />
965	<xs:field xpath="mstns:PluginId" />
966	</xs:unique>
967	<xs:unique name="PluginInfo_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
968	<xs:selector xpath=".//mstns:PluginInfo" />
969	<xs:field xpath="mstns:PluginId" />
970	</xs:unique>
971	</xs:element>
972	<xs:annotation>
973	<xs:appinfo>
974	<msdata:Relationship name="Client_is_a_Resource" msdata:parent="Resource" msdata:child="Client" msdata:parentkey="ResourceId" msdata:childkey="ResourceId" msprop:Generator_UserRelationName="Client_is_a_Resource" msprop:Generator_RelationVarName="relationClient_is_a_Resource" msprop:Generator_UserChildTable="Client" msprop:Generator_UserParentTable="Resource" msprop:Generator_ParentPropName="ResourceRow" msprop:Generator_ChildPropName="GetClientRows" />
975	<msdata:Relationship name="ClientGroup_is_a_Resource" msdata:parent="Resource" msdata:child="ClientGroup" msdata:parentkey="ResourceId" msdata:childkey="ResourceId" msprop:Generator_UserRelationName="ClientGroup_is_a_Resource" msprop:Generator_RelationVarName="relationClientGroup_is_a_Resource" msprop:Generator_UserChildTable="ClientGroup" msprop:Generator_UserParentTable="Resource" msprop:Generator_ParentPropName="ResourceRow" msprop:Generator_ChildPropName="GetClientGroupRows" />
976	<msdata:Relationship name="R_21" msdata:parent="Client" msdata:child="Job" msdata:parentkey="ResourceId" msdata:childkey="ResourceId" msprop:Generator_UserRelationName="R_21" msprop:Generator_RelationVarName="relationR_21" msprop:Generator_UserChildTable="Job" msprop:Generator_UserParentTable="Client" msprop:Generator_ParentPropName="ClientRow" msprop:Generator_ChildPropName="GetJobRows" />
977	<msdata:Relationship name="R_14" msdata:parent="Job" msdata:child="JobResult" msdata:parentkey="JobId" msdata:childkey="JobId" msprop:Generator_UserRelationName="R_14" msprop:Generator_RelationVarName="relationR_14" msprop:Generator_UserChildTable="JobResult" msprop:Generator_UserParentTable="Job" msprop:Generator_ParentPropName="JobRow" msprop:Generator_ChildPropName="GetJobResultRows" />
978	<msdata:Relationship name="R_51" msdata:parent="Job" msdata:child="RequiredPlugins" msdata:parentkey="JobId" msdata:childkey="JobId" msprop:Generator_UserRelationName="R_51" msprop:Generator_RelationVarName="relationR_51" msprop:Generator_UserChildTable="RequiredPlugins" msprop:Generator_UserParentTable="Job" msprop:Generator_ParentPropName="JobRow" msprop:Generator_ChildPropName="GetRequiredPluginsRows" />
979	<msdata:Relationship name="R_54" msdata:parent="PluginInfo" msdata:child="RequiredPlugins" msdata:parentkey="PluginId" msdata:childkey="PluginId" msprop:Generator_UserRelationName="R_54" msprop:Generator_RelationVarName="relationR_54" msprop:Generator_UserChildTable="RequiredPlugins" msprop:Generator_UserParentTable="PluginInfo" msprop:Generator_ParentPropName="PluginInfoRow" msprop:Generator_ChildPropName="GetRequiredPluginsRows" />
980	<msdata:Relationship name="R_52" msdata:parent="Resource" msdata:child="ClientGroup_Resource" msdata:parentkey="ResourceId" msdata:childkey="ClientGroupId" msprop:Generator_UserRelationName="R_52" msprop:Generator_RelationVarName="relationR_52" msprop:Generator_UserChildTable="ClientGroup_Resource" msprop:Generator_UserParentTable="Resource" msprop:Generator_ParentPropName="ResourceRow" msprop:Generator_ChildPropName="GetClientGroup_ResourceRows" />
981	<msdata:Relationship name="R_59" msdata:parent="Resource" msdata:child="ClientGroup_Resource" msdata:parentkey="ResourceId" msdata:childkey="ResourceId" msprop:Generator_UserRelationName="R_59" msprop:Generator_RelationVarName="relationR_59" msprop:Generator_UserChildTable="ClientGroup_Resource" msprop:Generator_UserParentTable="Resource" msprop:Generator_ParentPropName="ResourceRowByR_59" msprop:Generator_ChildPropName="GetClientGroup_ResourceRowsByR_59" />
982	<msdata:Relationship name="R_47" msdata:parent="Client" msdata:child="JobResult" msdata:parentkey="ResourceId" msdata:childkey="ResourceId" msprop:Generator_UserRelationName="R_47" msprop:Generator_RelationVarName="relationR_47" msprop:Generator_UserChildTable="JobResult" msprop:Generator_UserParentTable="Client" msprop:Generator_ParentPropName="ClientRow" msprop:Generator_ChildPropName="GetJobResultRows" />
983	</xs:appinfo>
984	</xs:annotation>
985	</xs:schema>

Note: See TracBrowser for help on using the repository browser.

Download in other formats:

Update cookies preferences