Context Navigation

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

Visit:

Last change on this file since 2086 was 2086, checked in by svonolfe, 15 years ago
Further improved handling of job objects (#372)
File size: 188.8 KB

Rev	Line
[826]	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>
[1449]	10	<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ClientTableAdapter" GeneratorDataComponentClassName="ClientTableAdapter" Name="Client" UserDataComponentName="ClientTableAdapter">
	11	<MainSource>
[1505]	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">
[1449]	13	<DeleteCommand>
	14	<DbCommand CommandType="Text" ModifiedByUser="false">
[1505]	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>
[1449]	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" />
[1505]	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" />
[1449]	34	</Parameters>
	35	</DbCommand>
	36	</DeleteCommand>
	37	<InsertCommand>
	38	<DbCommand CommandType="Text" ModifiedByUser="false">
[1505]	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>
[1449]	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" />
[1505]	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" />
[1449]	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">
[1505]	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>
[1449]	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" />
[1505]	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" />
[1449]	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" />
[1505]	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" />
[1449]	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" />
[1505]	104	<Mapping SourceColumn="NumberOfFreeCores" DataSetColumn="NumberOfFreeCores" />
	105	<Mapping SourceColumn="FreeMemory" DataSetColumn="FreeMemory" />
[1449]	106	</Mappings>
	107	<Sources>
[1505]	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">
[1449]	109	<SelectCommand>
	110	<DbCommand CommandType="Text" ModifiedByUser="true">
[1505]	111	<CommandText>SELECT CPUSpeed, ClientConfigId, FreeMemory, Login, Memory, NumberOfCores, NumberOfFreeCores, ResourceId, Status FROM Client WHERE (Status <> 'offline')</CommandText>
[1449]	112	<Parameters />
	113	</DbCommand>
	114	</SelectCommand>
	115	</DbSource>
[1634]	116	<DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="[HeuristicLab.Hive_DBTesting].dbo.Client" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByGroupless" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByGroupless" GeneratorSourceName="FillByGroupless" GetMethodModifier="Public" GetMethodName="GetDataByGroupless" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByGroupless" UserSourceName="FillByGroupless">
	117	<SelectCommand>
	118	<DbCommand CommandType="Text" ModifiedByUser="true">
	119	<CommandText>SELECT * FROM dbo.Client WHERE NOT EXISTS (SELECT * FROM dbo.ClientGroup_Resource WHERE ResourceId = dbo.Client.ResourceId)</CommandText>
	120	<Parameters />
	121	</DbCommand>
	122	</SelectCommand>
	123	</DbSource>
[1505]	124	<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">
[1449]	125	<SelectCommand>
	126	<DbCommand CommandType="Text" ModifiedByUser="true">
[1505]	127	<CommandText>SELECT CPUSpeed, ClientConfigId, FreeMemory, Login, Memory, NumberOfCores, NumberOfFreeCores, ResourceId, Status FROM Client WHERE (ResourceId = @Id)</CommandText>
[1449]	128	<Parameters>
	129	<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" />
	130	</Parameters>
	131	</DbCommand>
	132	</SelectCommand>
	133	</DbSource>
	134	</Sources>
	135	</TableAdapter>
[845]	136	<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ResourceTableAdapter" GeneratorDataComponentClassName="ResourceTableAdapter" Name="Resource" UserDataComponentName="ResourceTableAdapter">
	137	<MainSource>
[1601]	138	<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">
[845]	139	<DeleteCommand>
	140	<DbCommand CommandType="Text" ModifiedByUser="false">
[1601]	141	<CommandText>DELETE FROM [dbo].[Resource] WHERE (([ResourceId] = @Original_ResourceId))</CommandText>
[845]	142	<Parameters>
[1449]	143	<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" />
[845]	144	</Parameters>
	145	</DbCommand>
	146	</DeleteCommand>
	147	<InsertCommand>
	148	<DbCommand CommandType="Text" ModifiedByUser="false">
[1449]	149	<CommandText>INSERT INTO [dbo].[Resource] ([ResourceId], [Name]) VALUES (@ResourceId, @Name);
	150	SELECT ResourceId, Name FROM Resource WHERE (ResourceId = @ResourceId)</CommandText>
[845]	151	<Parameters>
[1449]	152	<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" />
[845]	153	<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" />
	154	</Parameters>
	155	</DbCommand>
	156	</InsertCommand>
	157	<SelectCommand>
[1449]	158	<DbCommand CommandType="Text" ModifiedByUser="true">
	159	<CommandText>SELECT * FROM dbo.Resource</CommandText>
[845]	160	<Parameters />
	161	</DbCommand>
	162	</SelectCommand>
	163	<UpdateCommand>
	164	<DbCommand CommandType="Text" ModifiedByUser="false">
[1601]	165	<CommandText>UPDATE [dbo].[Resource] SET [ResourceId] = @ResourceId, [Name] = @Name WHERE (([ResourceId] = @Original_ResourceId));
[845]	166	SELECT ResourceId, Name FROM Resource WHERE (ResourceId = @ResourceId)</CommandText>
	167	<Parameters>
[1449]	168	<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" />
[845]	169	<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" />
[1449]	170	<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" />
[845]	171	</Parameters>
	172	</DbCommand>
	173	</UpdateCommand>
	174	</DbSource>
	175	</MainSource>
	176	<Mappings>
	177	<Mapping SourceColumn="ResourceId" DataSetColumn="ResourceId" />
	178	<Mapping SourceColumn="Name" DataSetColumn="Name" />
	179	</Mappings>
	180	<Sources>
[1601]	181	<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">
[995]	182	<SelectCommand>
	183	<DbCommand CommandType="Text" ModifiedByUser="true">
[1601]	184	<CommandText>SELECT Resource.Name, Resource.ResourceId FROM Resource INNER JOIN Client ON Resource.ResourceId = Client.ResourceId WHERE (Client.Status <> 'offline')</CommandText>
[995]	185	<Parameters />
	186	</DbCommand>
	187	</SelectCommand>
	188	</DbSource>
[1601]	189	<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">
[845]	190	<SelectCommand>
	191	<DbCommand CommandType="Text" ModifiedByUser="true">
[1601]	192	<CommandText>SELECT Name, ResourceId FROM Resource WHERE (ResourceId = @ID)</CommandText>
[845]	193	<Parameters>
[1449]	194	<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" />
[845]	195	</Parameters>
	196	</DbCommand>
	197	</SelectCommand>
	198	</DbSource>
[1601]	199	<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">
[995]	200	<SelectCommand>
	201	<DbCommand CommandType="Text" ModifiedByUser="true">
[1601]	202	<CommandText>SELECT Name, ResourceId FROM Resource WHERE (Name = @Name)</CommandText>
[995]	203	<Parameters>
[1449]	204	<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" />
[995]	205	</Parameters>
	206	</DbCommand>
	207	</SelectCommand>
	208	</DbSource>
[845]	209	</Sources>
	210	</TableAdapter>
[1449]	211	<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ClientGroupTableAdapter" GeneratorDataComponentClassName="ClientGroupTableAdapter" Name="ClientGroup" UserDataComponentName="ClientGroupTableAdapter">
[826]	212	<MainSource>
[1636]	213	<DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="[HeuristicLab.Hive_DBTesting].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">
[826]	214	<DeleteCommand>
	215	<DbCommand CommandType="Text" ModifiedByUser="false">
[1449]	216	<CommandText>DELETE FROM [dbo].[ClientGroup] WHERE (([ResourceId] = @Original_ResourceId))</CommandText>
[826]	217	<Parameters>
[1449]	218	<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" />
[826]	219	</Parameters>
	220	</DbCommand>
	221	</DeleteCommand>
	222	<InsertCommand>
	223	<DbCommand CommandType="Text" ModifiedByUser="false">
[1449]	224	<CommandText>INSERT INTO [dbo].[ClientGroup] ([ResourceId]) VALUES (@ResourceId);
	225	SELECT ResourceId FROM ClientGroup WHERE (ResourceId = @ResourceId)</CommandText>
[826]	226	<Parameters>
[1449]	227	<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" />
[826]	228	</Parameters>
	229	</DbCommand>
	230	</InsertCommand>
	231	<SelectCommand>
[1449]	232	<DbCommand CommandType="Text" ModifiedByUser="true">
[1636]	233	<CommandText>SELECT * FROM dbo.ClientGroup WHERE NOT EXISTS (SELECT * FROM dbo.ClientGroup_Resource WHERE ResourceId = dbo.ClientGroup.ResourceId)</CommandText>
[826]	234	<Parameters />
	235	</DbCommand>
	236	</SelectCommand>
	237	<UpdateCommand>
	238	<DbCommand CommandType="Text" ModifiedByUser="false">
[1449]	239	<CommandText>UPDATE [dbo].[ClientGroup] SET [ResourceId] = @ResourceId WHERE (([ResourceId] = @Original_ResourceId));
	240	SELECT ResourceId FROM ClientGroup WHERE (ResourceId = @ResourceId)</CommandText>
[826]	241	<Parameters>
[1449]	242	<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" />
	243	<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" />
[826]	244	</Parameters>
	245	</DbCommand>
	246	</UpdateCommand>
	247	</DbSource>
	248	</MainSource>
	249	<Mappings>
	250	<Mapping SourceColumn="ResourceId" DataSetColumn="ResourceId" />
	251	</Mappings>
	252	<Sources>
[1449]	253	<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">
[995]	254	<SelectCommand>
	255	<DbCommand CommandType="Text" ModifiedByUser="true">
[1449]	256	<CommandText>SELECT * FROM dbo.ClientGroup WHERE ResourceId = @Id</CommandText>
[826]	257	<Parameters>
[1449]	258	<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" />
[826]	259	</Parameters>
	260	</DbCommand>
	261	</SelectCommand>
	262	</DbSource>
[1756]	263	<DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="[HeuristicLab.Hive_DBTesting].dbo.ClientGroup" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByParentsOf" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByParentsOf" GeneratorSourceName="FillByParentsOf" GetMethodModifier="Public" GetMethodName="GetDataByParentsOf" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByParentsOf" UserSourceName="FillByParentsOf">
	264	<SelectCommand>
	265	<DbCommand CommandType="Text" ModifiedByUser="true">
	266	<CommandText>SELECT * FROM ClientGroup WHERE EXISTS (SELECT * FROM ClientGroup_Resource WHERE ClientGroupId = ClientGroup.ResourceId AND ResourceId = @ResourceId)</CommandText>
	267	<Parameters>
	268	<Parameter AllowDbNull="false" AutogeneratedName="ResourceId" ColumnName="ResourceId" DataSourceName="[HeuristicLab.Hive_DBTesting].dbo.ClientGroup" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@ResourceId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="ResourceId" SourceColumnNullMapping="false" SourceVersion="Current" />
	269	</Parameters>
	270	</DbCommand>
	271	</SelectCommand>
	272	</DbSource>
[826]	273	</Sources>
	274	</TableAdapter>
[1449]	275	<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ClientGroup_ResourceTableAdapter" GeneratorDataComponentClassName="ClientGroup_ResourceTableAdapter" Name="ClientGroup_Resource" UserDataComponentName="ClientGroup_ResourceTableAdapter">
[965]	276	<MainSource>
[1505]	277	<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">
[965]	278	<DeleteCommand>
	279	<DbCommand CommandType="Text" ModifiedByUser="false">
[1449]	280	<CommandText>DELETE FROM [dbo].[ClientGroup_Resource] WHERE (([ClientGroupId] = @Original_ClientGroupId) AND ([ResourceId] = @Original_ResourceId))</CommandText>
[965]	281	<Parameters>
[1449]	282	<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" />
	283	<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" />
[965]	284	</Parameters>
	285	</DbCommand>
	286	</DeleteCommand>
	287	<InsertCommand>
	288	<DbCommand CommandType="Text" ModifiedByUser="false">
[1449]	289	<CommandText>INSERT INTO [dbo].[ClientGroup_Resource] ([ClientGroupId], [ResourceId]) VALUES (@ClientGroupId, @ResourceId);
	290	SELECT ClientGroupId, ResourceId FROM ClientGroup_Resource WHERE (ClientGroupId = @ClientGroupId) AND (ResourceId = @ResourceId)</CommandText>
[965]	291	<Parameters>
[1449]	292	<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" />
	293	<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" />
[965]	294	</Parameters>
	295	</DbCommand>
	296	</InsertCommand>
	297	<SelectCommand>
[1449]	298	<DbCommand CommandType="Text" ModifiedByUser="true">
	299	<CommandText>SELECT * FROM dbo.ClientGroup_Resource</CommandText>
[965]	300	<Parameters />
	301	</DbCommand>
	302	</SelectCommand>
	303	<UpdateCommand>
	304	<DbCommand CommandType="Text" ModifiedByUser="false">
[1449]	305	<CommandText>UPDATE [dbo].[ClientGroup_Resource] SET [ClientGroupId] = @ClientGroupId, [ResourceId] = @ResourceId WHERE (([ClientGroupId] = @Original_ClientGroupId) AND ([ResourceId] = @Original_ResourceId));
	306	SELECT ClientGroupId, ResourceId FROM ClientGroup_Resource WHERE (ClientGroupId = @ClientGroupId) AND (ResourceId = @ResourceId)</CommandText>
[965]	307	<Parameters>
[1449]	308	<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" />
	309	<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" />
	310	<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" />
	311	<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" />
[965]	312	</Parameters>
	313	</DbCommand>
	314	</UpdateCommand>
	315	</DbSource>
	316	</MainSource>
	317	<Mappings>
[1449]	318	<Mapping SourceColumn="ClientGroupId" DataSetColumn="ClientGroupId" />
[965]	319	<Mapping SourceColumn="ResourceId" DataSetColumn="ResourceId" />
	320	</Mappings>
[995]	321	<Sources>
[1505]	322	<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">
[995]	323	<SelectCommand>
	324	<DbCommand CommandType="Text" ModifiedByUser="true">
[1505]	325	<CommandText>SELECT ClientGroupId, ResourceId FROM ClientGroup_Resource WHERE (ClientGroupId = @Id)</CommandText>
[995]	326	<Parameters>
[1449]	327	<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" />
[995]	328	</Parameters>
	329	</DbCommand>
	330	</SelectCommand>
	331	</DbSource>
[1505]	332	<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">
[1449]	333	<SelectCommand>
	334	<DbCommand CommandType="Text" ModifiedByUser="true">
[1505]	335	<CommandText>SELECT ClientGroupId, ResourceId FROM ClientGroup_Resource WHERE (ClientGroupId = @ClientGroupId) AND (ResourceId = @ResourceId)</CommandText>
[1449]	336	<Parameters>
	337	<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" />
	338	<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" />
	339	</Parameters>
	340	</DbCommand>
	341	</SelectCommand>
	342	</DbSource>
[1505]	343	<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">
[1449]	344	<SelectCommand>
	345	<DbCommand CommandType="Text" ModifiedByUser="true">
[1505]	346	<CommandText>SELECT ClientGroupId, ResourceId FROM ClientGroup_Resource WHERE (ResourceId = @ResourceId)</CommandText>
[1449]	347	<Parameters>
	348	<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" />
	349	</Parameters>
	350	</DbCommand>
	351	</SelectCommand>
	352	</DbSource>
[995]	353	</Sources>
[965]	354	</TableAdapter>
[971]	355	<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="JobTableAdapter" GeneratorDataComponentClassName="JobTableAdapter" Name="Job" UserDataComponentName="JobTableAdapter">
	356	<MainSource>
[2083]	357	<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">
[971]	358	<DeleteCommand>
	359	<DbCommand CommandType="Text" ModifiedByUser="false">
[2083]	360	<CommandText>DELETE FROM [Job] WHERE (([JobId] = @Original_JobId) AND ((@IsNull_ParentJobId = 1 AND [ParentJobId] IS NULL) OR ([ParentJobId] = @Original_ParentJobId)) 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>
[971]	361	<Parameters>
[1449]	362	<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" />
[971]	363	<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" />
[1449]	364	<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" />
[971]	365	<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" />
[1449]	366	<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" />
[1165]	367	<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" />
	368	<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" />
[1169]	369	<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" />
	370	<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" />
	371	<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" />
	372	<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" />
	373	<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" />
	374	<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" />
[1449]	375	<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" />
	376	<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" />
[1505]	377	<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" />
	378	<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" />
	379	<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" />
	380	<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" />
	381	<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" />
	382	<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" />
[971]	383	</Parameters>
	384	</DbCommand>
	385	</DeleteCommand>
	386	<InsertCommand>
	387	<DbCommand CommandType="Text" ModifiedByUser="false">
[2083]	388	<CommandText>INSERT INTO [Job] ([JobId], [ParentJobId], [ResourceId], [JobState], [Percentage], [DateCreated], [DateCalculated], [Priority], [ProjectId], [UserId], [CoresNeeded], [MemoryNeeded]) VALUES (@JobId, @ParentJobId, @ResourceId, @JobState, @Percentage, @DateCreated, @DateCalculated, @Priority, @ProjectId, @UserId, @CoresNeeded, @MemoryNeeded);
	389	SELECT JobId, ParentJobId, ResourceId, JobState, Percentage, DateCreated, DateCalculated, Priority, ProjectId, UserId, CoresNeeded, MemoryNeeded FROM Job WHERE (JobId = @JobId)</CommandText>
[971]	390	<Parameters>
[1449]	391	<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" />
	392	<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" />
[2083]	393	<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" />
[1092]	394	<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" />
[1449]	395	<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" />
[1169]	396	<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" />
	397	<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" />
	398	<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" />
[1449]	399	<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" />
[1505]	400	<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" />
	401	<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" />
	402	<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" />
[971]	403	</Parameters>
	404	</DbCommand>
	405	</InsertCommand>
	406	<SelectCommand>
[1092]	407	<DbCommand CommandType="Text" ModifiedByUser="true">
[2083]	408	<CommandText>SELECT JobId, ParentJobId, ResourceId, JobState, Percentage, DateCreated, DateCalculated, Priority, ProjectId, UserId, CoresNeeded, MemoryNeeded
	409	FROM Job</CommandText>
	410	<Parameters />
[971]	411	</DbCommand>
	412	</SelectCommand>
	413	<UpdateCommand>
	414	<DbCommand CommandType="Text" ModifiedByUser="false">
[2083]	415	<CommandText>UPDATE [Job] SET [JobId] = @JobId, [ParentJobId] = @ParentJobId, [ResourceId] = @ResourceId, [JobState] = @JobState, [Percentage] = @Percentage, [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_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)));
	416	SELECT JobId, ParentJobId, ResourceId, JobState, Percentage, DateCreated, DateCalculated, Priority, ProjectId, UserId, CoresNeeded, MemoryNeeded FROM Job WHERE (JobId = @JobId)</CommandText>
[971]	417	<Parameters>
[1449]	418	<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" />
	419	<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" />
[2083]	420	<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" />
[1092]	421	<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" />
[1449]	422	<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" />
[1169]	423	<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" />
	424	<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" />
	425	<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" />
[1449]	426	<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" />
[1505]	427	<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" />
	428	<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" />
	429	<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" />
[1449]	430	<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" />
[971]	431	<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" />
[1449]	432	<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" />
[971]	433	<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" />
[1449]	434	<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" />
[1165]	435	<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" />
	436	<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" />
[1169]	437	<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" />
	438	<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" />
	439	<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" />
	440	<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" />
	441	<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" />
	442	<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" />
[1449]	443	<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" />
	444	<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" />
[1505]	445	<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" />
	446	<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" />
	447	<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" />
	448	<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" />
	449	<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" />
	450	<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" />
[971]	451	</Parameters>
	452	</DbCommand>
	453	</UpdateCommand>
	454	</DbSource>
	455	</MainSource>
	456	<Mappings>
	457	<Mapping SourceColumn="JobId" DataSetColumn="JobId" />
	458	<Mapping SourceColumn="ParentJobId" DataSetColumn="ParentJobId" />
[1449]	459	<Mapping SourceColumn="JobState" DataSetColumn="JobState" />
[971]	460	<Mapping SourceColumn="ResourceId" DataSetColumn="ResourceId" />
[1092]	461	<Mapping SourceColumn="Percentage" DataSetColumn="Percentage" />
[1169]	462	<Mapping SourceColumn="DateCreated" DataSetColumn="DateCreated" />
	463	<Mapping SourceColumn="DateCalculated" DataSetColumn="DateCalculated" />
	464	<Mapping SourceColumn="Priority" DataSetColumn="Priority" />
[1449]	465	<Mapping SourceColumn="ProjectId" DataSetColumn="ProjectId" />
	466	<Mapping SourceColumn="UserId" DataSetColumn="UserId" />
[1505]	467	<Mapping SourceColumn="CoresNeeded" DataSetColumn="CoresNeeded" />
	468	<Mapping SourceColumn="MemoryNeeded" DataSetColumn="MemoryNeeded" />
[971]	469	</Mappings>
[995]	470	<Sources>
[1505]	471	<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">
	472	<SelectCommand>
	473	<DbCommand CommandType="Text" ModifiedByUser="true">
[2083]	474	<CommandText>SELECT CoresNeeded, DateCalculated, DateCreated, JobId, JobState, MemoryNeeded, ParentJobId, Percentage, Priority, ProjectId, ResourceId, UserId FROM Job WHERE (JobState = 'calculating' OR JobState = 'abort' OR JobState = 'requestSnapshot ' OR JobState = 'requestSnapshotSent') AND (ResourceId = @ResourceId)</CommandText>
[1166]	475	<Parameters>
[1573]	476	<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" />
[1166]	477	</Parameters>
	478	</DbCommand>
	479	</SelectCommand>
	480	</DbSource>
[1505]	481	<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">
[995]	482	<SelectCommand>
	483	<DbCommand CommandType="Text" ModifiedByUser="true">
[2083]	484	<CommandText>SELECT CoresNeeded, DateCalculated, DateCreated, JobId, JobState, MemoryNeeded, ParentJobId, Percentage, Priority, ProjectId, ResourceId, UserId FROM Job WHERE (ResourceId = @ResourceId)</CommandText>
[995]	485	<Parameters>
[1449]	486	<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" />
[995]	487	</Parameters>
	488	</DbCommand>
	489	</SelectCommand>
	490	</DbSource>
[1505]	491	<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">
[995]	492	<SelectCommand>
	493	<DbCommand CommandType="Text" ModifiedByUser="true">
[2083]	494	<CommandText>SELECT CoresNeeded, DateCalculated, DateCreated, JobId, JobState, MemoryNeeded, ParentJobId, Percentage, Priority, ProjectId, ResourceId, UserId FROM Job WHERE (JobId = @Id)</CommandText>
[995]	495	<Parameters>
[1449]	496	<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" />
[995]	497	</Parameters>
	498	</DbCommand>
	499	</SelectCommand>
	500	</DbSource>
[1505]	501	<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">
[998]	502	<SelectCommand>
	503	<DbCommand CommandType="Text" ModifiedByUser="true">
[2083]	504	<CommandText>SELECT CoresNeeded, DateCalculated, DateCreated, JobId, JobState, MemoryNeeded, ParentJobId, Percentage, Priority, ProjectId, ResourceId, UserId FROM Job WHERE (JobId = @Id)</CommandText>
[998]	505	<Parameters>
[1449]	506	<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" />
[998]	507	</Parameters>
	508	</DbCommand>
	509	</SelectCommand>
	510	</DbSource>
[1505]	511	<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">
[995]	512	<SelectCommand>
	513	<DbCommand CommandType="Text" ModifiedByUser="true">
[2083]	514	<CommandText>SELECT CoresNeeded, DateCalculated, DateCreated, JobId, JobState, MemoryNeeded, ParentJobId, Percentage, Priority, ProjectId, ResourceId, UserId FROM Job WHERE (ParentJobId = @Id)</CommandText>
[995]	515	<Parameters>
[1449]	516	<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" />
[995]	517	</Parameters>
	518	</DbCommand>
	519	</SelectCommand>
	520	</DbSource>
[1947]	521	<DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="[HeuristicLab.Hive_DBTesting].dbo.Job" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByProjectId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByProjectId" GeneratorSourceName="FillByProjectId" GetMethodModifier="Public" GetMethodName="GetDataByProjectId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByProjectId" UserSourceName="FillByProjectId">
	522	<SelectCommand>
	523	<DbCommand CommandType="Text" ModifiedByUser="true">
[2083]	524	<CommandText>SELECT CoresNeeded, DateCalculated, DateCreated, JobId, JobState, MemoryNeeded, ParentJobId, Percentage, Priority, ProjectId, ResourceId, UserId FROM Job WHERE (ProjectId = @ProjectId)</CommandText>
[1947]	525	<Parameters>
	526	<Parameter AllowDbNull="true" AutogeneratedName="ProjectId" ColumnName="ProjectId" DataSourceName="[HeuristicLab.Hive_DBTesting].dbo.Job" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@ProjectId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="ProjectId" SourceColumnNullMapping="false" SourceVersion="Current" />
	527	</Parameters>
	528	</DbCommand>
	529	</SelectCommand>
	530	</DbSource>
[1505]	531	<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">
[995]	532	<SelectCommand>
	533	<DbCommand CommandType="Text" ModifiedByUser="true">
[2083]	534	<CommandText>SELECT CoresNeeded, DateCalculated, DateCreated, JobId, JobState, MemoryNeeded, ParentJobId, Percentage, Priority, ProjectId, ResourceId, UserId FROM Job WHERE (JobState = @State)</CommandText>
[995]	535	<Parameters>
[1449]	536	<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" />
[995]	537	</Parameters>
	538	</DbCommand>
	539	</SelectCommand>
	540	</DbSource>
[2083]	541	<DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="[HeuristicLab.Hive_DBTesting].dbo.Job" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByStateCoresMemoryResource" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByStateCoresMemoryResource" GeneratorSourceName="FillByStateCoresMemoryResource" GetMethodModifier="Public" GetMethodName="GetDataByStateCoresMemoryResource" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByStateCoresMemoryResource" UserSourceName="FillByStateCoresMemoryResource">
	542	<SelectCommand>
	543	<DbCommand CommandType="Text" ModifiedByUser="true">
	544	<CommandText>WITH ClientGroups(ClientGroupId) AS (SELECT ClientGroupId FROM ClientGroup_Resource WHERE (ResourceId = @ResourceId) UNION ALL SELECT g.ClientGroupId FROM ClientGroup_Resource AS g INNER JOIN ClientGroups AS gr ON gr.ClientGroupId = g.ResourceId) SELECT CoresNeeded, DateCalculated, DateCreated, JobId, JobState, MemoryNeeded, ParentJobId, Percentage, Priority, ProjectId, ResourceId, UserId FROM Job WHERE (JobState = @State) AND (CoresNeeded <= @CoresNeeded) AND (MemoryNeeded <= @MemoryNeeded) AND (NOT EXISTS (SELECT ResourceId, JobId FROM AssignedResources WHERE (JobId = Job.JobId))) OR (JobState = @State) AND (CoresNeeded <= @CoresNeeded) AND (MemoryNeeded <= @MemoryNeeded) AND EXISTS (SELECT ResourceId, JobId FROM AssignedResources AS AssignedResources_2 WHERE (JobId = Job.JobId) AND (ResourceId = @ResourceId)) OR (JobState = @State) AND (CoresNeeded <= @CoresNeeded) AND (MemoryNeeded <= @MemoryNeeded) AND EXISTS (SELECT ResourceId, JobId FROM AssignedResources AS AssignedResources_1 WHERE (JobId = Job.JobId) AND (ResourceId IN (SELECT ClientGroupId FROM ClientGroups AS ClientGroups_1))) ORDER BY Priority</CommandText>
	545	<Parameters>
	546	<Parameter AllowDbNull="true" AutogeneratedName="State" ColumnName="JobState" DataSourceName="[HeuristicLab.Hive_DBTesting].dbo.Job" DataTypeServer="varchar(MAX)" DbType="AnsiString" Direction="Input" ParameterName="@State" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumn="JobState" SourceColumnNullMapping="false" SourceVersion="Current" />
	547	<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" />
	548	<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" />
	549	<Parameter AllowDbNull="false" 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" />
	550	</Parameters>
	551	</DbCommand>
	552	</SelectCommand>
	553	</DbSource>
[1505]	554	<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">
[991]	555	<SelectCommand>
[995]	556	<DbCommand CommandType="Text" ModifiedByUser="true">
[2083]	557	<CommandText>SELECT CoresNeeded, DateCalculated, DateCreated, JobId, JobState, MemoryNeeded, ParentJobId, Percentage, Priority, ProjectId, ResourceId, UserId FROM Job WHERE (UserId = @UserId)</CommandText>
[995]	558	<Parameters>
[1449]	559	<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" />
[995]	560	</Parameters>
	561	</DbCommand>
	562	</SelectCommand>
	563	</DbSource>
[2083]	564	<DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="[HeuristicLab.Hive_DBTesting].dbo.Job" DbObjectType="Table" GenerateShortCommands="true" GeneratorSourceName="GetSerializedJobById" Modifier="Public" Name="GetSerializedJobById" QueryType="Scalar" ScalarCallRetval="System.Byte[], mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="GetSerializedJobById">
	565	<SelectCommand>
	566	<DbCommand CommandType="Text" ModifiedByUser="true">
	567	<CommandText>SELECT SerializedJob FROM Job WHERE JobId = @JobId</CommandText>
	568	<Parameters>
	569	<Parameter AllowDbNull="false" AutogeneratedName="JobId" ColumnName="JobId" DataSourceName="[HeuristicLab.Hive_DBTesting].dbo.Job" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@JobId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="JobId" SourceColumnNullMapping="false" SourceVersion="Current" />
	570	</Parameters>
	571	</DbCommand>
	572	</SelectCommand>
	573	</DbSource>
	574	<DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateSerializedJob" Modifier="Public" Name="UpdateSerializedJob" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="UpdateSerializedJob">
	575	<UpdateCommand>
	576	<DbCommand CommandType="Text" ModifiedByUser="true">
	577	<CommandText>UPDATE Job SET SerializedJob = @SerializedJob WHERE JobId = @JobId</CommandText>
	578	<Parameters>
	579	<Parameter AllowDbNull="true" AutogeneratedName="SerializedJob" ColumnName="SerializedJob" DataSourceName="[HeuristicLab.Hive_DBTesting].dbo.Job" DataTypeServer="varbinary(MAX)" DbType="Binary" Direction="Input" ParameterName="@SerializedJob" Precision="0" ProviderType="VarBinary" Scale="0" Size="2147483647" SourceColumn="SerializedJob" SourceColumnNullMapping="false" SourceVersion="Current" />
	580	<Parameter AllowDbNull="false" AutogeneratedName="JobId" ColumnName="JobId" DataSourceName="[HeuristicLab.Hive_DBTesting].dbo.Job" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@JobId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="JobId" SourceColumnNullMapping="false" SourceVersion="Original" />
	581	</Parameters>
	582	</DbCommand>
	583	</UpdateCommand>
	584	</DbSource>
[995]	585	</Sources>
[991]	586	</TableAdapter>
[1000]	587	<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="JobResultTableAdapter" GeneratorDataComponentClassName="JobResultTableAdapter" Name="JobResult" UserDataComponentName="JobResultTableAdapter">
	588	<MainSource>
[1601]	589	<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">
[1000]	590	<DeleteCommand>
	591	<DbCommand CommandType="Text" ModifiedByUser="false">
[1449]	592	<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>
[1000]	593	<Parameters>
[1449]	594	<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" />
[1000]	595	<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" />
[1449]	596	<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" />
[1169]	597	<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" />
	598	<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" />
[1449]	599	<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" />
	600	<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" />
[1169]	601	<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" />
	602	<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" />
[1000]	603	</Parameters>
	604	</DbCommand>
	605	</DeleteCommand>
	606	<InsertCommand>
	607	<DbCommand CommandType="Text" ModifiedByUser="false">
[1449]	608	<CommandText>INSERT INTO [dbo].[JobResult] ([JobResultId], [JobId], [JobResult], [Message], [Percentage], [ResourceId], [DateFinished]) VALUES (@JobResultId, @JobId, @JobResult, @Message, @Percentage, @ResourceId, @DateFinished);
	609	SELECT JobResultId, JobId, JobResult, Message, Percentage, ResourceId, DateFinished FROM JobResult WHERE (JobResultId = @JobResultId)</CommandText>
[1000]	610	<Parameters>
[1449]	611	<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" />
	612	<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" />
[1000]	613	<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" />
[1092]	614	<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" />
[1169]	615	<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" />
[1449]	616	<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" />
[1169]	617	<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" />
[1000]	618	</Parameters>
	619	</DbCommand>
	620	</InsertCommand>
	621	<SelectCommand>
[1092]	622	<DbCommand CommandType="Text" ModifiedByUser="true">
[1449]	623	<CommandText>SELECT * FROM dbo.JobResult</CommandText>
[1000]	624	<Parameters />
	625	</DbCommand>
	626	</SelectCommand>
	627	<UpdateCommand>
	628	<DbCommand CommandType="Text" ModifiedByUser="false">
[1449]	629	<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)));
	630	SELECT JobResultId, JobId, JobResult, Message, Percentage, ResourceId, DateFinished FROM JobResult WHERE (JobResultId = @JobResultId)</CommandText>
[1000]	631	<Parameters>
[1449]	632	<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" />
	633	<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" />
[1000]	634	<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" />
[1092]	635	<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" />
[1169]	636	<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" />
[1449]	637	<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" />
[1169]	638	<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" />
[1449]	639	<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" />
[1000]	640	<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" />
[1449]	641	<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" />
[1169]	642	<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" />
	643	<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" />
[1449]	644	<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" />
	645	<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" />
[1169]	646	<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" />
	647	<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" />
[1000]	648	</Parameters>
	649	</DbCommand>
	650	</UpdateCommand>
	651	</DbSource>
	652	</MainSource>
	653	<Mappings>
	654	<Mapping SourceColumn="JobResultId" DataSetColumn="JobResultId" />
	655	<Mapping SourceColumn="JobId" DataSetColumn="JobId" />
	656	<Mapping SourceColumn="JobResult" DataSetColumn="JobResult" />
[1092]	657	<Mapping SourceColumn="Message" DataSetColumn="Message" />
[1169]	658	<Mapping SourceColumn="Percentage" DataSetColumn="Percentage" />
[1449]	659	<Mapping SourceColumn="ResourceId" DataSetColumn="ResourceId" />
[1169]	660	<Mapping SourceColumn="DateFinished" DataSetColumn="DateFinished" />
[1000]	661	</Mappings>
[1005]	662	<Sources>
[1601]	663	<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">
[1005]	664	<SelectCommand>
	665	<DbCommand CommandType="Text" ModifiedByUser="true">
[1601]	666	<CommandText>SELECT DateFinished, JobId, JobResult, JobResultId, Message, Percentage, ResourceId FROM JobResult WHERE (JobResultId = @Id)</CommandText>
[1005]	667	<Parameters>
[1449]	668	<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" />
[1005]	669	</Parameters>
	670	</DbCommand>
	671	</SelectCommand>
	672	</DbSource>
[1601]	673	<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">
[1005]	674	<SelectCommand>
	675	<DbCommand CommandType="Text" ModifiedByUser="true">
[1601]	676	<CommandText>SELECT DateFinished, JobId, JobResult, JobResultId, Message, Percentage, ResourceId FROM JobResult WHERE (JobId = @JobId)</CommandText>
[1005]	677	<Parameters>
[1449]	678	<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" />
[1005]	679	</Parameters>
	680	</DbCommand>
	681	</SelectCommand>
	682	</DbSource>
[2086]	683	<DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="[HeuristicLab.Hive_DBTesting].dbo.JobResult" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByLastResult" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByLastResult" GeneratorSourceName="FillByLastResult" GetMethodModifier="Public" GetMethodName="GetDataByLastResult" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByLastResult" UserSourceName="FillByLastResult">
	684	<SelectCommand>
	685	<DbCommand CommandType="Text" ModifiedByUser="true">
	686	<CommandText>SELECT TOP 1 JobResult.* FROM JobResult WHERE JobId = @JobId ORDER BY DateFinished DESC </CommandText>
	687	<Parameters>
	688	<Parameter AllowDbNull="true" AutogeneratedName="JobId" ColumnName="JobId" DataSourceName="[HeuristicLab.Hive_DBTesting].dbo.JobResult" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@JobId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="JobId" SourceColumnNullMapping="false" SourceVersion="Current" />
	689	</Parameters>
	690	</DbCommand>
	691	</SelectCommand>
	692	</DbSource>
[1005]	693	</Sources>
[1000]	694	</TableAdapter>
[1505]	695	<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RequiredPluginsTableAdapter" GeneratorDataComponentClassName="RequiredPluginsTableAdapter" Name="RequiredPlugins" UserDataComponentName="RequiredPluginsTableAdapter">
	696	<MainSource>
	697	<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">
	698	<DeleteCommand>
	699	<DbCommand CommandType="Text" ModifiedByUser="false">
	700	<CommandText>DELETE FROM [dbo].[RequiredPlugins] WHERE (([JobId] = @Original_JobId) AND ([PluginId] = @Original_PluginId))</CommandText>
	701	<Parameters>
	702	<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" />
	703	<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" />
	704	</Parameters>
	705	</DbCommand>
	706	</DeleteCommand>
	707	<InsertCommand>
	708	<DbCommand CommandType="Text" ModifiedByUser="false">
	709	<CommandText>INSERT INTO [dbo].[RequiredPlugins] ([JobId], [PluginId]) VALUES (@JobId, @PluginId);
	710	SELECT JobId, PluginId FROM RequiredPlugins WHERE (JobId = @JobId) AND (PluginId = @PluginId)</CommandText>
	711	<Parameters>
	712	<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" />
	713	<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" />
	714	</Parameters>
	715	</DbCommand>
	716	</InsertCommand>
	717	<SelectCommand>
	718	<DbCommand CommandType="Text" ModifiedByUser="false">
	719	<CommandText>SELECT JobId, PluginId FROM dbo.RequiredPlugins</CommandText>
	720	<Parameters />
	721	</DbCommand>
	722	</SelectCommand>
	723	<UpdateCommand>
	724	<DbCommand CommandType="Text" ModifiedByUser="false">
	725	<CommandText>UPDATE [dbo].[RequiredPlugins] SET [JobId] = @JobId, [PluginId] = @PluginId WHERE (([JobId] = @Original_JobId) AND ([PluginId] = @Original_PluginId));
	726	SELECT JobId, PluginId FROM RequiredPlugins WHERE (JobId = @JobId) AND (PluginId = @PluginId)</CommandText>
	727	<Parameters>
	728	<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" />
	729	<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" />
	730	<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" />
	731	<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" />
	732	</Parameters>
	733	</DbCommand>
	734	</UpdateCommand>
	735	</DbSource>
	736	</MainSource>
	737	<Mappings>
	738	<Mapping SourceColumn="JobId" DataSetColumn="JobId" />
	739	<Mapping SourceColumn="PluginId" DataSetColumn="PluginId" />
	740	</Mappings>
[1575]	741	<Sources>
	742	<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">
	743	<SelectCommand>
	744	<DbCommand CommandType="Text" ModifiedByUser="true">
	745	<CommandText>SELECT * FROM dbo.RequiredPlugins WHERE JobId = @JobId</CommandText>
	746	<Parameters>
	747	<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" />
	748	</Parameters>
	749	</DbCommand>
	750	</SelectCommand>
	751	</DbSource>
	752	</Sources>
[1505]	753	</TableAdapter>
	754	<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PluginInfoTableAdapter" GeneratorDataComponentClassName="PluginInfoTableAdapter" Name="PluginInfo" UserDataComponentName="PluginInfoTableAdapter">
	755	<MainSource>
	756	<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">
	757	<DeleteCommand>
	758	<DbCommand CommandType="Text" ModifiedByUser="false">
[1592]	759	<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>
[1505]	760	<Parameters>
	761	<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" />
[1575]	762	<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" />
	763	<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" />
	764	<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" />
	765	<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" />
	766	<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" />
[1592]	767	<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" />
[1505]	768	</Parameters>
	769	</DbCommand>
	770	</DeleteCommand>
	771	<InsertCommand>
	772	<DbCommand CommandType="Text" ModifiedByUser="false">
[1592]	773	<CommandText>INSERT INTO [PluginInfo] ([PluginId], [Name], [Version], [BuildDate]) VALUES (@PluginId, @Name, @Version, @BuildDate);
[1575]	774	SELECT PluginId, Name, Version, BuildDate FROM PluginInfo WHERE (PluginId = @PluginId)</CommandText>
[1505]	775	<Parameters>
	776	<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" />
[1575]	777	<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" />
	778	<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" />
[1592]	779	<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" />
[1505]	780	</Parameters>
	781	</DbCommand>
	782	</InsertCommand>
	783	<SelectCommand>
	784	<DbCommand CommandType="Text" ModifiedByUser="true">
[1592]	785	<CommandText>SELECT * FROM PluginInfo</CommandText>
[1505]	786	<Parameters />
	787	</DbCommand>
	788	</SelectCommand>
	789	<UpdateCommand>
	790	<DbCommand CommandType="Text" ModifiedByUser="false">
[1592]	791	<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)));
[1575]	792	SELECT PluginId, Name, Version, BuildDate FROM PluginInfo WHERE (PluginId = @PluginId)</CommandText>
[1505]	793	<Parameters>
	794	<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" />
[1575]	795	<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" />
	796	<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" />
[1592]	797	<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" />
[1505]	798	<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" />
[1575]	799	<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" />
	800	<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" />
	801	<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" />
	802	<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" />
	803	<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" />
[1592]	804	<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" />
[1505]	805	</Parameters>
	806	</DbCommand>
	807	</UpdateCommand>
	808	</DbSource>
	809	</MainSource>
	810	<Mappings>
	811	<Mapping SourceColumn="PluginId" DataSetColumn="PluginId" />
[1575]	812	<Mapping SourceColumn="Name" DataSetColumn="Name" />
	813	<Mapping SourceColumn="Version" DataSetColumn="Version" />
	814	<Mapping SourceColumn="BuildDate" DataSetColumn="BuildDate" />
[1505]	815	</Mappings>
[1573]	816	<Sources>
	817	<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">
	818	<SelectCommand>
	819	<DbCommand CommandType="Text" ModifiedByUser="true">
[1592]	820	<CommandText>SELECT BuildDate, Name, PluginId, Version FROM PluginInfo WHERE (PluginId = @Id)</CommandText>
[1573]	821	<Parameters>
	822	<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" />
	823	</Parameters>
	824	</DbCommand>
	825	</SelectCommand>
	826	</DbSource>
[1592]	827	<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">
	828	<SelectCommand>
	829	<DbCommand CommandType="Text" ModifiedByUser="true">
	830	<CommandText>SELECT BuildDate, Name, PluginId, Version FROM PluginInfo WHERE (Name = @Name) AND (Version = @Version) AND (BuildDate = @BuildDate)</CommandText>
	831	<Parameters>
	832	<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" />
	833	<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" />
	834	<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" />
	835	</Parameters>
	836	</DbCommand>
	837	</SelectCommand>
	838	</DbSource>
	839	<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">
	840	<SelectCommand>
	841	<DbCommand CommandType="Text" ModifiedByUser="true">
	842	<CommandText>SELECT BuildDate, Name, PluginId, Version FROM PluginInfo WHERE (NOT EXISTS (SELECT JobId, PluginId FROM RequiredPlugins WHERE (PluginId = PluginInfo.PluginId)))</CommandText>
	843	<Parameters />
	844	</DbCommand>
	845	</SelectCommand>
	846	</DbSource>
[1573]	847	</Sources>
[1505]	848	</TableAdapter>
[1947]	849	<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ProjectTableAdapter" GeneratorDataComponentClassName="ProjectTableAdapter" Name="Project" UserDataComponentName="ProjectTableAdapter">
	850	<MainSource>
	851	<DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="[HeuristicLab.Hive_DBTesting].dbo.Project" 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">
	852	<DeleteCommand>
	853	<DbCommand CommandType="Text" ModifiedByUser="false">
	854	<CommandText>DELETE FROM [dbo].[Project] WHERE (([ProjectId] = @Original_ProjectId))</CommandText>
	855	<Parameters>
	856	<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ProjectId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ProjectId" SourceColumnNullMapping="false" SourceVersion="Original" />
	857	</Parameters>
	858	</DbCommand>
	859	</DeleteCommand>
	860	<InsertCommand>
	861	<DbCommand CommandType="Text" ModifiedByUser="false">
	862	<CommandText>INSERT INTO [dbo].[Project] ([ProjectId], [Name]) VALUES (@ProjectId, @Name);
	863	SELECT ProjectId, Name FROM Project WHERE (ProjectId = @ProjectId)</CommandText>
	864	<Parameters>
	865	<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ProjectId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ProjectId" SourceColumnNullMapping="false" SourceVersion="Current" />
	866	<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" />
	867	</Parameters>
	868	</DbCommand>
	869	</InsertCommand>
	870	<SelectCommand>
	871	<DbCommand CommandType="Text" ModifiedByUser="true">
	872	<CommandText>SELECT * FROM dbo.Project</CommandText>
	873	<Parameters />
	874	</DbCommand>
	875	</SelectCommand>
	876	<UpdateCommand>
	877	<DbCommand CommandType="Text" ModifiedByUser="false">
	878	<CommandText>UPDATE [dbo].[Project] SET [ProjectId] = @ProjectId, [Name] = @Name WHERE (([ProjectId] = @Original_ProjectId));
	879	SELECT ProjectId, Name FROM Project WHERE (ProjectId = @ProjectId)</CommandText>
	880	<Parameters>
	881	<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ProjectId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ProjectId" SourceColumnNullMapping="false" SourceVersion="Current" />
	882	<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" />
	883	<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ProjectId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ProjectId" SourceColumnNullMapping="false" SourceVersion="Original" />
	884	</Parameters>
	885	</DbCommand>
	886	</UpdateCommand>
	887	</DbSource>
	888	</MainSource>
	889	<Mappings>
	890	<Mapping SourceColumn="ProjectId" DataSetColumn="ProjectId" />
	891	<Mapping SourceColumn="Name" DataSetColumn="Name" />
	892	</Mappings>
	893	<Sources>
	894	<DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="[HeuristicLab.Hive_DBTesting].dbo.Project" 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">
	895	<SelectCommand>
	896	<DbCommand CommandType="Text" ModifiedByUser="true">
	897	<CommandText>SELECT Name, ProjectId FROM Project WHERE (ProjectId = @Id)</CommandText>
	898	<Parameters>
	899	<Parameter AllowDbNull="false" AutogeneratedName="Id" ColumnName="ProjectId" DataSourceName="[HeuristicLab.Hive_DBTesting].dbo.Project" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="ProjectId" SourceColumnNullMapping="false" SourceVersion="Current" />
	900	</Parameters>
	901	</DbCommand>
	902	</SelectCommand>
	903	</DbSource>
	904	</Sources>
	905	</TableAdapter>
	906	<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AssignedResourcesTableAdapter" GeneratorDataComponentClassName="AssignedResourcesTableAdapter" Name="AssignedResources" UserDataComponentName="AssignedResourcesTableAdapter">
	907	<MainSource>
	908	<DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="[HeuristicLab.Hive_DBTesting].dbo.AssignedResources" 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">
	909	<DeleteCommand>
	910	<DbCommand CommandType="Text" ModifiedByUser="false">
	911	<CommandText>DELETE FROM [dbo].[AssignedResources] WHERE (([ResourceId] = @Original_ResourceId) AND ([JobId] = @Original_JobId))</CommandText>
	912	<Parameters>
	913	<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" />
	914	<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" />
	915	</Parameters>
	916	</DbCommand>
	917	</DeleteCommand>
	918	<InsertCommand>
	919	<DbCommand CommandType="Text" ModifiedByUser="false">
	920	<CommandText>INSERT INTO [dbo].[AssignedResources] ([ResourceId], [JobId]) VALUES (@ResourceId, @JobId);
	921	SELECT ResourceId, JobId FROM AssignedResources WHERE (JobId = @JobId) AND (ResourceId = @ResourceId)</CommandText>
	922	<Parameters>
	923	<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" />
	924	<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" />
	925	</Parameters>
	926	</DbCommand>
	927	</InsertCommand>
	928	<SelectCommand>
	929	<DbCommand CommandType="Text" ModifiedByUser="true">
	930	<CommandText>SELECT * FROM dbo.AssignedResources</CommandText>
	931	<Parameters />
	932	</DbCommand>
	933	</SelectCommand>
	934	<UpdateCommand>
	935	<DbCommand CommandType="Text" ModifiedByUser="false">
	936	<CommandText>UPDATE [dbo].[AssignedResources] SET [ResourceId] = @ResourceId, [JobId] = @JobId WHERE (([ResourceId] = @Original_ResourceId) AND ([JobId] = @Original_JobId));
	937	SELECT ResourceId, JobId FROM AssignedResources WHERE (JobId = @JobId) AND (ResourceId = @ResourceId)</CommandText>
	938	<Parameters>
	939	<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" />
	940	<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" />
	941	<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" />
	942	<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" />
	943	</Parameters>
	944	</DbCommand>
	945	</UpdateCommand>
	946	</DbSource>
	947	</MainSource>
	948	<Mappings>
	949	<Mapping SourceColumn="ResourceId" DataSetColumn="ResourceId" />
	950	<Mapping SourceColumn="JobId" DataSetColumn="JobId" />
	951	</Mappings>
	952	<Sources>
	953	<DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="[HeuristicLab.Hive_DBTesting].dbo.AssignedResources" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByJobId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByJobId" GeneratorSourceName="FillByJobId" GetMethodModifier="Public" GetMethodName="GetDataByJobId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByJobId" UserSourceName="FillByJobId">
	954	<SelectCommand>
	955	<DbCommand CommandType="Text" ModifiedByUser="true">
	956	<CommandText>SELECT JobId, ResourceId FROM AssignedResources WHERE (JobId = @JobId)</CommandText>
	957	<Parameters>
	958	<Parameter AllowDbNull="false" AutogeneratedName="JobId" ColumnName="JobId" DataSourceName="[HeuristicLab.Hive_DBTesting].dbo.AssignedResources" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@JobId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="JobId" SourceColumnNullMapping="false" SourceVersion="Current" />
	959	</Parameters>
	960	</DbCommand>
	961	</SelectCommand>
	962	</DbSource>
	963	</Sources>
	964	</TableAdapter>
[1999]	965	<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ClientConfigTableAdapter" GeneratorDataComponentClassName="ClientConfigTableAdapter" Name="ClientConfig" UserDataComponentName="ClientConfigTableAdapter">
	966	<MainSource>
	967	<DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="[HeuristicLab.Hive_DBTesting].dbo.ClientConfig" 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">
	968	<DeleteCommand>
	969	<DbCommand CommandType="Text" ModifiedByUser="false">
	970	<CommandText>DELETE FROM [dbo].[ClientConfig] WHERE (([ClientConfigId] = @Original_ClientConfigId) AND ((@IsNull_HeartBeatIntervall = 1 AND [HeartBeatIntervall] IS NULL) OR ([HeartBeatIntervall] = @Original_HeartBeatIntervall)))</CommandText>
	971	<Parameters>
	972	<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ClientConfigId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ClientConfigId" SourceColumnNullMapping="false" SourceVersion="Original" />
	973	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HeartBeatIntervall" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HeartBeatIntervall" SourceColumnNullMapping="true" SourceVersion="Original" />
	974	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_HeartBeatIntervall" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HeartBeatIntervall" SourceColumnNullMapping="false" SourceVersion="Original" />
	975	</Parameters>
	976	</DbCommand>
	977	</DeleteCommand>
	978	<InsertCommand>
	979	<DbCommand CommandType="Text" ModifiedByUser="false">
	980	<CommandText>INSERT INTO [dbo].[ClientConfig] ([ClientConfigId], [UpDownTimeCalendar], [HeartBeatIntervall]) VALUES (@ClientConfigId, @UpDownTimeCalendar, @HeartBeatIntervall);
	981	SELECT ClientConfigId, UpDownTimeCalendar, HeartBeatIntervall FROM ClientConfig WHERE (ClientConfigId = @ClientConfigId)</CommandText>
	982	<Parameters>
	983	<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ClientConfigId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ClientConfigId" SourceColumnNullMapping="false" SourceVersion="Current" />
	984	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Xml" Direction="Input" ParameterName="@UpDownTimeCalendar" Precision="0" ProviderType="Xml" Scale="0" Size="0" SourceColumn="UpDownTimeCalendar" SourceColumnNullMapping="false" SourceVersion="Current" />
	985	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@HeartBeatIntervall" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HeartBeatIntervall" SourceColumnNullMapping="false" SourceVersion="Current" />
	986	</Parameters>
	987	</DbCommand>
	988	</InsertCommand>
	989	<SelectCommand>
	990	<DbCommand CommandType="Text" ModifiedByUser="true">
	991	<CommandText>SELECT * FROM dbo.ClientConfig</CommandText>
	992	<Parameters />
	993	</DbCommand>
	994	</SelectCommand>
	995	<UpdateCommand>
	996	<DbCommand CommandType="Text" ModifiedByUser="false">
	997	<CommandText>UPDATE [dbo].[ClientConfig] SET [ClientConfigId] = @ClientConfigId, [UpDownTimeCalendar] = @UpDownTimeCalendar, [HeartBeatIntervall] = @HeartBeatIntervall WHERE (([ClientConfigId] = @Original_ClientConfigId) AND ((@IsNull_HeartBeatIntervall = 1 AND [HeartBeatIntervall] IS NULL) OR ([HeartBeatIntervall] = @Original_HeartBeatIntervall)));
	998	SELECT ClientConfigId, UpDownTimeCalendar, HeartBeatIntervall FROM ClientConfig WHERE (ClientConfigId = @ClientConfigId)</CommandText>
	999	<Parameters>
	1000	<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ClientConfigId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ClientConfigId" SourceColumnNullMapping="false" SourceVersion="Current" />
	1001	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Xml" Direction="Input" ParameterName="@UpDownTimeCalendar" Precision="0" ProviderType="Xml" Scale="0" Size="0" SourceColumn="UpDownTimeCalendar" SourceColumnNullMapping="false" SourceVersion="Current" />
	1002	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@HeartBeatIntervall" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HeartBeatIntervall" SourceColumnNullMapping="false" SourceVersion="Current" />
	1003	<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ClientConfigId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ClientConfigId" SourceColumnNullMapping="false" SourceVersion="Original" />
	1004	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HeartBeatIntervall" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HeartBeatIntervall" SourceColumnNullMapping="true" SourceVersion="Original" />
	1005	<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_HeartBeatIntervall" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HeartBeatIntervall" SourceColumnNullMapping="false" SourceVersion="Original" />
	1006	</Parameters>
	1007	</DbCommand>
	1008	</UpdateCommand>
	1009	</DbSource>
	1010	</MainSource>
	1011	<Mappings>
	1012	<Mapping SourceColumn="ClientConfigId" DataSetColumn="ClientConfigId" />
	1013	<Mapping SourceColumn="UpDownTimeCalendar" DataSetColumn="UpDownTimeCalendar" />
	1014	<Mapping SourceColumn="HeartBeatIntervall" DataSetColumn="HeartBeatIntervall" />
	1015	</Mappings>
	1016	<Sources>
	1017	<DbSource ConnectionRef="HiveServerConnectionString (Settings)" DbObjectName="[HeuristicLab.Hive_DBTesting].dbo.ClientConfig" 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">
	1018	<SelectCommand>
	1019	<DbCommand CommandType="Text" ModifiedByUser="true">
	1020	<CommandText>SELECT * FROM dbo.ClientConfig WHERE ClientConfigId = @Id</CommandText>
	1021	<Parameters>
	1022	<Parameter AllowDbNull="false" AutogeneratedName="Id" ColumnName="ClientConfigId" DataSourceName="[HeuristicLab.Hive_DBTesting].dbo.ClientConfig" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="ClientConfigId" SourceColumnNullMapping="false" SourceVersion="Current" />
	1023	</Parameters>
	1024	</DbCommand>
	1025	</SelectCommand>
	1026	</DbSource>
	1027	</Sources>
	1028	</TableAdapter>
[826]	1029	</Tables>
	1030	<Sources />
	1031	</DataSource>
	1032	</xs:appinfo>
	1033	</xs:annotation>
	1034	<xs:element name="dsHiveServer" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="dsHiveServer" msprop:Generator_DataSetName="dsHiveServer" msprop:EnableTableAdapterManager="true">
	1035	<xs:complexType>
	1036	<xs:choice minOccurs="0" maxOccurs="unbounded">
[1449]	1037	<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">
[826]	1038	<xs:complexType>
	1039	<xs:sequence>
[2086]	1040	<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" />
	1041	<xs:element name="CPUSpeed" msprop:Generator_UserColumnName="CPUSpeed" msprop:Generator_ColumnVarNameInTable="columnCPUSpeed" msprop:Generator_ColumnPropNameInRow="CPUSpeed" msprop:Generator_ColumnPropNameInTable="CPUSpeedColumn" type="xs:int" minOccurs="0" />
	1042	<xs:element name="Memory" msprop:Generator_UserColumnName="Memory" msprop:Generator_ColumnVarNameInTable="columnMemory" msprop:Generator_ColumnPropNameInRow="Memory" msprop:Generator_ColumnPropNameInTable="MemoryColumn" type="xs:int" minOccurs="0" />
	1043	<xs:element name="Login" msprop:Generator_UserColumnName="Login" msprop:Generator_ColumnVarNameInTable="columnLogin" msprop:Generator_ColumnPropNameInRow="Login" msprop:Generator_ColumnPropNameInTable="LoginColumn" type="xs:dateTime" minOccurs="0" />
	1044	<xs:element name="Status" msprop:Generator_UserColumnName="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInRow="Status" msprop:Generator_ColumnPropNameInTable="StatusColumn" minOccurs="0">
[826]	1045	<xs:simpleType>
	1046	<xs:restriction base="xs:string">
[1829]	1047	<xs:maxLength value="255" />
[826]	1048	</xs:restriction>
	1049	</xs:simpleType>
	1050	</xs:element>
[2086]	1051	<xs:element name="ClientConfigId" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="ClientConfigId" msprop:Generator_ColumnVarNameInTable="columnClientConfigId" msprop:Generator_ColumnPropNameInRow="ClientConfigId" msprop:Generator_ColumnPropNameInTable="ClientConfigIdColumn" type="xs:string" minOccurs="0" />
	1052	<xs:element name="NumberOfCores" msprop:Generator_UserColumnName="NumberOfCores" msprop:Generator_ColumnVarNameInTable="columnNumberOfCores" msprop:Generator_ColumnPropNameInRow="NumberOfCores" msprop:Generator_ColumnPropNameInTable="NumberOfCoresColumn" type="xs:int" minOccurs="0" />
	1053	<xs:element name="NumberOfFreeCores" msprop:Generator_UserColumnName="NumberOfFreeCores" msprop:Generator_ColumnPropNameInRow="NumberOfFreeCores" msprop:Generator_ColumnVarNameInTable="columnNumberOfFreeCores" msprop:Generator_ColumnPropNameInTable="NumberOfFreeCoresColumn" type="xs:int" minOccurs="0" />
	1054	<xs:element name="FreeMemory" msprop:Generator_UserColumnName="FreeMemory" msprop:Generator_ColumnPropNameInRow="FreeMemory" msprop:Generator_ColumnVarNameInTable="columnFreeMemory" msprop:Generator_ColumnPropNameInTable="FreeMemoryColumn" type="xs:int" minOccurs="0" />
[845]	1055	</xs:sequence>
	1056	</xs:complexType>
	1057	</xs:element>
[1449]	1058	<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">
[845]	1059	<xs:complexType>
	1060	<xs:sequence>
[2086]	1061	<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" />
	1062	<xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" minOccurs="0">
[826]	1063	<xs:simpleType>
	1064	<xs:restriction base="xs:string">
[1601]	1065	<xs:maxLength value="100" />
[826]	1066	</xs:restriction>
	1067	</xs:simpleType>
	1068	</xs:element>
[845]	1069	</xs:sequence>
	1070	</xs:complexType>
	1071	</xs:element>
[971]	1072	<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">
[965]	1073	<xs:complexType>
	1074	<xs:sequence>
[2086]	1075	<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" />
[965]	1076	</xs:sequence>
	1077	</xs:complexType>
	1078	</xs:element>
[1449]	1079	<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">
	1080	<xs:complexType>
	1081	<xs:sequence>
[2086]	1082	<xs:element name="ClientGroupId" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="ClientGroupId" msprop:Generator_ColumnPropNameInRow="ClientGroupId" msprop:Generator_ColumnVarNameInTable="columnClientGroupId" msprop:Generator_ColumnPropNameInTable="ClientGroupIdColumn" type="xs:string" />
	1083	<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" />
[1449]	1084	</xs:sequence>
	1085	</xs:complexType>
	1086	</xs:element>
[991]	1087	<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">
[965]	1088	<xs:complexType>
	1089	<xs:sequence>
[2086]	1090	<xs:element name="JobId" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="JobId" msprop:Generator_ColumnPropNameInRow="JobId" msprop:Generator_ColumnVarNameInTable="columnJobId" msprop:Generator_ColumnPropNameInTable="JobIdColumn" type="xs:string" />
	1091	<xs:element name="ParentJobId" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="ParentJobId" msprop:Generator_ColumnPropNameInRow="ParentJobId" msprop:Generator_ColumnVarNameInTable="columnParentJobId" msprop:Generator_ColumnPropNameInTable="ParentJobIdColumn" type="xs:string" minOccurs="0" />
	1092	<xs:element name="JobState" msprop:Generator_UserColumnName="JobState" msprop:Generator_ColumnPropNameInRow="JobState" msprop:Generator_ColumnVarNameInTable="columnJobState" msprop:Generator_ColumnPropNameInTable="JobStateColumn" minOccurs="0">
[971]	1093	<xs:simpleType>
	1094	<xs:restriction base="xs:string">
[1807]	1095	<xs:maxLength value="255" />
[971]	1096	</xs:restriction>
	1097	</xs:simpleType>
	1098	</xs:element>
[2086]	1099	<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" minOccurs="0" />
	1100	<xs:element name="Percentage" msprop:Generator_UserColumnName="Percentage" msprop:Generator_ColumnPropNameInRow="Percentage" msprop:Generator_ColumnVarNameInTable="columnPercentage" msprop:Generator_ColumnPropNameInTable="PercentageColumn" type="xs:double" minOccurs="0" />
	1101	<xs:element name="DateCreated" msprop:Generator_UserColumnName="DateCreated" msprop:Generator_ColumnPropNameInRow="DateCreated" msprop:Generator_ColumnVarNameInTable="columnDateCreated" msprop:Generator_ColumnPropNameInTable="DateCreatedColumn" type="xs:dateTime" minOccurs="0" />
	1102	<xs:element name="DateCalculated" msprop:Generator_UserColumnName="DateCalculated" msprop:Generator_ColumnPropNameInRow="DateCalculated" msprop:Generator_ColumnVarNameInTable="columnDateCalculated" msprop:Generator_ColumnPropNameInTable="DateCalculatedColumn" type="xs:dateTime" minOccurs="0" />
	1103	<xs:element name="Priority" msprop:Generator_UserColumnName="Priority" msprop:Generator_ColumnPropNameInRow="Priority" msprop:Generator_ColumnVarNameInTable="columnPriority" msprop:Generator_ColumnPropNameInTable="PriorityColumn" type="xs:int" minOccurs="0" />
	1104	<xs:element name="ProjectId" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="ProjectId" msprop:Generator_ColumnPropNameInRow="ProjectId" msprop:Generator_ColumnVarNameInTable="columnProjectId" msprop:Generator_ColumnPropNameInTable="ProjectIdColumn" type="xs:string" minOccurs="0" />
	1105	<xs:element name="UserId" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="UserId" msprop:Generator_ColumnPropNameInRow="UserId" msprop:Generator_ColumnVarNameInTable="columnUserId" msprop:Generator_ColumnPropNameInTable="UserIdColumn" type="xs:string" minOccurs="0" />
	1106	<xs:element name="CoresNeeded" msprop:Generator_UserColumnName="CoresNeeded" msprop:Generator_ColumnPropNameInRow="CoresNeeded" msprop:Generator_ColumnVarNameInTable="columnCoresNeeded" msprop:Generator_ColumnPropNameInTable="CoresNeededColumn" type="xs:int" minOccurs="0" />
	1107	<xs:element name="MemoryNeeded" msprop:Generator_UserColumnName="MemoryNeeded" msprop:Generator_ColumnPropNameInRow="MemoryNeeded" msprop:Generator_ColumnVarNameInTable="columnMemoryNeeded" msprop:Generator_ColumnPropNameInTable="MemoryNeededColumn" type="xs:int" minOccurs="0" />
[971]	1108	</xs:sequence>
	1109	</xs:complexType>
	1110	</xs:element>
[1005]	1111	<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">
[1000]	1112	<xs:complexType>
	1113	<xs:sequence>
[2086]	1114	<xs:element name="JobResultId" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="JobResultId" msprop:Generator_ColumnPropNameInRow="JobResultId" msprop:Generator_ColumnVarNameInTable="columnJobResultId" msprop:Generator_ColumnPropNameInTable="JobResultIdColumn" type="xs:string" />
	1115	<xs:element name="JobId" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="JobId" msprop:Generator_ColumnPropNameInRow="JobId" msprop:Generator_ColumnVarNameInTable="columnJobId" msprop:Generator_ColumnPropNameInTable="JobIdColumn" type="xs:string" minOccurs="0" />
	1116	<xs:element name="JobResult" msprop:Generator_UserColumnName="JobResult" msprop:Generator_ColumnPropNameInRow="JobResult" msprop:Generator_ColumnVarNameInTable="columnJobResult" msprop:Generator_ColumnPropNameInTable="JobResultColumn" type="xs:base64Binary" minOccurs="0" />
	1117	<xs:element name="Message" msprop:Generator_UserColumnName="Message" msprop:Generator_ColumnPropNameInRow="Message" msprop:Generator_ColumnVarNameInTable="columnMessage" msprop:Generator_ColumnPropNameInTable="MessageColumn" minOccurs="0">
[1092]	1118	<xs:simpleType>
	1119	<xs:restriction base="xs:string">
	1120	<xs:maxLength value="2147483647" />
	1121	</xs:restriction>
	1122	</xs:simpleType>
	1123	</xs:element>
[2086]	1124	<xs:element name="Percentage" msprop:Generator_UserColumnName="Percentage" msprop:Generator_ColumnPropNameInRow="Percentage" msprop:Generator_ColumnVarNameInTable="columnPercentage" msprop:Generator_ColumnPropNameInTable="PercentageColumn" type="xs:double" minOccurs="0" />
	1125	<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" minOccurs="0" />
	1126	<xs:element name="DateFinished" msprop:Generator_UserColumnName="DateFinished" msprop:Generator_ColumnPropNameInRow="DateFinished" msprop:Generator_ColumnVarNameInTable="columnDateFinished" msprop:Generator_ColumnPropNameInTable="DateFinishedColumn" type="xs:dateTime" minOccurs="0" />
[1000]	1127	</xs:sequence>
	1128	</xs:complexType>
	1129	</xs:element>
[1505]	1130	<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">
	1131	<xs:complexType>
	1132	<xs:sequence>
[2086]	1133	<xs:element name="JobId" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="JobId" msprop:Generator_ColumnPropNameInRow="JobId" msprop:Generator_ColumnVarNameInTable="columnJobId" msprop:Generator_ColumnPropNameInTable="JobIdColumn" type="xs:string" />
	1134	<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" />
[1505]	1135	</xs:sequence>
	1136	</xs:complexType>
	1137	</xs:element>
	1138	<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">
	1139	<xs:complexType>
	1140	<xs:sequence>
[2086]	1141	<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" />
	1142	<xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" minOccurs="0">
[1505]	1143	<xs:simpleType>
	1144	<xs:restriction base="xs:string">
[1601]	1145	<xs:maxLength value="100" />
[1505]	1146	</xs:restriction>
	1147	</xs:simpleType>
	1148	</xs:element>
[2086]	1149	<xs:element name="Version" msprop:Generator_UserColumnName="Version" msprop:Generator_ColumnVarNameInTable="columnVersion" msprop:Generator_ColumnPropNameInRow="Version" msprop:Generator_ColumnPropNameInTable="VersionColumn" minOccurs="0">
[1575]	1150	<xs:simpleType>
	1151	<xs:restriction base="xs:string">
[1601]	1152	<xs:maxLength value="100" />
[1575]	1153	</xs:restriction>
	1154	</xs:simpleType>
	1155	</xs:element>
[2086]	1156	<xs:element name="BuildDate" msprop:Generator_UserColumnName="BuildDate" msprop:Generator_ColumnVarNameInTable="columnBuildDate" msprop:Generator_ColumnPropNameInRow="BuildDate" msprop:Generator_ColumnPropNameInTable="BuildDateColumn" type="xs:dateTime" minOccurs="0" />
[1505]	1157	</xs:sequence>
	1158	</xs:complexType>
	1159	</xs:element>
[1947]	1160	<xs:element name="Project" msprop:Generator_UserTableName="Project" msprop:Generator_RowDeletedName="ProjectRowDeleted" msprop:Generator_RowChangedName="ProjectRowChanged" msprop:Generator_RowClassName="ProjectRow" msprop:Generator_RowChangingName="ProjectRowChanging" msprop:Generator_RowEvArgName="ProjectRowChangeEvent" msprop:Generator_RowEvHandlerName="ProjectRowChangeEventHandler" msprop:Generator_TableClassName="ProjectDataTable" msprop:Generator_TableVarName="tableProject" msprop:Generator_RowDeletingName="ProjectRowDeleting" msprop:Generator_TablePropName="Project">
	1161	<xs:complexType>
	1162	<xs:sequence>
[2086]	1163	<xs:element name="ProjectId" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="ProjectId" msprop:Generator_ColumnPropNameInRow="ProjectId" msprop:Generator_ColumnVarNameInTable="columnProjectId" msprop:Generator_ColumnPropNameInTable="ProjectIdColumn" type="xs:string" />
	1164	<xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn" minOccurs="0">
[1947]	1165	<xs:simpleType>
	1166	<xs:restriction base="xs:string">
	1167	<xs:maxLength value="2147483647" />
	1168	</xs:restriction>
	1169	</xs:simpleType>
	1170	</xs:element>
	1171	</xs:sequence>
	1172	</xs:complexType>
	1173	</xs:element>
[1999]	1174	<xs:element name="AssignedResources" msprop:Generator_UserTableName="AssignedResources" msprop:Generator_RowDeletedName="AssignedResourcesRowDeleted" msprop:Generator_RowChangedName="AssignedResourcesRowChanged" msprop:Generator_RowClassName="AssignedResourcesRow" msprop:Generator_RowChangingName="AssignedResourcesRowChanging" msprop:Generator_RowEvArgName="AssignedResourcesRowChangeEvent" msprop:Generator_RowEvHandlerName="AssignedResourcesRowChangeEventHandler" msprop:Generator_TableClassName="AssignedResourcesDataTable" msprop:Generator_TableVarName="tableAssignedResources" msprop:Generator_RowDeletingName="AssignedResourcesRowDeleting" msprop:Generator_TablePropName="AssignedResources">
[1947]	1175	<xs:complexType>
	1176	<xs:sequence>
[2086]	1177	<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" />
	1178	<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" />
[1947]	1179	</xs:sequence>
	1180	</xs:complexType>
	1181	</xs:element>
[2001]	1182	<xs:element name="ClientConfig" msprop:Generator_UserTableName="ClientConfig" msprop:Generator_RowDeletedName="ClientConfigRowDeleted" msprop:Generator_RowChangedName="ClientConfigRowChanged" msprop:Generator_RowClassName="ClientConfigRow" msprop:Generator_RowChangingName="ClientConfigRowChanging" msprop:Generator_RowEvArgName="ClientConfigRowChangeEvent" msprop:Generator_RowEvHandlerName="ClientConfigRowChangeEventHandler" msprop:Generator_TableClassName="ClientConfigDataTable" msprop:Generator_TableVarName="tableClientConfig" msprop:Generator_RowDeletingName="ClientConfigRowDeleting" msprop:Generator_TablePropName="ClientConfig">
[1999]	1183	<xs:complexType>
	1184	<xs:sequence>
[2086]	1185	<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" />
	1186	<xs:element name="UpDownTimeCalendar" msprop:Generator_UserColumnName="UpDownTimeCalendar" msprop:Generator_ColumnPropNameInRow="UpDownTimeCalendar" msprop:Generator_ColumnVarNameInTable="columnUpDownTimeCalendar" msprop:Generator_ColumnPropNameInTable="UpDownTimeCalendarColumn" minOccurs="0">
[1999]	1187	<xs:simpleType>
	1188	<xs:restriction base="xs:string">
	1189	<xs:maxLength value="2147483647" />
	1190	</xs:restriction>
	1191	</xs:simpleType>
	1192	</xs:element>
[2086]	1193	<xs:element name="HeartBeatIntervall" msprop:Generator_UserColumnName="HeartBeatIntervall" msprop:Generator_ColumnPropNameInRow="HeartBeatIntervall" msprop:Generator_ColumnVarNameInTable="columnHeartBeatIntervall" msprop:Generator_ColumnPropNameInTable="HeartBeatIntervallColumn" type="xs:int" minOccurs="0" />
[1999]	1194	</xs:sequence>
	1195	</xs:complexType>
	1196	</xs:element>
[826]	1197	</xs:choice>
	1198	</xs:complexType>
	1199	<xs:unique name="Constraint1" msdata:PrimaryKey="true">
[1449]	1200	<xs:selector xpath=".//mstns:Client" />
[826]	1201	<xs:field xpath="mstns:ResourceId" />
	1202	</xs:unique>
[1449]	1203	<xs:unique name="Resource_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
	1204	<xs:selector xpath=".//mstns:Resource" />
[826]	1205	<xs:field xpath="mstns:ResourceId" />
	1206	</xs:unique>
[965]	1207	<xs:unique name="ClientGroup_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
	1208	<xs:selector xpath=".//mstns:ClientGroup" />
	1209	<xs:field xpath="mstns:ResourceId" />
	1210	</xs:unique>
	1211	<xs:unique name="ClientGroup_Resource_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
	1212	<xs:selector xpath=".//mstns:ClientGroup_Resource" />
[991]	1213	<xs:field xpath="mstns:ClientGroupId" />
[965]	1214	<xs:field xpath="mstns:ResourceId" />
	1215	</xs:unique>
[1449]	1216	<xs:unique name="Job_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
	1217	<xs:selector xpath=".//mstns:Job" />
	1218	<xs:field xpath="mstns:JobId" />
	1219	</xs:unique>
[1000]	1220	<xs:unique name="JobResult_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
	1221	<xs:selector xpath=".//mstns:JobResult" />
	1222	<xs:field xpath="mstns:JobResultId" />
	1223	</xs:unique>
[1505]	1224	<xs:unique name="RequiredPlugins_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
	1225	<xs:selector xpath=".//mstns:RequiredPlugins" />
	1226	<xs:field xpath="mstns:JobId" />
	1227	<xs:field xpath="mstns:PluginId" />
	1228	</xs:unique>
	1229	<xs:unique name="PluginInfo_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
	1230	<xs:selector xpath=".//mstns:PluginInfo" />
	1231	<xs:field xpath="mstns:PluginId" />
	1232	</xs:unique>
[1947]	1233	<xs:unique name="Project_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
	1234	<xs:selector xpath=".//mstns:Project" />
	1235	<xs:field xpath="mstns:ProjectId" />
	1236	</xs:unique>
	1237	<xs:unique name="AssignedResources_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
	1238	<xs:selector xpath=".//mstns:AssignedResources" />
	1239	<xs:field xpath="mstns:ResourceId" />
	1240	<xs:field xpath="mstns:JobId" />
	1241	</xs:unique>
[1999]	1242	<xs:unique name="ClientConfig_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
	1243	<xs:selector xpath=".//mstns:ClientConfig" />
	1244	<xs:field xpath="mstns:ClientConfigId" />
	1245	</xs:unique>
[826]	1246	</xs:element>
	1247	<xs:annotation>
	1248	<xs:appinfo>
	1249	<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" />
[965]	1250	<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" />
[971]	1251	<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" />
[1000]	1252	<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" />
[1505]	1253	<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" />
	1254	<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" />
[1515]	1255	<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" />
[1601]	1256	<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" />
	1257	<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" />
[1636]	1258	<msdata:Relationship name="R_521" msdata:parent="ClientGroup" msdata:child="ClientGroup_Resource" msdata:parentkey="ResourceId" msdata:childkey="ClientGroupId" msprop:Generator_UserRelationName="R_521" msprop:Generator_RelationVarName="relationR_521" msprop:Generator_UserChildTable="ClientGroup_Resource" msprop:Generator_UserParentTable="ClientGroup" msprop:Generator_ParentPropName="ClientGroupRow" msprop:Generator_ChildPropName="GetClientGroup_ResourceRows" />
[1947]	1259	<msdata:Relationship name="R_49" msdata:parent="Project" msdata:child="Job" msdata:parentkey="ProjectId" msdata:childkey="ProjectId" msprop:Generator_UserRelationName="R_49" msprop:Generator_RelationVarName="relationR_49" msprop:Generator_UserChildTable="Job" msprop:Generator_UserParentTable="Project" msprop:Generator_ParentPropName="ProjectRow" msprop:Generator_ChildPropName="GetJobRows" />
	1260	<msdata:Relationship name="R_55" msdata:parent="Resource" msdata:child="AssignedResources" msdata:parentkey="ResourceId" msdata:childkey="ResourceId" msprop:Generator_UserRelationName="R_55" msprop:Generator_RelationVarName="relationR_55" msprop:Generator_UserChildTable="AssignedResources" msprop:Generator_UserParentTable="Resource" msprop:Generator_ParentPropName="ResourceRow" msprop:Generator_ChildPropName="GetAssignedResourcesRows" />
	1261	<msdata:Relationship name="R_56" msdata:parent="Job" msdata:child="AssignedResources" msdata:parentkey="JobId" msdata:childkey="JobId" msprop:Generator_UserRelationName="R_56" msprop:Generator_RelationVarName="relationR_56" msprop:Generator_UserChildTable="AssignedResources" msprop:Generator_UserParentTable="Job" msprop:Generator_ParentPropName="JobRow" msprop:Generator_ChildPropName="GetAssignedResourcesRows" />
[1999]	1262	<msdata:Relationship name="R_37" msdata:parent="ClientConfig" msdata:child="Client" msdata:parentkey="ClientConfigId" msdata:childkey="ClientConfigId" msprop:Generator_UserRelationName="R_37" msprop:Generator_RelationVarName="relationR_37" msprop:Generator_UserChildTable="Client" msprop:Generator_UserParentTable="ClientConfig" msprop:Generator_ParentPropName="ClientConfigRow" msprop:Generator_ChildPropName="GetClientRows" />
[2066]	1263	<msdata:Relationship name="R_44" msdata:parent="Job" msdata:child="Job" msdata:parentkey="JobId" msdata:childkey="ParentJobId" msprop:Generator_UserRelationName="R_44" msprop:Generator_RelationVarName="relationR_44" msprop:Generator_UserChildTable="Job" msprop:Generator_UserParentTable="Job" msprop:Generator_ParentPropName="JobRowParent" msprop:Generator_ChildPropName="GetJobRows" />
[826]	1264	</xs:appinfo>
	1265	</xs:annotation>
	1266	</xs:schema>

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

Download in other formats:

Update cookies preferences