using System;
using System.Linq;

namespace GOT.DBinterface
{
	public class DataBaseEngine
	{

		public void GetAllLakes()
		{
			GOT.DBinterface.DataBaseModelUnitOfWork model = new DataBaseModelUnitOfWork();

			var lakes = from p in model.Lakes select p;

			foreach (Lake lake in lakes)
				Console.WriteLine(lake.Name);
		}
	}
}

using System;

using Mindscape.LightSpeed;
using Mindscape.LightSpeed.Validation;
using Mindscape.LightSpeed.Linq;

namespace GOT.DBinterface
{
  [Serializable]
  [System.CodeDom.Compiler.GeneratedCode("LightSpeedModelGenerator", "1.0.0.0")]
  [System.ComponentModel.DataObject]
  public partial class Lake : Entity<int>
  {
    #region Fields
  
    private int _id;
    [ValidateLength(0, 50)]
    private string _name;
    [ValidateLength(0, 50)]
    private string _country;

    #endregion
    
    #region Field attribute and view names
    
    /// <summary>Identifies the Id entity attribute.</summary>
    public const string IdField = "Id";
    /// <summary>Identifies the Name entity attribute.</summary>
    public const string NameField = "Name";
    /// <summary>Identifies the Country entity attribute.</summary>
    public const string CountryField = "Country";

    #endregion
    
    #region Properties

    public int Id
    {
      get { return Get(ref _id, "Id"); }
      set { Set(ref _id, value, "Id"); }
    }

    public string Name
    {
      get { return Get(ref _name, "Name"); }
      set { Set(ref _name, value, "Name"); }
    }

    public string Country
    {
      get { return Get(ref _country, "Country"); }
      set { Set(ref _country, value, "Country"); }
    }

    #endregion
  }

  /// <summary>
  /// Provides a strong-typed unit of work for working with the DataBaseModel model.
  /// </summary>
  [System.CodeDom.Compiler.GeneratedCode("LightSpeedModelGenerator", "1.0.0.0")]
  public partial class DataBaseModelUnitOfWork : Mindscape.LightSpeed.UnitOfWork
  {

    public System.Linq.IQueryable<Lake> Lakes
    {
      get { return this.Query<Lake>(); }
    }
    
  }

}

_unitOfWork = (new LightSpeedContext()
		{
			ConnectionString = _connectionString,
			DataProvider = DataProvider.SQLite3,
			IdentityMethod = IdentityMethod.IdentityColumn
		}).CreateUnitOfWork();

public IEnumerable<Lake> lakes
	{
		get
		{
			return _unitOfWork.Query<Lake>();	
		}
	}

public IEnumerable<Lake> GetLakes(Func<Lake, bool> Condition)
{
	return lakes.Where(Condition);
}

public void AddLake(Lake lake)
{
	_unitOfWork.Add(lake);
	_unitOfWork.SaveChanges();
}

public void DeleteLake(Lake lake)
{
	_unitOfWork.Remove(lake);
	_unitOfWork.SaveChanges();
}