Click here to Skip to main content
15,893,722 members
Search within:


Articles / Web Development / Apache
 

The platform-independent code with Mono: Client-server application sample

Rate me:
Please Sign up or sign in to vote.
4.80/5 (23 votes)
24 Mar 2010CPOL10 min read 74.6K   798   59  
This article shows how we can develop the platform-independent software with Mono usage
 
<?xml version="1.0" encoding="utf-8"?>
<TestRecord xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <Results>
    <UnitTestResult>
      <TestDate>2010-03-18T18:51:20</TestDate>
      <Status>Failure</Status>
      <TotalFailures>6</TotalFailures>
      <TotalSuccess>0</TotalSuccess>
      <TotalIgnored>0</TotalIgnored>
      <Time />
      <Message>Child test failed</Message>
    </UnitTestResult>
    <UnitTestResult>
      <TestDate>2010-03-18T19:03:12</TestDate>
      <Status>Success</Status>
      <TotalFailures>0</TotalFailures>
      <TotalSuccess>6</TotalSuccess>
      <TotalIgnored>0</TotalIgnored>
      <Time />
    </UnitTestResult>
    <UnitTestResult>
      <TestDate>2010-03-18T19:05:54</TestDate>
      <Status>Success</Status>
      <TotalFailures>0</TotalFailures>
      <TotalSuccess>6</TotalSuccess>
      <TotalIgnored>0</TotalIgnored>
      <Time />
    </UnitTestResult>
  </Results>
  <Tests>
    <TestRecord Name="InfoCenter">
      <Results>
        <UnitTestResult>
          <TestDate>2010-03-18T18:51:20</TestDate>
          <Status>Failure</Status>
          <TotalFailures>6</TotalFailures>
          <TotalSuccess>0</TotalSuccess>
          <TotalIgnored>0</TotalIgnored>
          <Time />
          <Message>Child test failed</Message>
        </UnitTestResult>
        <UnitTestResult>
          <TestDate>2010-03-18T19:03:12</TestDate>
          <Status>Success</Status>
          <TotalFailures>0</TotalFailures>
          <TotalSuccess>6</TotalSuccess>
          <TotalIgnored>0</TotalIgnored>
          <Time />
        </UnitTestResult>
        <UnitTestResult>
          <TestDate>2010-03-18T19:05:54</TestDate>
          <Status>Success</Status>
          <TotalFailures>0</TotalFailures>
          <TotalSuccess>6</TotalSuccess>
          <TotalIgnored>0</TotalIgnored>
          <Time />
        </UnitTestResult>
      </Results>
      <Tests>
        <TestRecord Name="Persistence">
          <Results>
            <UnitTestResult>
              <TestDate>2010-03-18T18:51:20</TestDate>
              <Status>Failure</Status>
              <TotalFailures>6</TotalFailures>
              <TotalSuccess>0</TotalSuccess>
              <TotalIgnored>0</TotalIgnored>
              <Time />
              <Message>Child test failed</Message>
            </UnitTestResult>
            <UnitTestResult>
              <TestDate>2010-03-18T19:03:12</TestDate>
              <Status>Success</Status>
              <TotalFailures>0</TotalFailures>
              <TotalSuccess>6</TotalSuccess>
              <TotalIgnored>0</TotalIgnored>
              <Time />
            </UnitTestResult>
            <UnitTestResult>
              <TestDate>2010-03-18T19:05:54</TestDate>
              <Status>Success</Status>
              <TotalFailures>0</TotalFailures>
              <TotalSuccess>6</TotalSuccess>
              <TotalIgnored>0</TotalIgnored>
              <Time />
            </UnitTestResult>
          </Results>
          <Tests>
            <TestRecord Name="Tests">
              <Results>
                <UnitTestResult>
                  <TestDate>2010-03-18T18:51:20</TestDate>
                  <Status>Failure</Status>
                  <TotalFailures>6</TotalFailures>
                  <TotalSuccess>0</TotalSuccess>
                  <TotalIgnored>0</TotalIgnored>
                  <Time />
                  <Message>Child test failed</Message>
                </UnitTestResult>
                <UnitTestResult>
                  <TestDate>2010-03-18T18:51:37</TestDate>
                  <Status>Failure</Status>
                  <TotalFailures>6</TotalFailures>
                  <TotalSuccess>0</TotalSuccess>
                  <TotalIgnored>0</TotalIgnored>
                  <Time />
                  <Message>Child test failed</Message>
                </UnitTestResult>
                <UnitTestResult>
                  <TestDate>2010-03-18T19:03:12</TestDate>
                  <Status>Success</Status>
                  <TotalFailures>0</TotalFailures>
                  <TotalSuccess>6</TotalSuccess>
                  <TotalIgnored>0</TotalIgnored>
                  <Time />
                </UnitTestResult>
                <UnitTestResult>
                  <TestDate>2010-03-18T19:05:54</TestDate>
                  <Status>Success</Status>
                  <TotalFailures>0</TotalFailures>
                  <TotalSuccess>6</TotalSuccess>
                  <TotalIgnored>0</TotalIgnored>
                  <Time />
                </UnitTestResult>
              </Results>
              <Tests>
                <TestRecord Name="Test_Computer">
                  <Results>
                    <UnitTestResult>
                      <TestDate>2010-03-18T18:51:20</TestDate>
                      <Status>Failure</Status>
                      <TotalFailures>2</TotalFailures>
                      <TotalSuccess>0</TotalSuccess>
                      <TotalIgnored>0</TotalIgnored>
                      <Time />
                      <Message>NHibernate.HibernateException : Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
  ----&gt; System.Data.SqlClient.SqlException : Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
  ----&gt; Mono.Data.Tds.Protocol.TdsTimeoutException : Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.</Message>
                      <StackTrace>  at NHibernate.Tool.hbm2ddl.SchemaExport.Execute (System.Action`1 scriptAction, Boolean export, Boolean justDrop) [0x00000] in &lt;filename unknown&gt;:0 
  at NHibernate.Tool.hbm2ddl.SchemaExport.Execute (Boolean script, Boolean export, Boolean justDrop) [0x00000] in &lt;filename unknown&gt;:0 
  at InfoCenter.Persistence.Initializer.GetSessionFactory (Boolean isNeedRecreateScheme) [0x00000] in &lt;filename unknown&gt;:0 
  at InfoCenter.Persistence.Tests.Base_Fixture.TestFixtureSetUp () [0x00000] in &lt;filename unknown&gt;:0 
  at InfoCenter.Persistence.Tests.Test_Computer.Test_Construction () [0x00000] in &lt;filename unknown&gt;:0 
  at (wrapper managed-to-native) System.Reflection.MonoMethod:InternalInvoke (object,object[],System.Exception&amp;)
  at System.Reflection.MonoMethod.Invoke (System.Object obj, BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, System.Globalization.CultureInfo culture) [0x000ca] in /home/aidan/Projects/Mono/mono-2.6.1/mcs/class/corlib/System.Reflection/MonoMethod.cs:209 
--SqlException
  at System.Data.SqlClient.SqlConnection.Open () [0x00155] in /home/aidan/Projects/Mono/mono-2.6.1/mcs/class/System.Data/System.Data.SqlClient/SqlConnection.cs:554 
  at NHibernate.Connection.DriverConnectionProvider.GetConnection () [0x00000] in &lt;filename unknown&gt;:0 
--TdsTimeoutException
  at Mono.Data.Tds.Protocol.TdsComm..ctor (System.String dataSource, Int32 port, Int32 packetSize, Int32 timeout, TdsVersion tdsVersion) [0x0010a] in /home/aidan/Projects/Mono/mono-2.6.1/mcs/class/Mono.Data.Tds/Mono.Data.Tds.Protocol/TdsComm.cs:117 </StackTrace>
                    </UnitTestResult>
                    <UnitTestResult>
                      <TestDate>2010-03-18T18:51:37</TestDate>
                      <Status>Failure</Status>
                      <TotalFailures>2</TotalFailures>
                      <TotalSuccess>0</TotalSuccess>
                      <TotalIgnored>0</TotalIgnored>
                      <Time />
                      <Message>NHibernate.HibernateException : Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
  ----&gt; System.Data.SqlClient.SqlException : Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
  ----&gt; Mono.Data.Tds.Protocol.TdsTimeoutException : Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.</Message>
                      <StackTrace>  at NHibernate.Tool.hbm2ddl.SchemaExport.Execute (System.Action`1 scriptAction, Boolean export, Boolean justDrop) [0x00000] in &lt;filename unknown&gt;:0 
  at NHibernate.Tool.hbm2ddl.SchemaExport.Execute (Boolean script, Boolean export, Boolean justDrop) [0x00000] in &lt;filename unknown&gt;:0 
  at InfoCenter.Persistence.Initializer.GetSessionFactory (Boolean isNeedRecreateScheme) [0x00000] in &lt;filename unknown&gt;:0 
  at InfoCenter.Persistence.Tests.Base_Fixture.TestFixtureSetUp () [0x00000] in &lt;filename unknown&gt;:0 
  at InfoCenter.Persistence.Tests.Test_Computer.Test_Construction () [0x00000] in &lt;filename unknown&gt;:0 
  at (wrapper managed-to-native) System.Reflection.MonoMethod:InternalInvoke (object,object[],System.Exception&amp;)
  at System.Reflection.MonoMethod.Invoke (System.Object obj, BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, System.Globalization.CultureInfo culture) [0x000ca] in /home/aidan/Projects/Mono/mono-2.6.1/mcs/class/corlib/System.Reflection/MonoMethod.cs:209 
--SqlException
  at System.Data.SqlClient.SqlConnection.Open () [0x00155] in /home/aidan/Projects/Mono/mono-2.6.1/mcs/class/System.Data/System.Data.SqlClient/SqlConnection.cs:554 
  at NHibernate.Connection.DriverConnectionProvider.GetConnection () [0x00000] in &lt;filename unknown&gt;:0 
--TdsTimeoutException
  at Mono.Data.Tds.Protocol.TdsComm..ctor (System.String dataSource, Int32 port, Int32 packetSize, Int32 timeout, TdsVersion tdsVersion) [0x0010a] in /home/aidan/Projects/Mono/mono-2.6.1/mcs/class/Mono.Data.Tds/Mono.Data.Tds.Protocol/TdsComm.cs:117 </StackTrace>
                    </UnitTestResult>
                    <UnitTestResult>
                      <TestDate>2010-03-18T19:03:12</TestDate>
                      <Status>Success</Status>
                      <TotalFailures>0</TotalFailures>
                      <TotalSuccess>2</TotalSuccess>
                      <TotalIgnored>0</TotalIgnored>
                      <Time />
                    </UnitTestResult>
                    <UnitTestResult>
                      <TestDate>2010-03-18T19:05:54</TestDate>
                      <Status>Success</Status>
                      <TotalFailures>0</TotalFailures>
                      <TotalSuccess>2</TotalSuccess>
                      <TotalIgnored>0</TotalIgnored>
                      <Time />
                    </UnitTestResult>
                  </Results>
                  <Tests>
                    <TestRecord Name="CanAdd">
                      <Results>
                        <UnitTestResult>
                          <TestDate>2010-03-18T18:51:20</TestDate>
                          <Status>Failure</Status>
                          <TotalFailures>1</TotalFailures>
                          <TotalSuccess>0</TotalSuccess>
                          <TotalIgnored>0</TotalIgnored>
                          <Time />
                          <Message>TestFixtureSetUp failed in Test_Computer</Message>
                          <ConsoleOutput />
                          <ConsoleError />
                        </UnitTestResult>
                        <UnitTestResult>
                          <TestDate>2010-03-18T18:51:37</TestDate>
                          <Status>Failure</Status>
                          <TotalFailures>1</TotalFailures>
                          <TotalSuccess>0</TotalSuccess>
                          <TotalIgnored>0</TotalIgnored>
                          <Time />
                          <Message>TestFixtureSetUp failed in Test_Computer</Message>
                          <ConsoleOutput />
                          <ConsoleError />
                        </UnitTestResult>
                        <UnitTestResult>
                          <TestDate>2010-03-18T19:03:12</TestDate>
                          <Status>Success</Status>
                          <TotalFailures>0</TotalFailures>
                          <TotalSuccess>1</TotalSuccess>
                          <TotalIgnored>0</TotalIgnored>
                          <Time />
                          <Message>Test successful

Execution time: 1.00ms</Message>
                          <ConsoleOutput>
    
alter table Processes  drop foreign key FK36316B3DE1D1AE5D


    drop table if exists Processes

    drop table if exists Computers

    create table Processes (
        ID INTEGER NOT NULL AUTO_INCREMENT,
       Pid INTEGER,
       Name VARCHAR(255),
       ComputerID INTEGER,
       primary key (ID)
    )

    create table Computers (
        ID INTEGER NOT NULL AUTO_INCREMENT,
       Name VARCHAR(255),
       Ip VARCHAR(255),
       UserName VARCHAR(255),
       OsVersion VARCHAR(255),
       RecentActivity DATETIME,
       primary key (ID)
    )

    alter table Processes 
        add index (ComputerID), 
        add constraint FK36316B3DE1D1AE5D 
        foreign key (ComputerID) 
        references Computers (ID)

    
alter table Processes  drop foreign key FK36316B3DE1D1AE5D


    drop table if exists Processes

    drop table if exists Computers

    create table Processes (
        ID INTEGER NOT NULL AUTO_INCREMENT,
       Pid INTEGER,
       Name VARCHAR(255),
       ComputerID INTEGER,
       primary key (ID)
    )

    create table Computers (
        ID INTEGER NOT NULL AUTO_INCREMENT,
       Name VARCHAR(255),
       Ip VARCHAR(255),
       UserName VARCHAR(255),
       OsVersion VARCHAR(255),
       RecentActivity DATETIME,
       primary key (ID)
    )

    alter table Processes 
        add index (ComputerID), 
        add constraint FK36316B3DE1D1AE5D 
        foreign key (ComputerID) 
        references Computers (ID)
Init tests.. OK
</ConsoleOutput>
                          <ConsoleError />
                        </UnitTestResult>
                        <UnitTestResult>
                          <TestDate>2010-03-18T19:05:54</TestDate>
                          <Status>Success</Status>
                          <TotalFailures>0</TotalFailures>
                          <TotalSuccess>1</TotalSuccess>
                          <TotalIgnored>0</TotalIgnored>
                          <Time />
                          <Message>Test successful

Execution time: 0.89ms</Message>
                          <ConsoleOutput>
    
alter table Processes  drop foreign key FK36316B3DE1D1AE5D


    drop table if exists Processes

    drop table if exists Computers

    create table Processes (
        ID INTEGER NOT NULL AUTO_INCREMENT,
       Pid INTEGER,
       Name VARCHAR(255),
       ComputerID INTEGER,
       primary key (ID)
    )

    create table Computers (
        ID INTEGER NOT NULL AUTO_INCREMENT,
       Name VARCHAR(255),
       Ip VARCHAR(255),
       UserName VARCHAR(255),
       OsVersion VARCHAR(255),
       RecentActivity DATETIME,
       primary key (ID)
    )

    alter table Processes 
        add index (ComputerID), 
        add constraint FK36316B3DE1D1AE5D 
        foreign key (ComputerID) 
        references Computers (ID)

    
alter table Processes  drop foreign key FK36316B3DE1D1AE5D


    drop table if exists Processes

    drop table if exists Computers

    create table Processes (
        ID INTEGER NOT NULL AUTO_INCREMENT,
       Pid INTEGER,
       Name VARCHAR(255),
       ComputerID INTEGER,
       primary key (ID)
    )

    create table Computers (
        ID INTEGER NOT NULL AUTO_INCREMENT,
       Name VARCHAR(255),
       Ip VARCHAR(255),
       UserName VARCHAR(255),
       OsVersion VARCHAR(255),
       RecentActivity DATETIME,
       primary key (ID)
    )

    alter table Processes 
        add index (ComputerID), 
        add constraint FK36316B3DE1D1AE5D 
        foreign key (ComputerID) 
        references Computers (ID)
Init tests.. OK
</ConsoleOutput>
                          <ConsoleError />
                        </UnitTestResult>
                      </Results>
                      <Tests />
                    </TestRecord>
                    <TestRecord Name="CanGet">
                      <Results>
                        <UnitTestResult>
                          <TestDate>2010-03-18T18:51:20</TestDate>
                          <Status>Failure</Status>
                          <TotalFailures>1</TotalFailures>
                          <TotalSuccess>0</TotalSuccess>
                          <TotalIgnored>0</TotalIgnored>
                          <Time />
                          <Message>TestFixtureSetUp failed in Test_Computer</Message>
                          <ConsoleOutput />
                          <ConsoleError />
                        </UnitTestResult>
                        <UnitTestResult>
                          <TestDate>2010-03-18T18:51:37</TestDate>
                          <Status>Failure</Status>
                          <TotalFailures>1</TotalFailures>
                          <TotalSuccess>0</TotalSuccess>
                          <TotalIgnored>0</TotalIgnored>
                          <Time />
                          <Message>TestFixtureSetUp failed in Test_Computer</Message>
                          <ConsoleOutput />
                          <ConsoleError />
                        </UnitTestResult>
                        <UnitTestResult>
                          <TestDate>2010-03-18T19:03:12</TestDate>
                          <Status>Success</Status>
                          <TotalFailures>0</TotalFailures>
                          <TotalSuccess>1</TotalSuccess>
                          <TotalIgnored>0</TotalIgnored>
                          <Time />
                          <Message>Test successful

Execution time: 0.08ms</Message>
                          <ConsoleOutput />
                          <ConsoleError />
                        </UnitTestResult>
                        <UnitTestResult>
                          <TestDate>2010-03-18T19:05:54</TestDate>
                          <Status>Success</Status>
                          <TotalFailures>0</TotalFailures>
                          <TotalSuccess>1</TotalSuccess>
                          <TotalIgnored>0</TotalIgnored>
                          <Time />
                          <Message>Test successful

Execution time: 0.08ms</Message>
                          <ConsoleOutput />
                          <ConsoleError />
                        </UnitTestResult>
                      </Results>
                      <Tests />
                    </TestRecord>
                  </Tests>
                </TestRecord>
                <TestRecord Name="Test_Database">
                  <Results>
                    <UnitTestResult>
                      <TestDate>2010-03-18T18:51:20</TestDate>
                      <Status>Failure</Status>
                      <TotalFailures>1</TotalFailures>
                      <TotalSuccess>0</TotalSuccess>
                      <TotalIgnored>0</TotalIgnored>
                      <Time />
                      <Message>Child test failed</Message>
                    </UnitTestResult>
                    <UnitTestResult>
                      <TestDate>2010-03-18T18:51:37</TestDate>
                      <Status>Failure</Status>
                      <TotalFailures>1</TotalFailures>
                      <TotalSuccess>0</TotalSuccess>
                      <TotalIgnored>0</TotalIgnored>
                      <Time />
                      <Message>Child test failed</Message>
                    </UnitTestResult>
                    <UnitTestResult>
                      <TestDate>2010-03-18T18:56:15</TestDate>
                      <Status>Failure</Status>
                      <TotalFailures>1</TotalFailures>
                      <TotalSuccess>0</TotalSuccess>
                      <TotalIgnored>0</TotalIgnored>
                      <Time />
                      <Message>Child test failed</Message>
                    </UnitTestResult>
                    <UnitTestResult>
                      <TestDate>2010-03-18T18:57:05</TestDate>
                      <Status>Failure</Status>
                      <TotalFailures>1</TotalFailures>
                      <TotalSuccess>0</TotalSuccess>
                      <TotalIgnored>0</TotalIgnored>
                      <Time />
                      <Message>Child test failed</Message>
                    </UnitTestResult>
                    <UnitTestResult>
                      <TestDate>2010-03-18T19:03:12</TestDate>
                      <Status>Success</Status>
                      <TotalFailures>0</TotalFailures>
                      <TotalSuccess>1</TotalSuccess>
                      <TotalIgnored>0</TotalIgnored>
                      <Time />
                    </UnitTestResult>
                    <UnitTestResult>
                      <TestDate>2010-03-18T19:05:54</TestDate>
                      <Status>Success</Status>
                      <TotalFailures>0</TotalFailures>
                      <TotalSuccess>1</TotalSuccess>
                      <TotalIgnored>0</TotalIgnored>
                      <Time />
                    </UnitTestResult>
                  </Results>
                  <Tests>
                    <TestRecord Name="CanCreateSchema">
                      <Results>
                        <UnitTestResult>
                          <TestDate>2010-03-18T18:51:20</TestDate>
                          <Status>Failure</Status>
                          <TotalFailures>1</TotalFailures>
                          <TotalSuccess>0</TotalSuccess>
                          <TotalIgnored>0</TotalIgnored>
                          <Time />
                          <Message>NHibernate.HibernateException : Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
  ----&gt; System.Data.SqlClient.SqlException : Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
  ----&gt; Mono.Data.Tds.Protocol.TdsTimeoutException : Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.</Message>
                          <StackTrace>  at NHibernate.Tool.hbm2ddl.SchemaExport.Execute (System.Action`1 scriptAction, Boolean export, Boolean justDrop) [0x00000] in &lt;filename unknown&gt;:0 
  at NHibernate.Tool.hbm2ddl.SchemaExport.Execute (Boolean script, Boolean export, Boolean justDrop) [0x00000] in &lt;filename unknown&gt;:0 
  at InfoCenter.Persistence.Initializer.GetSessionFactory (Boolean isNeedRecreateScheme) [0x00000] in &lt;filename unknown&gt;:0 
  at InfoCenter.Persistence.Tests.Test_Database.CanCreateSchema () [0x00000] in &lt;filename unknown&gt;:0 
  at (wrapper managed-to-native) System.Reflection.MonoMethod:InternalInvoke (object,object[],System.Exception&amp;)
  at System.Reflection.MonoMethod.Invoke (System.Object obj, BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, System.Globalization.CultureInfo culture) [0x000ca] in /home/aidan/Projects/Mono/mono-2.6.1/mcs/class/corlib/System.Reflection/MonoMethod.cs:209 
--SqlException
  at System.Data.SqlClient.SqlConnection.Open () [0x00155] in /home/aidan/Projects/Mono/mono-2.6.1/mcs/class/System.Data/System.Data.SqlClient/SqlConnection.cs:554 
  at NHibernate.Connection.DriverConnectionProvider.GetConnection () [0x00000] in &lt;filename unknown&gt;:0 
--TdsTimeoutException
  at Mono.Data.Tds.Protocol.TdsComm..ctor (System.String dataSource, Int32 port, Int32 packetSize, Int32 timeout, TdsVersion tdsVersion) [0x0010a] in /home/aidan/Projects/Mono/mono-2.6.1/mcs/class/Mono.Data.Tds/Mono.Data.Tds.Protocol/TdsComm.cs:117 </StackTrace>
                          <ConsoleOutput />
                          <ConsoleError>18:51:53,205 ERROR [TestRunnerThread] SchemaExport [(null)]- Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---&gt; Mono.Data.Tds.Protocol.TdsTimeoutException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
  at Mono.Data.Tds.Protocol.TdsComm..ctor (System.String dataSource, Int32 port, Int32 packetSize, Int32 timeout, TdsVersion tdsVersion) [0x0010a] in /home/aidan/Projects/Mono/mono-2.6.1/mcs/class/Mono.Data.Tds/Mono.Data.Tds.Protocol/TdsComm.cs:117 
  --- End of inner exception stack trace ---
  at System.Data.SqlClient.SqlConnection.Open () [0x00155] in /home/aidan/Projects/Mono/mono-2.6.1/mcs/class/System.Data/System.Data.SqlClient/SqlConnection.cs:554 
  at NHibernate.Connection.DriverConnectionProvider.GetConnection () [0x00000] in &lt;filename unknown&gt;:0 
</ConsoleError>
                        </UnitTestResult>
                        <UnitTestResult>
                          <TestDate>2010-03-18T18:51:37</TestDate>
                          <Status>Failure</Status>
                          <TotalFailures>1</TotalFailures>
                          <TotalSuccess>0</TotalSuccess>
                          <TotalIgnored>0</TotalIgnored>
                          <Time />
                          <Message>NHibernate.HibernateException : Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
  ----&gt; System.Data.SqlClient.SqlException : Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
  ----&gt; Mono.Data.Tds.Protocol.TdsTimeoutException : Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.</Message>
                          <StackTrace>  at NHibernate.Tool.hbm2ddl.SchemaExport.Execute (System.Action`1 scriptAction, Boolean export, Boolean justDrop) [0x00000] in &lt;filename unknown&gt;:0 
  at NHibernate.Tool.hbm2ddl.SchemaExport.Execute (Boolean script, Boolean export, Boolean justDrop) [0x00000] in &lt;filename unknown&gt;:0 
  at InfoCenter.Persistence.Initializer.GetSessionFactory (Boolean isNeedRecreateScheme) [0x00000] in &lt;filename unknown&gt;:0 
  at InfoCenter.Persistence.Tests.Test_Database.CanCreateSchema () [0x00000] in &lt;filename unknown&gt;:0 
  at (wrapper managed-to-native) System.Reflection.MonoMethod:InternalInvoke (object,object[],System.Exception&amp;)
  at System.Reflection.MonoMethod.Invoke (System.Object obj, BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, System.Globalization.CultureInfo culture) [0x000ca] in /home/aidan/Projects/Mono/mono-2.6.1/mcs/class/corlib/System.Reflection/MonoMethod.cs:209 
--SqlException
  at System.Data.SqlClient.SqlConnection.Open () [0x00155] in /home/aidan/Projects/Mono/mono-2.6.1/mcs/class/System.Data/System.Data.SqlClient/SqlConnection.cs:554 
  at NHibernate.Connection.DriverConnectionProvider.GetConnection () [0x00000] in &lt;filename unknown&gt;:0 
--TdsTimeoutException
  at Mono.Data.Tds.Protocol.TdsComm..ctor (System.String dataSource, Int32 port, Int32 packetSize, Int32 timeout, TdsVersion tdsVersion) [0x0010a] in /home/aidan/Projects/Mono/mono-2.6.1/mcs/class/Mono.Data.Tds/Mono.Data.Tds.Protocol/TdsComm.cs:117 </StackTrace>
                          <ConsoleOutput />
                          <ConsoleError>18:52:09,728 ERROR [TestRunnerThread] SchemaExport [(null)]- Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---&gt; Mono.Data.Tds.Protocol.TdsTimeoutException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
  at Mono.Data.Tds.Protocol.TdsComm..ctor (System.String dataSource, Int32 port, Int32 packetSize, Int32 timeout, TdsVersion tdsVersion) [0x0010a] in /home/aidan/Projects/Mono/mono-2.6.1/mcs/class/Mono.Data.Tds/Mono.Data.Tds.Protocol/TdsComm.cs:117 
  --- End of inner exception stack trace ---
  at System.Data.SqlClient.SqlConnection.Open () [0x00155] in /home/aidan/Projects/Mono/mono-2.6.1/mcs/class/System.Data/System.Data.SqlClient/SqlConnection.cs:554 
  at NHibernate.Connection.DriverConnectionProvider.GetConnection () [0x00000] in &lt;filename unknown&gt;:0 
</ConsoleError>
                        </UnitTestResult>
                        <UnitTestResult>
                          <TestDate>2010-03-18T18:56:15</TestDate>
                          <Status>Failure</Status>
                          <TotalFailures>1</TotalFailures>
                          <TotalSuccess>0</TotalSuccess>
                          <TotalIgnored>0</TotalIgnored>
                          <Time />
                          <Message>NHibernate.HibernateException : Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
  ----&gt; System.Data.SqlClient.SqlException : Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
  ----&gt; Mono.Data.Tds.Protocol.TdsTimeoutException : Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.</Message>
                          <StackTrace>  at NHibernate.Tool.hbm2ddl.SchemaExport.Execute (System.Action`1 scriptAction, Boolean export, Boolean justDrop) [0x00000] in &lt;filename unknown&gt;:0 
  at NHibernate.Tool.hbm2ddl.SchemaExport.Execute (Boolean script, Boolean export, Boolean justDrop) [0x00000] in &lt;filename unknown&gt;:0 
  at InfoCenter.Persistence.Initializer.GetSessionFactory (Boolean isNeedRecreateScheme) [0x00000] in &lt;filename unknown&gt;:0 
  at InfoCenter.Persistence.Tests.Test_Database.CanCreateSchema () [0x00000] in &lt;filename unknown&gt;:0 
  at (wrapper managed-to-native) System.Reflection.MonoMethod:InternalInvoke (object,object[],System.Exception&amp;)
  at System.Reflection.MonoMethod.Invoke (System.Object obj, BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, System.Globalization.CultureInfo culture) [0x000ca] in /home/aidan/Projects/Mono/mono-2.6.1/mcs/class/corlib/System.Reflection/MonoMethod.cs:209 
--SqlException
  at System.Data.SqlClient.SqlConnection.Open () [0x00155] in /home/aidan/Projects/Mono/mono-2.6.1/mcs/class/System.Data/System.Data.SqlClient/SqlConnection.cs:554 
  at NHibernate.Connection.DriverConnectionProvider.GetConnection () [0x00000] in &lt;filename unknown&gt;:0 
--TdsTimeoutException
  at Mono.Data.Tds.Protocol.TdsComm..ctor (System.String dataSource, Int32 port, Int32 packetSize, Int32 timeout, TdsVersion tdsVersion) [0x0010a] in /home/aidan/Projects/Mono/mono-2.6.1/mcs/class/Mono.Data.Tds/Mono.Data.Tds.Protocol/TdsComm.cs:117 </StackTrace>
                          <ConsoleOutput />
                          <ConsoleError>18:56:32,855 ERROR [TestRunnerThread] SchemaExport [(null)]- Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---&gt; Mono.Data.Tds.Protocol.TdsTimeoutException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
  at Mono.Data.Tds.Protocol.TdsComm..ctor (System.String dataSource, Int32 port, Int32 packetSize, Int32 timeout, TdsVersion tdsVersion) [0x0010a] in /home/aidan/Projects/Mono/mono-2.6.1/mcs/class/Mono.Data.Tds/Mono.Data.Tds.Protocol/TdsComm.cs:117 
  --- End of inner exception stack trace ---
  at System.Data.SqlClient.SqlConnection.Open () [0x00155] in /home/aidan/Projects/Mono/mono-2.6.1/mcs/class/System.Data/System.Data.SqlClient/SqlConnection.cs:554 
  at NHibernate.Connection.DriverConnectionProvider.GetConnection () [0x00000] in &lt;filename unknown&gt;:0 
</ConsoleError>
                        </UnitTestResult>
                        <UnitTestResult>
                          <TestDate>2010-03-18T18:57:05</TestDate>
                          <Status>Failure</Status>
                          <TotalFailures>1</TotalFailures>
                          <TotalSuccess>0</TotalSuccess>
                          <TotalIgnored>0</TotalIgnored>
                          <Time />
                          <Message>NHibernate.HibernateException : Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
  ----&gt; System.Data.SqlClient.SqlException : Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
  ----&gt; Mono.Data.Tds.Protocol.TdsTimeoutException : Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.</Message>
                          <StackTrace>  at NHibernate.Tool.hbm2ddl.SchemaExport.Execute (System.Action`1 scriptAction, Boolean export, Boolean justDrop) [0x00000] in &lt;filename unknown&gt;:0 
  at NHibernate.Tool.hbm2ddl.SchemaExport.Execute (Boolean script, Boolean export, Boolean justDrop) [0x00000] in &lt;filename unknown&gt;:0 
  at InfoCenter.Persistence.Initializer.GetSessionFactory (Boolean isNeedRecreateScheme) [0x00000] in &lt;filename unknown&gt;:0 
  at InfoCenter.Persistence.Tests.Test_Database.CanCreateSchema () [0x00000] in &lt;filename unknown&gt;:0 
  at (wrapper managed-to-native) System.Reflection.MonoMethod:InternalInvoke (object,object[],System.Exception&amp;)
  at System.Reflection.MonoMethod.Invoke (System.Object obj, BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, System.Globalization.CultureInfo culture) [0x000ca] in /home/aidan/Projects/Mono/mono-2.6.1/mcs/class/corlib/System.Reflection/MonoMethod.cs:209 
--SqlException
  at System.Data.SqlClient.SqlConnection.Open () [0x00155] in /home/aidan/Projects/Mono/mono-2.6.1/mcs/class/System.Data/System.Data.SqlClient/SqlConnection.cs:554 
  at NHibernate.Connection.DriverConnectionProvider.GetConnection () [0x00000] in &lt;filename unknown&gt;:0 
--TdsTimeoutException
  at Mono.Data.Tds.Protocol.TdsComm..ctor (System.String dataSource, Int32 port, Int32 packetSize, Int32 timeout, TdsVersion tdsVersion) [0x0010a] in /home/aidan/Projects/Mono/mono-2.6.1/mcs/class/Mono.Data.Tds/Mono.Data.Tds.Protocol/TdsComm.cs:117 </StackTrace>
                          <ConsoleOutput />
                          <ConsoleError>18:57:21,838 ERROR [TestRunnerThread] SchemaExport [(null)]- Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---&gt; Mono.Data.Tds.Protocol.TdsTimeoutException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
  at Mono.Data.Tds.Protocol.TdsComm..ctor (System.String dataSource, Int32 port, Int32 packetSize, Int32 timeout, TdsVersion tdsVersion) [0x0010a] in /home/aidan/Projects/Mono/mono-2.6.1/mcs/class/Mono.Data.Tds/Mono.Data.Tds.Protocol/TdsComm.cs:117 
  --- End of inner exception stack trace ---
  at System.Data.SqlClient.SqlConnection.Open () [0x00155] in /home/aidan/Projects/Mono/mono-2.6.1/mcs/class/System.Data/System.Data.SqlClient/SqlConnection.cs:554 
  at NHibernate.Connection.DriverConnectionProvider.GetConnection () [0x00000] in &lt;filename unknown&gt;:0 
</ConsoleError>
                        </UnitTestResult>
                        <UnitTestResult>
                          <TestDate>2010-03-18T19:03:12</TestDate>
                          <Status>Success</Status>
                          <TotalFailures>0</TotalFailures>
                          <TotalSuccess>1</TotalSuccess>
                          <TotalIgnored>0</TotalIgnored>
                          <Time />
                          <Message>Test successful

Execution time: 0.37ms</Message>
                          <ConsoleOutput>
    
alter table Processes  drop foreign key FK36316B3DE1D1AE5D


    drop table if exists Processes

    drop table if exists Computers

    create table Processes (
        ID INTEGER NOT NULL AUTO_INCREMENT,
       Pid INTEGER,
       Name VARCHAR(255),
       ComputerID INTEGER,
       primary key (ID)
    )

    create table Computers (
        ID INTEGER NOT NULL AUTO_INCREMENT,
       Name VARCHAR(255),
       Ip VARCHAR(255),
       UserName VARCHAR(255),
       OsVersion VARCHAR(255),
       RecentActivity DATETIME,
       primary key (ID)
    )

    alter table Processes 
        add index (ComputerID), 
        add constraint FK36316B3DE1D1AE5D 
        foreign key (ComputerID) 
        references Computers (ID)
</ConsoleOutput>
                          <ConsoleError />
                        </UnitTestResult>
                        <UnitTestResult>
                          <TestDate>2010-03-18T19:05:54</TestDate>
                          <Status>Success</Status>
                          <TotalFailures>0</TotalFailures>
                          <TotalSuccess>1</TotalSuccess>
                          <TotalIgnored>0</TotalIgnored>
                          <Time />
                          <Message>Test successful

Execution time: 0.39ms</Message>
                          <ConsoleOutput>
    
alter table Processes  drop foreign key FK36316B3DE1D1AE5D


    drop table if exists Processes

    drop table if exists Computers

    create table Processes (
        ID INTEGER NOT NULL AUTO_INCREMENT,
       Pid INTEGER,
       Name VARCHAR(255),
       ComputerID INTEGER,
       primary key (ID)
    )

    create table Computers (
        ID INTEGER NOT NULL AUTO_INCREMENT,
       Name VARCHAR(255),
       Ip VARCHAR(255),
       UserName VARCHAR(255),
       OsVersion VARCHAR(255),
       RecentActivity DATETIME,
       primary key (ID)
    )

    alter table Processes 
        add index (ComputerID), 
        add constraint FK36316B3DE1D1AE5D 
        foreign key (ComputerID) 
        references Computers (ID)
</ConsoleOutput>
                          <ConsoleError />
                        </UnitTestResult>
                      </Results>
                      <Tests />
                    </TestRecord>
                  </Tests>
                </TestRecord>
                <TestRecord Name="Test_Process">
                  <Results>
                    <UnitTestResult>
                      <TestDate>2010-03-18T18:51:20</TestDate>
                      <Status>Failure</Status>
                      <TotalFailures>3</TotalFailures>
                      <TotalSuccess>0</TotalSuccess>
                      <TotalIgnored>0</TotalIgnored>
                      <Time />
                      <Message>NHibernate.HibernateException : Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
  ----&gt; System.Data.SqlClient.SqlException : Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
  ----&gt; Mono.Data.Tds.Protocol.TdsTimeoutException : Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.</Message>
                      <StackTrace>  at NHibernate.Tool.hbm2ddl.SchemaExport.Execute (System.Action`1 scriptAction, Boolean export, Boolean justDrop) [0x00000] in &lt;filename unknown&gt;:0 
  at NHibernate.Tool.hbm2ddl.SchemaExport.Execute (Boolean script, Boolean export, Boolean justDrop) [0x00000] in &lt;filename unknown&gt;:0 
  at InfoCenter.Persistence.Initializer.GetSessionFactory (Boolean isNeedRecreateScheme) [0x00000] in &lt;filename unknown&gt;:0 
  at InfoCenter.Persistence.Tests.Base_Fixture.TestFixtureSetUp () [0x00000] in &lt;filename unknown&gt;:0 
  at InfoCenter.Persistence.Tests.Test_Process.Test_Construction () [0x00000] in &lt;filename unknown&gt;:0 
  at (wrapper managed-to-native) System.Reflection.MonoMethod:InternalInvoke (object,object[],System.Exception&amp;)
  at System.Reflection.MonoMethod.Invoke (System.Object obj, BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, System.Globalization.CultureInfo culture) [0x000ca] in /home/aidan/Projects/Mono/mono-2.6.1/mcs/class/corlib/System.Reflection/MonoMethod.cs:209 
--SqlException
  at System.Data.SqlClient.SqlConnection.Open () [0x00155] in /home/aidan/Projects/Mono/mono-2.6.1/mcs/class/System.Data/System.Data.SqlClient/SqlConnection.cs:554 
  at NHibernate.Connection.DriverConnectionProvider.GetConnection () [0x00000] in &lt;filename unknown&gt;:0 
--TdsTimeoutException
  at Mono.Data.Tds.Protocol.TdsComm..ctor (System.String dataSource, Int32 port, Int32 packetSize, Int32 timeout, TdsVersion tdsVersion) [0x0010a] in /home/aidan/Projects/Mono/mono-2.6.1/mcs/class/Mono.Data.Tds/Mono.Data.Tds.Protocol/TdsComm.cs:117 </StackTrace>
                    </UnitTestResult>
                    <UnitTestResult>
                      <TestDate>2010-03-18T18:51:37</TestDate>
                      <Status>Failure</Status>
                      <TotalFailures>3</TotalFailures>
                      <TotalSuccess>0</TotalSuccess>
                      <TotalIgnored>0</TotalIgnored>
                      <Time />
                      <Message>NHibernate.HibernateException : Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
  ----&gt; System.Data.SqlClient.SqlException : Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
  ----&gt; Mono.Data.Tds.Protocol.TdsTimeoutException : Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.</Message>
                      <StackTrace>  at NHibernate.Tool.hbm2ddl.SchemaExport.Execute (System.Action`1 scriptAction, Boolean export, Boolean justDrop) [0x00000] in &lt;filename unknown&gt;:0 
  at NHibernate.Tool.hbm2ddl.SchemaExport.Execute (Boolean script, Boolean export, Boolean justDrop) [0x00000] in &lt;filename unknown&gt;:0 
  at InfoCenter.Persistence.Initializer.GetSessionFactory (Boolean isNeedRecreateScheme) [0x00000] in &lt;filename unknown&gt;:0 
  at InfoCenter.Persistence.Tests.Base_Fixture.TestFixtureSetUp () [0x00000] in &lt;filename unknown&gt;:0 
  at InfoCenter.Persistence.Tests.Test_Process.Test_Construction () [0x00000] in &lt;filename unknown&gt;:0 
  at (wrapper managed-to-native) System.Reflection.MonoMethod:InternalInvoke (object,object[],System.Exception&amp;)
  at System.Reflection.MonoMethod.Invoke (System.Object obj, BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, System.Globalization.CultureInfo culture) [0x000ca] in /home/aidan/Projects/Mono/mono-2.6.1/mcs/class/corlib/System.Reflection/MonoMethod.cs:209 
--SqlException
  at System.Data.SqlClient.SqlConnection.Open () [0x00155] in /home/aidan/Projects/Mono/mono-2.6.1/mcs/class/System.Data/System.Data.SqlClient/SqlConnection.cs:554 
  at NHibernate.Connection.DriverConnectionProvider.GetConnection () [0x00000] in &lt;filename unknown&gt;:0 
--TdsTimeoutException
  at Mono.Data.Tds.Protocol.TdsComm..ctor (System.String dataSource, Int32 port, Int32 packetSize, Int32 timeout, TdsVersion tdsVersion) [0x0010a] in /home/aidan/Projects/Mono/mono-2.6.1/mcs/class/Mono.Data.Tds/Mono.Data.Tds.Protocol/TdsComm.cs:117 </StackTrace>
                    </UnitTestResult>
                    <UnitTestResult>
                      <TestDate>2010-03-18T19:03:12</TestDate>
                      <Status>Success</Status>
                      <TotalFailures>0</TotalFailures>
                      <TotalSuccess>3</TotalSuccess>
                      <TotalIgnored>0</TotalIgnored>
                      <Time />
                    </UnitTestResult>
                    <UnitTestResult>
                      <TestDate>2010-03-18T19:05:54</TestDate>
                      <Status>Success</Status>
                      <TotalFailures>0</TotalFailures>
                      <TotalSuccess>3</TotalSuccess>
                      <TotalIgnored>0</TotalIgnored>
                      <Time />
                    </UnitTestResult>
                  </Results>
                  <Tests>
                    <TestRecord Name="CanAdd">
                      <Results>
                        <UnitTestResult>
                          <TestDate>2010-03-18T18:51:20</TestDate>
                          <Status>Failure</Status>
                          <TotalFailures>1</TotalFailures>
                          <TotalSuccess>0</TotalSuccess>
                          <TotalIgnored>0</TotalIgnored>
                          <Time />
                          <Message>TestFixtureSetUp failed in Test_Process</Message>
                          <ConsoleOutput />
                          <ConsoleError />
                        </UnitTestResult>
                        <UnitTestResult>
                          <TestDate>2010-03-18T18:51:37</TestDate>
                          <Status>Failure</Status>
                          <TotalFailures>1</TotalFailures>
                          <TotalSuccess>0</TotalSuccess>
                          <TotalIgnored>0</TotalIgnored>
                          <Time />
                          <Message>TestFixtureSetUp failed in Test_Process</Message>
                          <ConsoleOutput />
                          <ConsoleError />
                        </UnitTestResult>
                        <UnitTestResult>
                          <TestDate>2010-03-18T19:03:12</TestDate>
                          <Status>Success</Status>
                          <TotalFailures>0</TotalFailures>
                          <TotalSuccess>1</TotalSuccess>
                          <TotalIgnored>0</TotalIgnored>
                          <Time />
                          <Message>Test successful

Execution time: 0.87ms</Message>
                          <ConsoleOutput>
    
alter table Processes  drop foreign key FK36316B3DE1D1AE5D


    drop table if exists Processes

    drop table if exists Computers

    create table Processes (
        ID INTEGER NOT NULL AUTO_INCREMENT,
       Pid INTEGER,
       Name VARCHAR(255),
       ComputerID INTEGER,
       primary key (ID)
    )

    create table Computers (
        ID INTEGER NOT NULL AUTO_INCREMENT,
       Name VARCHAR(255),
       Ip VARCHAR(255),
       UserName VARCHAR(255),
       OsVersion VARCHAR(255),
       RecentActivity DATETIME,
       primary key (ID)
    )

    alter table Processes 
        add index (ComputerID), 
        add constraint FK36316B3DE1D1AE5D 
        foreign key (ComputerID) 
        references Computers (ID)

    
alter table Processes  drop foreign key FK36316B3DE1D1AE5D


    drop table if exists Processes

    drop table if exists Computers

    create table Processes (
        ID INTEGER NOT NULL AUTO_INCREMENT,
       Pid INTEGER,
       Name VARCHAR(255),
       ComputerID INTEGER,
       primary key (ID)
    )

    create table Computers (
        ID INTEGER NOT NULL AUTO_INCREMENT,
       Name VARCHAR(255),
       Ip VARCHAR(255),
       UserName VARCHAR(255),
       OsVersion VARCHAR(255),
       RecentActivity DATETIME,
       primary key (ID)
    )

    alter table Processes 
        add index (ComputerID), 
        add constraint FK36316B3DE1D1AE5D 
        foreign key (ComputerID) 
        references Computers (ID)
</ConsoleOutput>
                          <ConsoleError />
                        </UnitTestResult>
                        <UnitTestResult>
                          <TestDate>2010-03-18T19:05:54</TestDate>
                          <Status>Success</Status>
                          <TotalFailures>0</TotalFailures>
                          <TotalSuccess>1</TotalSuccess>
                          <TotalIgnored>0</TotalIgnored>
                          <Time />
                          <Message>Test successful

Execution time: 0.86ms</Message>
                          <ConsoleOutput>
    
alter table Processes  drop foreign key FK36316B3DE1D1AE5D


    drop table if exists Processes

    drop table if exists Computers

    create table Processes (
        ID INTEGER NOT NULL AUTO_INCREMENT,
       Pid INTEGER,
       Name VARCHAR(255),
       ComputerID INTEGER,
       primary key (ID)
    )

    create table Computers (
        ID INTEGER NOT NULL AUTO_INCREMENT,
       Name VARCHAR(255),
       Ip VARCHAR(255),
       UserName VARCHAR(255),
       OsVersion VARCHAR(255),
       RecentActivity DATETIME,
       primary key (ID)
    )

    alter table Processes 
        add index (ComputerID), 
        add constraint FK36316B3DE1D1AE5D 
        foreign key (ComputerID) 
        references Computers (ID)

    
alter table Processes  drop foreign key FK36316B3DE1D1AE5D


    drop table if exists Processes

    drop table if exists Computers

    create table Processes (
        ID INTEGER NOT NULL AUTO_INCREMENT,
       Pid INTEGER,
       Name VARCHAR(255),
       ComputerID INTEGER,
       primary key (ID)
    )

    create table Computers (
        ID INTEGER NOT NULL AUTO_INCREMENT,
       Name VARCHAR(255),
       Ip VARCHAR(255),
       UserName VARCHAR(255),
       OsVersion VARCHAR(255),
       RecentActivity DATETIME,
       primary key (ID)
    )

    alter table Processes 
        add index (ComputerID), 
        add constraint FK36316B3DE1D1AE5D 
        foreign key (ComputerID) 
        references Computers (ID)
</ConsoleOutput>
                          <ConsoleError />
                        </UnitTestResult>
                      </Results>
                      <Tests />
                    </TestRecord>
                    <TestRecord Name="CanGetByComputer">
                      <Results>
                        <UnitTestResult>
                          <TestDate>2010-03-18T18:51:20</TestDate>
                          <Status>Failure</Status>
                          <TotalFailures>1</TotalFailures>
                          <TotalSuccess>0</TotalSuccess>
                          <TotalIgnored>0</TotalIgnored>
                          <Time />
                          <Message>TestFixtureSetUp failed in Test_Process</Message>
                          <ConsoleOutput />
                          <ConsoleError />
                        </UnitTestResult>
                        <UnitTestResult>
                          <TestDate>2010-03-18T18:51:37</TestDate>
                          <Status>Failure</Status>
                          <TotalFailures>1</TotalFailures>
                          <TotalSuccess>0</TotalSuccess>
                          <TotalIgnored>0</TotalIgnored>
                          <Time />
                          <Message>TestFixtureSetUp failed in Test_Process</Message>
                          <ConsoleOutput />
                          <ConsoleError />
                        </UnitTestResult>
                        <UnitTestResult>
                          <TestDate>2010-03-18T19:03:12</TestDate>
                          <Status>Success</Status>
                          <TotalFailures>0</TotalFailures>
                          <TotalSuccess>1</TotalSuccess>
                          <TotalIgnored>0</TotalIgnored>
                          <Time />
                          <Message>Test successful

Execution time: 0.01ms</Message>
                          <ConsoleOutput />
                          <ConsoleError />
                        </UnitTestResult>
                        <UnitTestResult>
                          <TestDate>2010-03-18T19:05:54</TestDate>
                          <Status>Success</Status>
                          <TotalFailures>0</TotalFailures>
                          <TotalSuccess>1</TotalSuccess>
                          <TotalIgnored>0</TotalIgnored>
                          <Time />
                          <Message>Test successful

Execution time: 0.01ms</Message>
                          <ConsoleOutput />
                          <ConsoleError />
                        </UnitTestResult>
                      </Results>
                      <Tests />
                    </TestRecord>
                    <TestRecord Name="CanGetByName">
                      <Results>
                        <UnitTestResult>
                          <TestDate>2010-03-18T18:51:20</TestDate>
                          <Status>Failure</Status>
                          <TotalFailures>1</TotalFailures>
                          <TotalSuccess>0</TotalSuccess>
                          <TotalIgnored>0</TotalIgnored>
                          <Time />
                          <Message>TestFixtureSetUp failed in Test_Process</Message>
                          <ConsoleOutput />
                          <ConsoleError />
                        </UnitTestResult>
                        <UnitTestResult>
                          <TestDate>2010-03-18T18:51:37</TestDate>
                          <Status>Failure</Status>
                          <TotalFailures>1</TotalFailures>
                          <TotalSuccess>0</TotalSuccess>
                          <TotalIgnored>0</TotalIgnored>
                          <Time />
                          <Message>TestFixtureSetUp failed in Test_Process</Message>
                          <ConsoleOutput />
                          <ConsoleError />
                        </UnitTestResult>
                        <UnitTestResult>
                          <TestDate>2010-03-18T19:03:12</TestDate>
                          <Status>Success</Status>
                          <TotalFailures>0</TotalFailures>
                          <TotalSuccess>1</TotalSuccess>
                          <TotalIgnored>0</TotalIgnored>
                          <Time />
                          <Message>Test successful

Execution time: 0.02ms</Message>
                          <ConsoleOutput />
                          <ConsoleError />
                        </UnitTestResult>
                        <UnitTestResult>
                          <TestDate>2010-03-18T19:05:54</TestDate>
                          <Status>Success</Status>
                          <TotalFailures>0</TotalFailures>
                          <TotalSuccess>1</TotalSuccess>
                          <TotalIgnored>0</TotalIgnored>
                          <Time />
                          <Message>Test successful

Execution time: 0.00ms</Message>
                          <ConsoleOutput />
                          <ConsoleError />
                        </UnitTestResult>
                      </Results>
                      <Tests />
                    </TestRecord>
                  </Tests>
                </TestRecord>
              </Tests>
            </TestRecord>
          </Tests>
        </TestRecord>
      </Tests>
    </TestRecord>
  </Tests>
</TestRecord>

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Ilya Builuk
Software Developer (Senior) Nokia
Germany Germany
Interested in design/development of framework functionality using the best patterns and practices.

Comments and Discussions

Permalink
Advertise
Privacy
Cookies
Terms of Use
Layout: fixed | fluid

Posted 22 Mar 2010

Article Copyright 2010 by Ilya Builuk
Everything else Copyright © CodeProject, 1999-2024

Web04 2.8:2024-04-02:1