Index: src/Plugins/Wti/Wti.Data/PipingSoilLayer.cs
===================================================================
diff -u -re5c186677d0ef8697eb04ea571b7c4ef8268183c -r356ac6ef31864aa207c8af9470df3349f8e4d1f1
--- src/Plugins/Wti/Wti.Data/PipingSoilLayer.cs	(.../PipingSoilLayer.cs)	(revision e5c186677d0ef8697eb04ea571b7c4ef8268183c)
+++ src/Plugins/Wti/Wti.Data/PipingSoilLayer.cs	(.../PipingSoilLayer.cs)	(revision 356ac6ef31864aa207c8af9470df3349f8e4d1f1)
@@ -1,12 +1,10 @@
-namespace Wti.Data
+using System.Collections.Generic;
+
+namespace Wti.Data
 {
     public class PipingSoilLayer
     {
-        public PipingSoilLayer(long id)
-        {
-            Id = id;
-        }
-
-        public long Id { get; private set; }
+        public HashSet<Point3D> OuterLoop { get; set; }
+        public HashSet<Point3D> InnerLoop { get; set; }
     }
 }
\ No newline at end of file
Index: src/Plugins/Wti/Wti.Data/PipingSoilProfile.cs
===================================================================
diff -u -r2d05e18d1fcde2d8d00d2434a6e560d65337d2f7 -r356ac6ef31864aa207c8af9470df3349f8e4d1f1
--- src/Plugins/Wti/Wti.Data/PipingSoilProfile.cs	(.../PipingSoilProfile.cs)	(revision 2d05e18d1fcde2d8d00d2434a6e560d65337d2f7)
+++ src/Plugins/Wti/Wti.Data/PipingSoilProfile.cs	(.../PipingSoilProfile.cs)	(revision 356ac6ef31864aa207c8af9470df3349f8e4d1f1)
@@ -1,28 +1,31 @@
-using System.Collections.Generic;
+using System.Collections;
+using System.Collections.Generic;
 
 namespace Wti.Data
 {
     /// <summary>
     /// This class represents a soil profile, which was imported for use in a piping calculation.
     /// </summary>
-    public class PipingSoilProfile
+    public class PipingSoilProfile : IEnumerable<PipingSoilLayer>
     {
-        public PipingSoilProfile(long id, string name)
+        public PipingSoilProfile(string name, IEnumerable<PipingSoilLayer> layers)
         {
-            Id = id;
             Name = name;
-            Layers = new List<PipingSoilLayer>();
+            Layers = layers;
         }
 
         public string Name { get; private set; }
 
-        private ICollection<PipingSoilLayer> Layers { get; set; }
+        public IEnumerator<PipingSoilLayer> GetEnumerator()
+        {
+            return Layers.GetEnumerator();
+        }
 
-        public long Id { get; private set; }
-
-        public void Add(PipingSoilLayer pipingSoilLayer)
+        IEnumerator IEnumerable.GetEnumerator()
         {
-            Layers.Add(pipingSoilLayer);
+            return GetEnumerator();
         }
+
+        public IEnumerable<PipingSoilLayer> Layers { get; private set; }
     }
 }
\ No newline at end of file
Index: src/Plugins/Wti/Wti.Data/Point3D.cs
===================================================================
diff -u -rc42d0c47753135357002db6026ebbefc3603a62b -r356ac6ef31864aa207c8af9470df3349f8e4d1f1
--- src/Plugins/Wti/Wti.Data/Point3D.cs	(.../Point3D.cs)	(revision c42d0c47753135357002db6026ebbefc3603a62b)
+++ src/Plugins/Wti/Wti.Data/Point3D.cs	(.../Point3D.cs)	(revision 356ac6ef31864aa207c8af9470df3349f8e4d1f1)
@@ -19,5 +19,43 @@
         /// Gets or sets the z coordinate.
         /// </summary>
         public double Z { get; set; }
+
+        public override bool Equals(object obj)
+        {
+            if (ReferenceEquals(null, obj))
+            {
+                return false;
+            }
+            if (ReferenceEquals(this, obj))
+            {
+                return true;
+            }
+            if (obj.GetType() != GetType())
+            {
+                return false;
+            }
+            return Equals((Point3D) obj);
+        }
+
+        public override int GetHashCode()
+        {
+            unchecked
+            {
+                var hashCode = X.GetHashCode();
+                hashCode = (hashCode*397) ^ Y.GetHashCode();
+                hashCode = (hashCode*397) ^ Z.GetHashCode();
+                return hashCode;
+            }
+        }
+
+        /// <summary>
+        /// Compares the <see cref="Point3D"/> with <paramref name="other"/> based on <see cref="X"/>, <see cref="Y"/> and <see cref="Z"/>.
+        /// </summary>
+        /// <param name="other">A <see cref="Point3D"/> to compare with.</param>
+        /// <returns>True if the coordinates of the <see cref="Point3D"/> matches the coordinate of <paramref name="other"/>. False otherwise.</returns>
+        protected bool Equals(Point3D other)
+        {
+            return X.Equals(other.X) && Y.Equals(other.Y) && Z.Equals(other.Z);
+        }
     }
 }
\ No newline at end of file
Index: src/Plugins/Wti/Wti.IO/Exceptions/PipingSoilProfileReadException.cs
===================================================================
diff -u
--- src/Plugins/Wti/Wti.IO/Exceptions/PipingSoilProfileReadException.cs	(revision 0)
+++ src/Plugins/Wti/Wti.IO/Exceptions/PipingSoilProfileReadException.cs	(revision 356ac6ef31864aa207c8af9470df3349f8e4d1f1)
@@ -0,0 +1,37 @@
+using System;
+using Wti.Data;
+
+namespace Wti.IO.Exceptions
+{
+    /// <summary>
+    /// Exception thrown when something went wrong while reading <see cref="PipingSoilProfile"/> in <see cref="PipingSoilProfileReader"/>.
+    /// </summary>
+    public class PipingSoilProfileReadException : Exception
+    {
+        /// <summary>
+        /// Initializes a new instance of the <see cref="PipingSoilProfileReadException"/> class.
+        /// </summary>
+        public PipingSoilProfileReadException()
+        {
+        }
+
+        /// <summary>
+        /// Initializes a new instance of the <see cref="PipingSoilProfileReadException"/> class 
+        /// with a specified error message.
+        /// </summary>
+        /// <param name="message">The message that describes the error.</param>
+        public PipingSoilProfileReadException(string message)
+            : base(message)
+        {
+        }
+
+        /// <summary>
+        /// Initializes a new instance of the System.Exception class with a specified error message 
+        /// and a reference to the inner exception that is the cause of this exception.
+        /// </summary>
+        /// <param name="message">The error message that explains the reason for the exception.</param>
+        /// <param name="innerException">The exception that is the cause of the current exception, or a 
+        /// null reference if no inner exception is specified.</param>
+        public PipingSoilProfileReadException(string message, Exception innerException) : base(message, innerException) { }
+    }
+}
\ No newline at end of file
Index: src/Plugins/Wti/Wti.IO/PipingSoilLayerReader.cs
===================================================================
diff -u
--- src/Plugins/Wti/Wti.IO/PipingSoilLayerReader.cs	(revision 0)
+++ src/Plugins/Wti/Wti.IO/PipingSoilLayerReader.cs	(revision 356ac6ef31864aa207c8af9470df3349f8e4d1f1)
@@ -0,0 +1,159 @@
+using System;
+using System.Collections.Generic;
+using System.IO;
+using System.Xml;
+using Wti.Data;
+
+namespace Wti.IO
+{
+    /// <summary>
+    /// This class is responsible for reading an array of bytes and interpret this as a XML document, which contains information about
+    /// the geometry of a <see cref="PipingSoilLayer"/>.
+    /// </summary>
+    internal class PipingSoilLayerReader
+    {
+        private const string outerLoopElementName = "OuterLoop";
+        private const string innerLoopElementName = "InnerLoop";
+        private const string endPointElementName = "EndPoint";
+        private const string headPointElementName = "HeadPoint";
+        private const string xElementName = "X";
+        private const string yElementName = "Y";
+        private const string zElementName = "Z";
+
+        private readonly XmlTextReader xmlTextReader;
+
+        /// <summary>
+        /// Constructs a new <see cref="PipingSoilLayerReader"/>, which uses the <paramref name="geometry"/> as the source of the 
+        /// geometry for a <see cref="PipingSoilLayer"/>.
+        /// </summary>
+        /// <param name="geometry">An array of <see cref="byte"/> which contains the information of a <see cref="PipingSoilLayer"/>
+        /// in an XML document.</param>
+        internal PipingSoilLayerReader(byte[] geometry)
+        {
+            xmlTextReader = new XmlTextReader(new MemoryStream(geometry));
+        }
+
+        /// <summary>
+        /// Reads the XML document and from this obtains the required information and constructs a <see cref="PipingSoilLayer"/> based
+        /// on this information.
+        /// </summary>
+        /// <returns>A new <see cref="PipingSoilLayer"/> with information taken from the XML document.</returns>
+        /// <exception cref="XmlException">When reading from the XML document of the <see cref="PipingSoilLayerReader"/> failed.</exception>
+        internal PipingSoilLayer Read()
+        {
+            var pipingSoilLayer = new PipingSoilLayer();
+
+            while (xmlTextReader.Read())
+            {
+                HashSet<Point3D> outerLoop;
+                HashSet<Point3D> innerLoop;
+                if (TryParseLoop(outerLoopElementName, out outerLoop))
+                {
+                    pipingSoilLayer.OuterLoop = outerLoop;
+                }
+                if (TryParseLoop(innerLoopElementName, out innerLoop))
+                {
+                    pipingSoilLayer.InnerLoop = innerLoop;
+                }
+            }
+
+            return pipingSoilLayer;
+        }
+
+        /// <summary>
+        /// Tries to parse the element with the given <paramref name="elementName"/>, which the reader should be currently pointing at, as a loop.
+        /// </summary>
+        /// <param name="elementName">The name of the element which the reader should be currently pointing at.</param>
+        /// <param name="loop">The result of parsing the element as a loop. <c>null</c> if the current element's name does not match <paramref name="elementName"/>.</param>
+        /// <returns>True if the reader currently points to an element with name <paramref name="elementName"/>. False otherwise.</returns>
+        private bool TryParseLoop(String elementName, out HashSet<Point3D> loop)
+        {
+            loop = null;
+
+            if (IsElementWithName(elementName))
+            {
+                loop = new HashSet<Point3D>();
+
+                while (xmlTextReader.Read() && !IsEndElementWithName(elementName))
+                {
+                    Point3D parsedPoint;
+                    if (TryParsePoint(out parsedPoint))
+                    {
+                        loop.Add(parsedPoint);
+                    }
+                }
+
+                return true;
+            }
+            return false;
+        }
+
+        /// <summary>
+        /// Tries to parse the element which the reader is currently pointing at as a point.
+        /// </summary>
+        /// <param name="point">The result of parsing the element as a point. <c>null</c> if current element is not a head or end point.</param>
+        /// <returns>True if the reader currently points to an element with name <see cref="headPointElementName"/> or <see cref="endPointElementName"/>. False otherwise.</returns>
+        private bool TryParsePoint(out Point3D point)
+        {
+            point = null;
+
+            if (IsElementWithName(headPointElementName) || IsElementWithName(endPointElementName))
+            {
+                var pointValues = ReadChildValues();
+                point = new Point3D
+                {
+                    X = double.Parse(pointValues[xElementName]),
+                    Y = double.Parse(pointValues[yElementName]),
+                    Z = double.Parse(pointValues[zElementName])
+                };
+                return true;
+            }
+            return false;
+        }
+
+        /// <summary>
+        /// Reads the name and values for the children of the current element and puts them in a name indexed dictionary.
+        /// </summary>
+        /// <returns>A <see cref="Dictionary{TKey,TValue}"/>. For each entry, key is equal to child element name and value is equal to the value of the child element's text node.</returns>
+        private Dictionary<string, string> ReadChildValues()
+        {
+            string elementName = xmlTextReader.Name;
+            var nodeSibblings = new Dictionary<string, string>();
+
+            while (xmlTextReader.Read() && !IsEndElementWithName(elementName))
+            {
+                if (xmlTextReader.NodeType == XmlNodeType.Element)
+                {
+                    nodeSibblings[xmlTextReader.Name] = xmlTextReader.ReadString();
+                }
+            }
+
+            return nodeSibblings;
+        }
+
+        /// <summary>
+        /// Checks whether the element the reader is currently pointing at is of <see cref="XmlNodeType.Element"/> type and has a name equal to <paramref name="name"/>.
+        /// </summary>
+        /// <param name="name">The name which the element should have.</param>
+        /// <returns>True if the current element has type <see cref="XmlNodeType.Element"/> and its name is equal to <paramref name="name"/>.</returns>
+        private bool IsElementWithName(string name)
+        {
+            var isElement = xmlTextReader.NodeType == XmlNodeType.Element;
+            var isPoint = xmlTextReader.Name == name;
+
+            return isElement && isPoint;
+        }
+        /// <summary>
+        /// Checks whether the element the reader is currently pointing at is of <see cref="XmlNodeType.EndElement"/> type and has a name equal to <paramref name="name"/>.
+        /// </summary>
+        /// <param name="name">The name which the end element should have.</param>
+        /// <returns>True if the current element has type <see cref="XmlNodeType.EndElement"/> and its name is equal to <paramref name="name"/>.</returns>
+        private bool IsEndElementWithName(string name)
+        {
+            var isElement = xmlTextReader.NodeType == XmlNodeType.EndElement;
+            var isPoint = xmlTextReader.Name == name;
+
+            return isElement && isPoint;
+        }
+    }
+}
\ No newline at end of file
Index: src/Plugins/Wti/Wti.IO/PipingSoilProfileReader.cs
===================================================================
diff -u
--- src/Plugins/Wti/Wti.IO/PipingSoilProfileReader.cs	(revision 0)
+++ src/Plugins/Wti/Wti.IO/PipingSoilProfileReader.cs	(revision 356ac6ef31864aa207c8af9470df3349f8e4d1f1)
@@ -0,0 +1,146 @@
+using System;
+using System.Collections.Generic;
+using System.Collections.ObjectModel;
+using System.Data;
+using System.Data.SQLite;
+using System.IO;
+using System.Linq;
+using System.Xml;
+using Wti.Data;
+using Wti.IO.Exceptions;
+using Wti.IO.Properties;
+
+namespace Wti.IO
+{
+    /// <summary>
+    /// This class reads a SqLite database file and constructs <see cref="PipingSoilProfile"/> from this database.
+    /// The database is created with the DSoilModel application.
+    /// </summary>
+    public class PipingSoilProfileReader : IDisposable
+    {
+        private const int pipingMechanismId = 4;
+        private const int profileNameIndex = 0;
+        private const int profileLayerGeometryIndex = 1;
+        private SQLiteConnection connection;
+        private SQLiteDataReader dataReader;
+
+        /// <summary>
+        /// Creates a new instance of <see cref="PipingSoilProfileReader"/> which will use the <paramref name="dbFile"/>
+        /// as its source.
+        /// </summary>
+        /// <param name="dbFile"></param>
+        public PipingSoilProfileReader(string dbFile)
+        {
+            if (String.IsNullOrEmpty(dbFile))
+            {
+                throw new ArgumentException(Resources.Error_PathMustBeSpecified);
+            }
+            if (!File.Exists(dbFile))
+            {
+                throw new FileNotFoundException(String.Format(Resources.Error_File_0_does_not_exist, dbFile));
+            }
+
+            PrepareConnection(dbFile);
+            Connect();
+        }
+
+        /// <summary>
+        /// Creates instances of <see cref="PipingSoilProfile"/> based on the database file of the <see cref="PipingSoilProfileReader"/>.
+        /// </summary>
+        /// <returns></returns>
+        /// <exception cref="PipingSoilProfileReadException">Thrown when reading soil profile entries from the database failed.</exception>
+        /// <exception cref="XmlException">Thrown when parsing the geometry of a soil layer failed.</exception>
+        public IEnumerable<PipingSoilProfile> Read()
+        {
+            var pipingSoilProfiles = new Dictionary<string, ICollection<PipingSoilLayer>>();
+
+            CreateDataReader();
+
+            while (dataReader.Read())
+            {
+                var profileName = (string) dataReader[profileNameIndex];
+                if (!pipingSoilProfiles.ContainsKey(profileName))
+                {
+                    pipingSoilProfiles.Add(profileName, new Collection<PipingSoilLayer>());
+                }
+
+                pipingSoilProfiles[profileName].Add(ReadPipingSoilLayer());
+            }
+
+            return pipingSoilProfiles.Select(keyValue => new PipingSoilProfile(keyValue.Key, keyValue.Value));
+        }
+
+        public void Dispose()
+        {
+            dataReader.Dispose();
+            connection.Dispose();
+        }
+
+        private void PrepareConnection(string dbFile)
+        {
+            var connectionStringBuilder = new SQLiteConnectionStringBuilder
+            {
+                FailIfMissing = true,
+                DataSource = dbFile,
+                ReadOnly = true,
+                ForeignKeys = true
+            };
+
+            connection = new SQLiteConnection(connectionStringBuilder.ConnectionString);
+        }
+
+        private void Connect()
+        {
+            try
+            {
+                connection.Open();
+            }
+            catch (SQLiteException)
+            {
+                connection.Dispose();
+            }
+        }
+
+        private PipingSoilLayer ReadPipingSoilLayer()
+        {
+            var columnValue = dataReader[profileLayerGeometryIndex];
+            var geometry = (byte[]) columnValue;
+            return new PipingSoilLayerReader(geometry).Read();
+        }
+
+        /// <summary>
+        /// Creates a new data reader to use in this class, based on a query which returns all the known soil layers for which its profile has a X coordinate defined for piping.
+        /// </summary>
+        private void CreateDataReader()
+        {
+            var mechanismParameterName = "mechanism";
+            var query = new SQLiteCommand(connection)
+            {
+                CommandText = string.Format(
+                    "SELECT p.SP2D_Name, l.GeometrySurface " +
+                    "FROM MechanismPointLocation as m " +
+                    "JOIN SoilProfile2D as p ON m.SP2D_ID = p.SP2D_ID " +
+                    "JOIN SoilLayer2D as l ON l.SP2D_ID = p.SP2D_ID " +
+                    "WHERE m.ME_ID = @{0} " +
+                    "ORDER BY p.SP2D_ID, l.SP2D_ID",
+                    mechanismParameterName)
+            };
+
+            query.Parameters.Add(new SQLiteParameter
+            {
+                DbType = DbType.Int32,
+                Value = pipingMechanismId,
+                ParameterName = mechanismParameterName
+            });
+
+            try
+            {
+                dataReader = query.ExecuteReader();
+            }
+            catch (SQLiteException e)
+            {
+                throw new PipingSoilProfileReadException(string.Format(Resources.Error_SoilProfileReadFromDatabase, connection.DataSource), e);
+            }
+        }
+    }
+}
\ No newline at end of file
Fisheye: Tag 356ac6ef31864aa207c8af9470df3349f8e4d1f1 refers to a dead (removed) revision in file `src/Plugins/Wti/Wti.IO/PipingSoilProfilesReader.cs'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: src/Plugins/Wti/Wti.IO/Properties/AssemblyInfo.cs
===================================================================
diff -u -r5fc71a385897af92ccb092f2f969b5709afab85a -r356ac6ef31864aa207c8af9470df3349f8e4d1f1
--- src/Plugins/Wti/Wti.IO/Properties/AssemblyInfo.cs	(.../AssemblyInfo.cs)	(revision 5fc71a385897af92ccb092f2f969b5709afab85a)
+++ src/Plugins/Wti/Wti.IO/Properties/AssemblyInfo.cs	(.../AssemblyInfo.cs)	(revision 356ac6ef31864aa207c8af9470df3349f8e4d1f1)
@@ -1,6 +1,8 @@
 using System.Reflection;
+using System.Runtime.CompilerServices;
 using System.Runtime.InteropServices;
 
 [assembly: AssemblyTitle("Wti.IO")]
 [assembly: AssemblyProduct("Wti.IO")]
-[assembly: Guid("f5af3cbe-d10c-42a5-b625-95222648aeaf")]
\ No newline at end of file
+[assembly: Guid("f5af3cbe-d10c-42a5-b625-95222648aeaf")]
+[assembly: InternalsVisibleTo("Wti.IO.Test")]
\ No newline at end of file
Index: src/Plugins/Wti/Wti.IO/Properties/Resources.Designer.cs
===================================================================
diff -u -recfa21abcbbd04db3963323e308dd0b94c8cb7a0 -r356ac6ef31864aa207c8af9470df3349f8e4d1f1
--- src/Plugins/Wti/Wti.IO/Properties/Resources.Designer.cs	(.../Resources.Designer.cs)	(revision ecfa21abcbbd04db3963323e308dd0b94c8cb7a0)
+++ src/Plugins/Wti/Wti.IO/Properties/Resources.Designer.cs	(.../Resources.Designer.cs)	(revision 356ac6ef31864aa207c8af9470df3349f8e4d1f1)
@@ -1,7 +1,7 @@
 //------------------------------------------------------------------------------
 // <auto-generated>
 //     This code was generated by a tool.
-//     Runtime Version:4.0.30319.18444
+//     Runtime Version:4.0.30319.34209
 //
 //     Changes to this file may cause incorrect behavior and will be lost if
 //     the code is regenerated.
@@ -133,6 +133,15 @@
         }
         
         /// <summary>
+        ///   Looks up a localized string similar to Kon geen ondergrond profielen verkrijgen van de database &apos;{0}&apos;..
+        /// </summary>
+        public static string Error_SoilProfileReadFromDatabase {
+            get {
+                return ResourceManager.GetString("Error_SoilProfileReadFromDatabase", resourceCulture);
+            }
+        }
+        
+        /// <summary>
         ///   Looks up a localized string similar to Het bestand op &apos;{0}&apos; heeft op regel {1} teveel tekst om in het RAM geheugen opgeslagen te worden..
         /// </summary>
         public static string Error_Unexpected_IOError_File_0_Line_1_ {
Index: src/Plugins/Wti/Wti.IO/Properties/Resources.resx
===================================================================
diff -u -recfa21abcbbd04db3963323e308dd0b94c8cb7a0 -r356ac6ef31864aa207c8af9470df3349f8e4d1f1
--- src/Plugins/Wti/Wti.IO/Properties/Resources.resx	(.../Resources.resx)	(revision ecfa21abcbbd04db3963323e308dd0b94c8cb7a0)
+++ src/Plugins/Wti/Wti.IO/Properties/Resources.resx	(.../Resources.resx)	(revision 356ac6ef31864aa207c8af9470df3349f8e4d1f1)
@@ -147,4 +147,7 @@
   <data name="PipingSurfaceLinesCsvReader_File_0_invalid_header" xml:space="preserve">
     <value>Het bestand op '{0}' is niet geschikt om dwarsdoorsneden uit te lezen (Verwachte header: locationid;X1;Y1;Z1).</value>
   </data>
+  <data name="Error_SoilProfileReadFromDatabase" xml:space="preserve">
+    <value>Kon geen ondergrond profielen verkrijgen van de database '{0}'.</value>
+  </data>
 </root>
\ No newline at end of file
Index: src/Plugins/Wti/Wti.IO/Wti.IO.csproj
===================================================================
diff -u -rf2284364cde43ab7969dd8f0fb038f846138ec41 -r356ac6ef31864aa207c8af9470df3349f8e4d1f1
--- src/Plugins/Wti/Wti.IO/Wti.IO.csproj	(.../Wti.IO.csproj)	(revision f2284364cde43ab7969dd8f0fb038f846138ec41)
+++ src/Plugins/Wti/Wti.IO/Wti.IO.csproj	(.../Wti.IO.csproj)	(revision 356ac6ef31864aa207c8af9470df3349f8e4d1f1)
@@ -51,7 +51,9 @@
       <Link>Properties\GlobalAssembly.cs</Link>
     </Compile>
     <Compile Include="Exceptions\CriticalFileReadException.cs" />
-    <Compile Include="PipingSoilProfilesReader.cs" />
+    <Compile Include="Exceptions\PipingSoilProfileReadException.cs" />
+    <Compile Include="PipingSoilLayerReader.cs" />
+    <Compile Include="PipingSoilProfileReader.cs" />
     <Compile Include="PipingSurfaceLinesCsvReader.cs" />
     <Compile Include="Properties\AssemblyInfo.cs" />
     <Compile Include="Properties\Resources.Designer.cs">
Index: test/Plugins/Wti/Wti.Calculation.TestUtil/TestPipingSoilProfile.cs
===================================================================
diff -u -re5c186677d0ef8697eb04ea571b7c4ef8268183c -r356ac6ef31864aa207c8af9470df3349f8e4d1f1
--- test/Plugins/Wti/Wti.Calculation.TestUtil/TestPipingSoilProfile.cs	(.../TestPipingSoilProfile.cs)	(revision e5c186677d0ef8697eb04ea571b7c4ef8268183c)
+++ test/Plugins/Wti/Wti.Calculation.TestUtil/TestPipingSoilProfile.cs	(.../TestPipingSoilProfile.cs)	(revision 356ac6ef31864aa207c8af9470df3349f8e4d1f1)
@@ -4,6 +4,6 @@
 {
     public class TestPipingSoilProfile : PipingSoilProfile
     {
-        public TestPipingSoilProfile() : base(0, "") {}
+        public TestPipingSoilProfile() : base("", null) {}
     }
 }
\ No newline at end of file
Index: test/Plugins/Wti/Wti.Data.Test/Point3DTest.cs
===================================================================
diff -u -rc42d0c47753135357002db6026ebbefc3603a62b -r356ac6ef31864aa207c8af9470df3349f8e4d1f1
--- test/Plugins/Wti/Wti.Data.Test/Point3DTest.cs	(.../Point3DTest.cs)	(revision c42d0c47753135357002db6026ebbefc3603a62b)
+++ test/Plugins/Wti/Wti.Data.Test/Point3DTest.cs	(.../Point3DTest.cs)	(revision 356ac6ef31864aa207c8af9470df3349f8e4d1f1)
@@ -1,4 +1,5 @@
-using NUnit.Framework;
+using System;
+using NUnit.Framework;
 
 namespace Wti.Data.Test
 {
@@ -33,5 +34,107 @@
             Assert.AreEqual(2.2, point.Y);
             Assert.AreEqual(-1.1, point.Z);
         }
+
+        [Test]
+        public void Equals_ToItself_ReturnsTrue()
+        {
+            // Setup
+            var point = new Point3D();
+
+            // Call
+            var result = point.Equals(point);
+
+            // Assert
+            Assert.IsTrue(result);
+        }
+
+        [Test]
+        [TestCase(0,0,0)]
+        [TestCase(1,2,3)]
+        [TestCase(3.5,3.6,3.7)]
+        public void Equals_OtherWithSameCoordinates_ReturnsTrue(double x, double y, double z)
+        {
+            // Setup
+            var point = new Point3D
+            {
+                X = x,
+                Y = y,
+                Z = z
+            };
+            var otherPoint = new Point3D
+            {
+                X = x,
+                Y = y,
+                Z = z
+            };
+
+            // Call
+            var result = point.Equals(otherPoint);
+
+            // Assert
+            Assert.IsTrue(result);
+        }
+
+        [Test]
+        [TestCase(1e-8, 0, 0)]
+        [TestCase(0, 1e-8, 0)]
+        [TestCase(0, 0, 1e-8)]
+        public void Equals_CloseToOtherPoint_ReturnsFalse(double deltaX, double deltaY, double deltaZ)
+        {
+            // Setup
+            var random = new Random(22);
+            var x = random.NextDouble();
+            var y = random.NextDouble();
+            var z = random.NextDouble();
+            
+            var point = new Point3D
+            {
+                X = x,
+                Y = y,
+                Z = z
+            };
+            var otherPoint = new Point3D
+            {
+                X = x + deltaX,
+                Y = y + deltaY,
+                Z = z + deltaZ
+            };
+
+            // Call
+            var result = point.Equals(otherPoint);
+
+            // Assert
+            Assert.IsFalse(result);
+        }
+
+        [Test]
+        public void GetHashCode_PointsAreEqual_PointsHashesEqual()
+        {
+            // Setup
+            var random = new Random(22);
+            var x = random.NextDouble();
+            var y = random.NextDouble();
+            var z = random.NextDouble();
+
+            var point = new Point3D
+            {
+                X = x,
+                Y = y,
+                Z = z
+            };
+            var otherPoint = new Point3D
+            {
+                X = x,
+                Y = y,
+                Z = z
+            };
+
+            // Call
+            var result = point.GetHashCode();
+            var otherResult = otherPoint.GetHashCode();
+
+            // Assert
+            Assert.AreEqual(result, otherResult);
+        }
     }
 }
\ No newline at end of file
Index: test/Plugins/Wti/Wti.IO.Test/Exceptions/PipingSoilProfileReadExceptionTest.cs
===================================================================
diff -u
--- test/Plugins/Wti/Wti.IO.Test/Exceptions/PipingSoilProfileReadExceptionTest.cs	(revision 0)
+++ test/Plugins/Wti/Wti.IO.Test/Exceptions/PipingSoilProfileReadExceptionTest.cs	(revision 356ac6ef31864aa207c8af9470df3349f8e4d1f1)
@@ -0,0 +1,52 @@
+using System;
+using NUnit.Framework;
+using Wti.IO.Exceptions;
+
+namespace Wti.IO.Test.Exceptions
+{
+    public class PipingSoilProfileReadExceptionTest
+    {
+        [Test]
+        public void DefaultConstructor_InnerExceptionNullAndMessageDefault()
+        {
+            // Setup
+            var expectedMessage = String.Format("Exception of type '{0}' was thrown.", typeof(PipingSoilProfileReadException).FullName);
+
+            // Call
+            var exception = new PipingSoilProfileReadException();
+
+            // Assert
+            Assert.IsNull(exception.InnerException);
+            Assert.AreEqual(expectedMessage, exception.Message);
+        }
+
+        [Test]
+        public void Constructor_WithCustomMessage_InnerExceptionNullAndMessageSetToCustom()
+        {
+            // Setup
+            var expectedMessage ="Some exception message";
+
+            // Call
+            var exception = new PipingSoilProfileReadException(expectedMessage);
+
+            // Assert
+            Assert.IsNull(exception.InnerException);
+            Assert.AreEqual(expectedMessage, exception.Message);
+        }
+
+        [Test]
+        public void Constructor_WithCustomMessageAndInnerException_InnerExceptionSetAndMessageSetToCustom()
+        {
+            // Setup
+            var expectedMessage = "Some exception message";
+            var expectedInnerException = new Exception();
+
+            // Call
+            var exception = new PipingSoilProfileReadException(expectedMessage, expectedInnerException);
+
+            // Assert
+            Assert.AreSame(expectedInnerException, exception.InnerException);
+            Assert.AreEqual(expectedMessage, exception.Message);
+        }
+    }
+}
\ No newline at end of file
Index: test/Plugins/Wti/Wti.IO.Test/PipingSoilProfileReaderTest.cs
===================================================================
diff -u
--- test/Plugins/Wti/Wti.IO.Test/PipingSoilProfileReaderTest.cs	(revision 0)
+++ test/Plugins/Wti/Wti.IO.Test/PipingSoilProfileReaderTest.cs	(revision 356ac6ef31864aa207c8af9470df3349f8e4d1f1)
@@ -0,0 +1,117 @@
+using System;
+using System.Collections.Generic;
+using System.IO;
+using System.Linq;
+using DelftTools.TestUtils;
+using NUnit.Framework;
+using Wti.Data;
+using Wti.IO.Exceptions;
+using Wti.IO.Properties;
+
+namespace Wti.IO.Test
+{
+    public class PipingSoilProfileReaderTest
+    {
+
+        private readonly string testDataPath = TestHelper.GetTestDataPath(TestDataPath.Plugins.Wti.WtiIOPath, "PipingSoilProfilesReader");
+
+        [Test]
+        public void Constructor_CorrectPath_ReturnsNewInstance()
+        {
+            // Setup
+            var testFile = "empty.soil";
+
+            // Call
+            var pipingSoilProfilesReader = new PipingSoilProfileReader(Path.Combine(testDataPath, testFile));
+             
+            // Assert
+            Assert.NotNull(pipingSoilProfilesReader);
+        }
+
+        [Test]
+        public void Constructor_NonExistingPath_ThrowsFileNotFoundException()
+        {
+            // Setup
+            var testFile = Path.Combine(testDataPath, "none.soil");
+
+            // Call
+            TestDelegate test = () => new PipingSoilProfileReader(testFile);
+
+            // Assert
+            var exception = Assert.Throws<FileNotFoundException>(test);
+            Assert.AreEqual(String.Format(Resources.Error_File_0_does_not_exist, testFile), exception.Message);
+        }
+
+        [Test]
+        [TestCase(null)]
+        [TestCase("")]
+        public void ReadSoilProfiles_NullOrEmpty_ThrowsArgumentException(string fileName)
+        {
+            // Call
+            TestDelegate test = () => new PipingSoilProfileReader(fileName);
+
+            // Assert
+            var exception = Assert.Throws<ArgumentException>(test);
+            Assert.AreEqual(Resources.Error_PathMustBeSpecified, exception.Message);
+        }
+
+        [Test]
+        public void ReadSoilProfiles_IncorrectFormatFile_ThrowsSqLiteException()
+        {
+            // Setup
+            var dbName = "text";
+            var testFile = Path.Combine(testDataPath, dbName + ".txt");
+            var pipingSoilProfilesReader = new PipingSoilProfileReader(testFile);
+
+            // Call
+            TestDelegate test = () => pipingSoilProfilesReader.Read();
+
+            // Assert
+            var exception = Assert.Throws<PipingSoilProfileReadException>(test);
+            Assert.AreEqual(String.Format(Resources.Error_SoilProfileReadFromDatabase, dbName), exception.Message);
+        }
+
+        [Test]
+        public void ReadSoilProfiles_CompleteDatabase_Returns2ProfilesWithLayersAndGeometries()
+        {
+            // Setup
+            var testFile = "complete.soil";
+            var pipingSoilProfilesReader = new PipingSoilProfileReader(Path.Combine(testDataPath, testFile));
+
+            var firstProfileFirstLayerOuterLoop = new HashSet<Point3D>
+            {
+                new Point3D{X=0,Y=0,Z=-10},
+                new Point3D{X=0,Y=0,Z=-3.5},
+                new Point3D{X=70.208,Y=0,Z=-3.5},
+                new Point3D{X=73.91,Y=0,Z=-3.5},
+                new Point3D{X=80.78,Y=0,Z=-3.5},
+                new Point3D{X=80.78,Y=0,Z=-10},
+            };
+
+            var secondProfileSecondLayerOuterLoop = new HashSet<Point3D>
+            {
+                new Point3D{X=87.516,Y=0,Z=-1.5},
+                new Point3D{X=87.567000000000007,Y=0,Z=-0.70000000000000007},
+                new Point3D{X=101.4,Y=0,Z=-0.70000000000000007},
+                new Point3D{X=101.4,Y=0,Z=-1.5},
+            };
+
+            // Call
+            IEnumerable<PipingSoilProfile> result = pipingSoilProfilesReader.Read().ToArray();
+
+            // Assert
+            Assert.AreEqual(2, result.Count());
+            var firstProfile = result.SingleOrDefault(psp => psp.Name == "10Y_005_STBI");
+            Assert.NotNull(firstProfile);
+            Assert.AreEqual(13, firstProfile.Count());
+            CollectionAssert.AreEqual(firstProfileFirstLayerOuterLoop, firstProfile.Layers.ToArray()[0].OuterLoop);
+            Assert.IsNull(firstProfile.Layers.ToArray()[0].InnerLoop);
+
+            var secondProfile = result.SingleOrDefault(psp => psp.Name == "10Y_041_STBI");
+            Assert.NotNull(secondProfile);
+            Assert.AreEqual(14, secondProfile.Count());
+            CollectionAssert.AreEqual(secondProfileSecondLayerOuterLoop, secondProfile.Layers.ToArray()[1].OuterLoop);
+            Assert.IsNull(secondProfile.Layers.ToArray()[1].InnerLoop);
+        }
+    }
+}
\ No newline at end of file
Fisheye: Tag 356ac6ef31864aa207c8af9470df3349f8e4d1f1 refers to a dead (removed) revision in file `test/Plugins/Wti/Wti.IO.Test/PipingSoilProfilesReaderTest.cs'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: test/Plugins/Wti/Wti.IO.Test/Wti.IO.Test.csproj
===================================================================
diff -u -rf2284364cde43ab7969dd8f0fb038f846138ec41 -r356ac6ef31864aa207c8af9470df3349f8e4d1f1
--- test/Plugins/Wti/Wti.IO.Test/Wti.IO.Test.csproj	(.../Wti.IO.Test.csproj)	(revision f2284364cde43ab7969dd8f0fb038f846138ec41)
+++ test/Plugins/Wti/Wti.IO.Test/Wti.IO.Test.csproj	(.../Wti.IO.Test.csproj)	(revision 356ac6ef31864aa207c8af9470df3349f8e4d1f1)
@@ -41,7 +41,8 @@
   </ItemGroup>
   <ItemGroup>
     <Compile Include="Exceptions\CriticalFileReadExceptionTest.cs" />
-    <Compile Include="PipingSoilProfilesReaderTest.cs" />
+    <Compile Include="Exceptions\PipingSoilProfileReadExceptionTest.cs" />
+    <Compile Include="PipingSoilProfileReaderTest.cs" />
     <Compile Include="PipingSurfaceLinesCsvReaderTest.cs" />
     <Compile Include="Properties\AssemblyInfo.cs" />
   </ItemGroup>