NMEMORY Archives - icodebroker

[C#/COMMON/NMEMORY/.NET6] Transaction 클래스 : Create 메소드를 사용해 트랜잭션 설정하기

■ Transaction 클래스의 Create 메소드를 사용해 트랜잭션을 설정하는 방법을 보여준다. ▶ Member.cs


namespace TestProject;

/// <summary>
/// 회원
/// </summary>
public class Member
{
    //////////////////////////////////////////////////////////////////////////////////////////////////// Property
    ////////////////////////////////////////////////////////////////////////////////////////// Public

    #region ID - ID

    /// <summary>
    /// ID
    /// </summary>
    public int ID { get; set; }

    #endregion
    #region 성명 - Name

    /// <summary>
    /// 성명
    /// </summary>
    public string Name { get; set; }

    #endregion
    #region 그룹 ID - GroupID

    /// <summary>
    /// 그룹 ID
    /// </summary>
    public int? GroupID { get; set; }

    #endregion
}

namespace TestProject;

/// <summary>

/// 회원

/// </summary>

public class Member

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

////////////////////////////////////////////////////////////////////////////////////////// Public

#region ID - ID

/// <summary>

/// ID

/// </summary>

public int ID { get; set; }

#endregion

#region 성명 - Name

/// <summary>

/// 성명

/// </summary>

public string Name { get; set; }

#endregion

#region 그룹 ID - GroupID

/// <summary>

/// 그룹 ID

/// </summary>

public int? GroupID { get; set; }

#endregion

}

▶ Program.cs


using System.Transactions;

using NMemory;
using NMemory.Tables;

namespace TestProject;

/// <summary>
/// 프로그램
/// </summary>
class Program
{
    //////////////////////////////////////////////////////////////////////////////////////////////////// Method
    ////////////////////////////////////////////////////////////////////////////////////////// Static
    //////////////////////////////////////////////////////////////////////////////// Private

    #region 프로그램 시작하기 - Main()

    /// <summary>
    /// 프로그램 시작하기
    /// </summary>
    private static void Main()
    {
        Database database = new Database();

        Table<Member, int> memberTable = database.Tables.Create<Member, int>(member => member.ID, null);

        CommittableTransaction committableTransaction = new CommittableTransaction();

        NMemory.Transactions.Transaction transaction = NMemory.Transactions.Transaction.Create(committableTransaction);

        try
        {
            memberTable.Insert(new Member() { ID = 1, Name = "김철수" }, transaction);
            memberTable.Insert(new Member() { ID = 2, Name = "홍길동" }, transaction);
            memberTable.Insert(new Member() { ID = 3, Name = "홍삼수" }, transaction);
            memberTable.Insert(new Member() { ID = 4, Name = "김영희" }, transaction);
            memberTable.Insert(new Member() { ID = 5, Name = "이주희" }, transaction);

            //throw new Exception();

            committableTransaction.Commit();
        }
        catch
        {
            committableTransaction.Rollback();
        }

        foreach(Member member in memberTable)
        {
            Console.WriteLine($"{member.ID}, {member.Name}");
        }
    }

    #endregion
}

using System.Transactions;

using NMemory;

using NMemory.Tables;

namespace TestProject;

/// <summary>

/// 프로그램

/// </summary>

class Program

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Static

//////////////////////////////////////////////////////////////////////////////// Private

#region 프로그램 시작하기 - Main()

/// <summary>

/// 프로그램 시작하기

/// </summary>

private static void Main()

{

Database database = new Database();

Table<Member, int> memberTable = database.Tables.Create<Member, int>(member => member.ID, null);

CommittableTransaction committableTransaction = new CommittableTransaction();

NMemory.Transactions.Transaction transaction = NMemory.Transactions.Transaction.Create(committableTransaction);

try

{

memberTable.Insert(new Member() { ID = 1, Name = "김철수" }, transaction);

memberTable.Insert(new Member() { ID = 2, Name = "홍길동" }, transaction);

memberTable.Insert(new Member() { ID = 3, Name = "홍삼수" }, transaction);

memberTable.Insert(new Member() { ID = 4, Name = "김영희" }, transaction);

memberTable.Insert(new Member() { ID = 5, Name = "이주희" }, transaction);

//throw new Exception();

committableTransaction.Commit();

}

catch

{

committableTransaction.Rollback();

}

foreach(Member member in memberTable)

{

Console.WriteLine($"{member.ID}, {member.Name}");

}

#endregion

}

TestProject.zip

[C#/COMMON/NMEMORY/.NET6] TransactionScope 클래스 : 트랜잭션 설정하기

■ TransactionScope 클래스를 사용해 트랜잭션을 설정하는 방법을 보여준다. ▶ Member.cs


namespace TestProject;

/// <summary>
/// 회원
/// </summary>
public class Member
{
    //////////////////////////////////////////////////////////////////////////////////////////////////// Property
    ////////////////////////////////////////////////////////////////////////////////////////// Public

    #region ID - ID

    /// <summary>
    /// ID
    /// </summary>
    public int ID { get; set; }

    #endregion
    #region 성명 - Name

    /// <summary>
    /// 성명
    /// </summary>
    public string Name { get; set; }

    #endregion
    #region 그룹 ID - GroupID

    /// <summary>
    /// 그룹 ID
    /// </summary>
    public int? GroupID { get; set; }

    #endregion
}

namespace TestProject;

/// <summary>

/// 회원

/// </summary>

public class Member

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

////////////////////////////////////////////////////////////////////////////////////////// Public

#region ID - ID

/// <summary>

/// ID

/// </summary>

public int ID { get; set; }

#endregion

#region 성명 - Name

/// <summary>

/// 성명

/// </summary>

public string Name { get; set; }

#endregion

#region 그룹 ID - GroupID

/// <summary>

/// 그룹 ID

/// </summary>

public int? GroupID { get; set; }

#endregion

}

▶ Program.cs


using System;
using System.Transactions;

using NMemory;
using NMemory.Tables;

namespace TestProject;

/// <summary>
/// 프로그램
/// </summary>
class Program
{
    //////////////////////////////////////////////////////////////////////////////////////////////////// Method
    ////////////////////////////////////////////////////////////////////////////////////////// Static
    //////////////////////////////////////////////////////////////////////////////// Private

    #region 프로그램 시작하기 - Main()

    /// <summary>
    /// 프로그램 시작하기
    /// </summary>
    private static void Main()
    {
        Database database = new Database();

        Table<Member, int> memberTable = database.Tables.Create<Member, int>(member => member.ID, null);

        try
        {
            using(TransactionScope tran = new TransactionScope())
            {
                memberTable.Insert(new Member() { ID = 1, Name = "김철수" });
                memberTable.Insert(new Member() { ID = 2, Name = "홍길동" });
                memberTable.Insert(new Member() { ID = 3, Name = "홍삼수" });
                memberTable.Insert(new Member() { ID = 4, Name = "김영희" });
                memberTable.Insert(new Member() { ID = 5, Name = "이주희" });

                //throw new Exception();

                tran.Complete();
            }
        }
        catch
        {
        }

        foreach(Member member in memberTable)
        {
            Console.WriteLine($"{member.ID}, {member.Name}");
        }
    }

    #endregion
}

using System;

using System.Transactions;

using NMemory;

using NMemory.Tables;

namespace TestProject;

/// <summary>

/// 프로그램

/// </summary>

class Program

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Static

//////////////////////////////////////////////////////////////////////////////// Private

#region 프로그램 시작하기 - Main()

/// <summary>

/// 프로그램 시작하기

/// </summary>

private static void Main()

{

Database database = new Database();

Table<Member, int> memberTable = database.Tables.Create<Member, int>(member => member.ID, null);

try

{

using(TransactionScope tran = new TransactionScope())

{

memberTable.Insert(new Member() { ID = 1, Name = "김철수" });

memberTable.Insert(new Member() { ID = 2, Name = "홍길동" });

memberTable.Insert(new Member() { ID = 3, Name = "홍삼수" });

memberTable.Insert(new Member() { ID = 4, Name = "김영희" });

memberTable.Insert(new Member() { ID = 5, Name = "이주희" });

//throw new Exception();

tran.Complete();

}

catch

{

}

foreach(Member member in memberTable)

{

Console.WriteLine($"{member.ID}, {member.Name}");

}

#endregion

}

TestProject.zip

[C#/COMMON/NMEMORY/.NET6] SharedStoredProcedure 클래스 : Execute 메소드를 사용해 저장 프로시저 실행하기

■ SharedStoredProcedure<TDatabase, TResult> 클래스의 Execute 메소드를 사용해 저장 프로시저를 실행하는 방법을 보여준다. ▶ Group.cs


namespace TestProject;

/// <summary>
/// 그룹
/// </summary>
public class Group
{
    //////////////////////////////////////////////////////////////////////////////////////////////////// Property
    ////////////////////////////////////////////////////////////////////////////////////////// Public

    #region ID - ID

    /// <summary>
    /// ID
    /// </summary>
    public int ID { get; set; }

    #endregion
    #region 명칭 - Name

    /// <summary>
    /// 명칭
    /// </summary>
    public string Name { get; set; }

    #endregion
}

namespace TestProject;

/// <summary>

/// 그룹

/// </summary>

public class Group

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

////////////////////////////////////////////////////////////////////////////////////////// Public

#region ID - ID

/// <summary>

/// ID

/// </summary>

public int ID { get; set; }

#endregion

#region 명칭 - Name

/// <summary>

/// 명칭

/// </summary>

public string Name { get; set; }

#endregion

}

▶ Member.cs


namespace TestProject;

/// <summary>
/// 회원
/// </summary>
public class Member
{
    //////////////////////////////////////////////////////////////////////////////////////////////////// Property
    ////////////////////////////////////////////////////////////////////////////////////////// Public

    #region ID - ID

    /// <summary>
    /// ID
    /// </summary>
    public int ID { get; set; }

    #endregion
    #region 성명 - Name

    /// <summary>
    /// 성명
    /// </summary>
    public string Name { get; set; }

    #endregion
    #region 그룹 ID - GroupID

    /// <summary>
    /// 그룹 ID
    /// </summary>
    public int? GroupID { get; set; }

    #endregion
}

namespace TestProject;

/// <summary>

/// 회원

/// </summary>

public class Member

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

////////////////////////////////////////////////////////////////////////////////////////// Public

#region ID - ID

/// <summary>

/// ID

/// </summary>

public int ID { get; set; }

#endregion

#region 성명 - Name

/// <summary>

/// 성명

/// </summary>

public string Name { get; set; }

#endregion

#region 그룹 ID - GroupID

/// <summary>

/// 그룹 ID

/// </summary>

public int? GroupID { get; set; }

#endregion

}

▶ TestDatabase.cs


using NMemory;
using NMemory.Indexes;
using NMemory.Tables;

namespace TestProject;

/// <summary>
/// 테스트 데이터베이스
/// </summary>
public class TestDatabase : Database
{
    //////////////////////////////////////////////////////////////////////////////////////////////////// Property
    ////////////////////////////////////////////////////////////////////////////////////////// Public

    #region 그룹 테이블 - GroupTable

    /// <summary>
    /// 그룹 테이블
    /// </summary>
    public ITable<Group> GroupTable { get; private set; }

    #endregion
    #region 회원 테이블 - MemberTable

    /// <summary>
    /// 회원 테이블
    /// </summary>
    public ITable<Member> MemberTable { get; private set; }

    #endregion

    //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
    ////////////////////////////////////////////////////////////////////////////////////////// Public

    #region 생성자 - TestDatabase()

    /// <summary>
    /// 생성자
    /// </summary>
    public TestDatabase()
    {
        Table<Group , int> groupTable  = Tables.Create<Group , int>(g => g.ID, new IdentitySpecification<Group >(g => g.ID, 1, 1));
        Table<Member, int> memberTable = Tables.Create<Member, int>(m => m.ID, new IdentitySpecification<Member>(m => m.ID, 1, 1));

        GroupTable  = groupTable;
        MemberTable = memberTable;

        RelationOptions options = new RelationOptions(cascadedDeletion : true);

        IIndex<Member, int?> memberGroupIDIndex = memberTable.CreateIndex(new RedBlackTreeIndexFactory(), m => m.GroupID);

        Tables.CreateRelation
        (
            groupTable.PrimaryKeyIndex,
            memberGroupIDIndex,
            x =>  x ?? -1,
            x => x,
            options
        );
    }

    #endregion
}

using NMemory;

using NMemory.Indexes;

using NMemory.Tables;

namespace TestProject;

/// <summary>

/// 테스트 데이터베이스

/// </summary>

public class TestDatabase : Database

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 그룹 테이블 - GroupTable

/// <summary>

/// 그룹 테이블

/// </summary>

public ITable<Group> GroupTable { get; private set; }

#endregion

#region 회원 테이블 - MemberTable

/// <summary>

/// 회원 테이블

/// </summary>

public ITable<Member> MemberTable { get; private set; }

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - TestDatabase()

/// <summary>

/// 생성자

/// </summary>

public TestDatabase()

{

Table<Group , int> groupTable = Tables.Create<Group , int>(g => g.ID, new IdentitySpecification<Group >(g => g.ID, 1, 1));

Table<Member, int> memberTable = Tables.Create<Member, int>(m => m.ID, new IdentitySpecification<Member>(m => m.ID, 1, 1));

GroupTable = groupTable;

MemberTable = memberTable;

RelationOptions options = new RelationOptions(cascadedDeletion : true);

IIndex<Member, int?> memberGroupIDIndex = memberTable.CreateIndex(new RedBlackTreeIndexFactory(), m => m.GroupID);

Tables.CreateRelation

(

groupTable.PrimaryKeyIndex,

memberGroupIDIndex,

x => x ?? -1,

x => x,

options

);

}

#endregion

}

▶

[C#/COMMON/NMEMORY/.NET6] IStoredProcedure 인터페이스 : Execute 메소드를 사용해 저장 프로시저 실행하기

■ IStoredProcedure<T> 인터페이스의 Execute 메소드를 사용해 저장 프로시저를 실행하는 방법을 보여준다. ▶ Member.cs


namespace TestProject;

/// <summary>
/// 회원
/// </summary>
public class Member
{
    //////////////////////////////////////////////////////////////////////////////////////////////////// Property
    ////////////////////////////////////////////////////////////////////////////////////////// Public

    #region ID - ID

    /// <summary>
    /// ID
    /// </summary>
    public int ID { get; set; }

    #endregion
    #region 성명 - Name

    /// <summary>
    /// 성명
    /// </summary>
    public string Name { get; set; }

    #endregion
    #region 그룹 ID - GroupID

    /// <summary>
    /// 그룹 ID
    /// </summary>
    public int? GroupID { get; set; }

    #endregion
}

namespace TestProject;

/// <summary>

/// 회원

/// </summary>

public class Member

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

////////////////////////////////////////////////////////////////////////////////////////// Public

#region ID - ID

/// <summary>

/// ID

/// </summary>

public int ID { get; set; }

#endregion

#region 성명 - Name

/// <summary>

/// 성명

/// </summary>

public string Name { get; set; }

#endregion

#region 그룹 ID - GroupID

/// <summary>

/// 그룹 ID

/// </summary>

public int? GroupID { get; set; }

#endregion

}

▶ Program.cs


using System.Collections.Concurrent;

using NMemory;
using NMemory.StoredProcedures;
using NMemory.Tables;

namespace TestProject;

/// <summary>
/// 프로그램
/// </summary>
class Program
{
    //////////////////////////////////////////////////////////////////////////////////////////////////// Method
    ////////////////////////////////////////////////////////////////////////////////////////// Static
    //////////////////////////////////////////////////////////////////////////////// Private

    #region 프로그램 시작하기 - Main()

    /// <summary>
    /// 프로그램 시작하기
    /// </summary>
    private static void Main()
    {
        Database database = new Database();

        Table<Member, int> memberTable = database.Tables.Create<Member, int>(member => member.ID, null);

        memberTable.Insert(new Member() { ID = 1, Name = "김철수" });
        memberTable.Insert(new Member() { ID = 2, Name = "홍길동" });
        memberTable.Insert(new Member() { ID = 3, Name = "홍삼수" });
        memberTable.Insert(new Member() { ID = 4, Name = "김영희" });
        memberTable.Insert(new Member() { ID = 5, Name = "이주희" });

        IQueryable<Member> queryable =  memberTable.Where(member => new Parameter<int>("startID") <= member.ID && member.ID <= new Parameter<int>("endID"));

        IStoredProcedure<Member> storedProcedure = database.StoredProcedures.Create(queryable);

        ConcurrentDictionary<string, object> parameterDictionary = new ConcurrentDictionary<string, object>();

        parameterDictionary.GetOrAdd("startID", 3);
        parameterDictionary.GetOrAdd("endID"  , 4);

        List<Member> memberList = storedProcedure.Execute(parameterDictionary).ToList();

        foreach(Member member in memberList)
        {
            Console.WriteLine($"{member.ID}, {member.Name}");
        }
    }

    #endregion
}

using System.Collections.Concurrent;

using NMemory;

using NMemory.StoredProcedures;

using NMemory.Tables;

namespace TestProject;

/// <summary>

/// 프로그램

/// </summary>

class Program

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Static

//////////////////////////////////////////////////////////////////////////////// Private

#region 프로그램 시작하기 - Main()

/// <summary>

/// 프로그램 시작하기

/// </summary>

private static void Main()

{

Database database = new Database();

Table<Member, int> memberTable = database.Tables.Create<Member, int>(member => member.ID, null);

memberTable.Insert(new Member() { ID = 1, Name = "김철수" });

memberTable.Insert(new Member() { ID = 2, Name = "홍길동" });

memberTable.Insert(new Member() { ID = 3, Name = "홍삼수" });

memberTable.Insert(new Member() { ID = 4, Name = "김영희" });

memberTable.Insert(new Member() { ID = 5, Name = "이주희" });

IQueryable<Member> queryable = memberTable.Where(member => new Parameter<int>("startID") <= member.ID && member.ID <= new Parameter<int>("endID"));

IStoredProcedure<Member> storedProcedure = database.StoredProcedures.Create(queryable);

ConcurrentDictionary<string, object> parameterDictionary = new ConcurrentDictionary<string, object>();

parameterDictionary.GetOrAdd("startID", 3);

parameterDictionary.GetOrAdd("endID" , 4);

List<Member> memberList = storedProcedure.Execute(parameterDictionary).ToList();

foreach(Member member in memberList)

{

Console.WriteLine($"{member.ID}, {member.Name}");

}

#endregion

}

TestProject.zip

[C#/COMMON/NMEMORY/.NET6] NotNullableConstraint 클래스 : NOT NULL 제약 조건 사용하기

■ NotNullableConstraint 클래스를 사용해 NOT NULL 제약 조건을 설정하는 방법을 보여준다. ▶ Member.cs


namespace TestProject;

/// <summary>
/// 회원
/// </summary>
public class Member
{
    //////////////////////////////////////////////////////////////////////////////////////////////////// Property
    ////////////////////////////////////////////////////////////////////////////////////////// Public

    #region ID - ID

    /// <summary>
    /// ID
    /// </summary>
    public int ID { get; set; }

    #endregion
    #region 성명 - Name

    /// <summary>
    /// 성명
    /// </summary>
    public string Name { get; set; }

    #endregion
    #region 그룹 ID - GroupID

    /// <summary>
    /// 그룹 ID
    /// </summary>
    public int? GroupID { get; set; }

    #endregion
}

namespace TestProject;

/// <summary>

/// 회원

/// </summary>

public class Member

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

////////////////////////////////////////////////////////////////////////////////////////// Public

#region ID - ID

/// <summary>

/// ID

/// </summary>

public int ID { get; set; }

#endregion

#region 성명 - Name

/// <summary>

/// 성명

/// </summary>

public string Name { get; set; }

#endregion

#region 그룹 ID - GroupID

/// <summary>

/// 그룹 ID

/// </summary>

public int? GroupID { get; set; }

#endregion

}

▶ Program.cs


using NMemory;
using NMemory.Constraints;
using NMemory.Tables;

namespace TestProject;

/// <summary>
/// 프로그램
/// </summary>
class Program
{
    //////////////////////////////////////////////////////////////////////////////////////////////////// Method
    ////////////////////////////////////////////////////////////////////////////////////////// Static
    //////////////////////////////////////////////////////////////////////////////// Private

    #region 프로그램 시작하기 - Main()

    /// <summary>
    /// 프로그램 시작하기
    /// </summary>
    private static void Main()
    {
        Database database = new Database();

        Table<Member, int> memberTable = database.Tables.Create<Member, int>(member => member.ID, null);

        memberTable.Contraints.Add(new NotNullableConstraint<Member, string>(member => member.Name));

        memberTable.Insert(new Member() { ID = 1, Name = "김철수" });
        memberTable.Insert(new Member() { ID = 2, Name = "홍길동" });
        memberTable.Insert(new Member() { ID = 3, Name = "홍삼수" });
        memberTable.Insert(new Member() { ID = 4, Name = "김영희" });
        memberTable.Insert(new Member() { ID = 5, Name = "이주희" });

        foreach(Member member in memberTable)
        {
            Console.WriteLine($"{member.ID}, {member.Name}");
        }

        memberTable.Insert(new Member() { ID = 6 }); // ConstraintException 예외가 발생한다.
    }

    #endregion
}

using NMemory;

using NMemory.Constraints;

using NMemory.Tables;

namespace TestProject;

/// <summary>

/// 프로그램

/// </summary>

class Program

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Static

//////////////////////////////////////////////////////////////////////////////// Private

#region 프로그램 시작하기 - Main()

/// <summary>

/// 프로그램 시작하기

/// </summary>

private static void Main()

{

Database database = new Database();

Table<Member, int> memberTable = database.Tables.Create<Member, int>(member => member.ID, null);

memberTable.Contraints.Add(new NotNullableConstraint<Member, string>(member => member.Name));

memberTable.Insert(new Member() { ID = 1, Name = "김철수" });

memberTable.Insert(new Member() { ID = 2, Name = "홍길동" });

memberTable.Insert(new Member() { ID = 3, Name = "홍삼수" });

memberTable.Insert(new Member() { ID = 4, Name = "김영희" });

memberTable.Insert(new Member() { ID = 5, Name = "이주희" });

foreach(Member member in memberTable)

{

Console.WriteLine($"{member.ID}, {member.Name}");

}

memberTable.Insert(new Member() { ID = 6 }); // ConstraintException 예외가 발생한다.

}

#endregion

}

TestProject.zip

[C#/COMMON/NMEMORY/.NET6] NCharConstraint 클래스 : 최대 문자 수 제약 조건 사용하기

■ NCharConstraint 클래스를 사용해 최대 문자 수 제약 조건을 설정하는 방법을 보여준다. ▶ Member.cs


namespace TestProject;

/// <summary>
/// 회원
/// </summary>
public class Member
{
    //////////////////////////////////////////////////////////////////////////////////////////////////// Property
    ////////////////////////////////////////////////////////////////////////////////////////// Public

    #region ID - ID

    /// <summary>
    /// ID
    /// </summary>
    public int ID { get; set; }

    #endregion
    #region 성명 - Name

    /// <summary>
    /// 성명
    /// </summary>
    public string Name { get; set; }

    #endregion
    #region 그룹 ID - GroupID

    /// <summary>
    /// 그룹 ID
    /// </summary>
    public int? GroupID { get; set; }

    #endregion
}

namespace TestProject;

/// <summary>

/// 회원

/// </summary>

public class Member

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

////////////////////////////////////////////////////////////////////////////////////////// Public

#region ID - ID

/// <summary>

/// ID

/// </summary>

public int ID { get; set; }

#endregion

#region 성명 - Name

/// <summary>

/// 성명

/// </summary>

public string Name { get; set; }

#endregion

#region 그룹 ID - GroupID

/// <summary>

/// 그룹 ID

/// </summary>

public int? GroupID { get; set; }

#endregion

}

▶ Program.cs


using NMemory;
using NMemory.Constraints;
using NMemory.Tables;

namespace TestProject;

/// <summary>
/// 프로그램
/// </summary>
class Program
{
    //////////////////////////////////////////////////////////////////////////////////////////////////// Method
    ////////////////////////////////////////////////////////////////////////////////////////// Static
    //////////////////////////////////////////////////////////////////////////////// Private

    #region 프로그램 시작하기 - Main()

    /// <summary>
    /// 프로그램 시작하기
    /// </summary>
    private static void Main()
    {
        Database database = new Database();

        Table<Member, int> memberTable = database.Tables.Create<Member, int>(member => member.ID, null);

        memberTable.Contraints.Add(new NCharConstraint<Member>(member => member.Name, 3));

        memberTable.Insert(new Member() { ID = 1, Name = "김철수" });
        memberTable.Insert(new Member() { ID = 2, Name = "홍길동" });
        memberTable.Insert(new Member() { ID = 3, Name = "홍삼수" });
        memberTable.Insert(new Member() { ID = 4, Name = "김영희" });
        memberTable.Insert(new Member() { ID = 5, Name = "이주희" });

        foreach(Member member in memberTable)
        {
            Console.WriteLine($"{member.ID}, {member.Name}");
        }

        memberTable.Insert(new Member() { ID = 6, Name = "요시무라" }); // ConstraintException 예외가 발생한다.
    }

    #endregion
}

using NMemory;

using NMemory.Constraints;

using NMemory.Tables;

namespace TestProject;

/// <summary>

/// 프로그램

/// </summary>

class Program

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Static

//////////////////////////////////////////////////////////////////////////////// Private

#region 프로그램 시작하기 - Main()

/// <summary>

/// 프로그램 시작하기

/// </summary>

private static void Main()

{

Database database = new Database();

Table<Member, int> memberTable = database.Tables.Create<Member, int>(member => member.ID, null);

memberTable.Contraints.Add(new NCharConstraint<Member>(member => member.Name, 3));

memberTable.Insert(new Member() { ID = 1, Name = "김철수" });

memberTable.Insert(new Member() { ID = 2, Name = "홍길동" });

memberTable.Insert(new Member() { ID = 3, Name = "홍삼수" });

memberTable.Insert(new Member() { ID = 4, Name = "김영희" });

memberTable.Insert(new Member() { ID = 5, Name = "이주희" });

foreach(Member member in memberTable)

{

Console.WriteLine($"{member.ID}, {member.Name}");

}

memberTable.Insert(new Member() { ID = 6, Name = "요시무라" }); // ConstraintException 예외가 발생한다.

}

#endregion

}

TestProject.zip

[C#/COMMON/NMEMORY/.NET6] RelationOptions 클래스 : 계단식 삭제 사용하기

■ RelationOptions 클래스를 사용해 계단식 삭제를 처리하는 방법을 보여준다. ▶ Group.cs


namespace TestProject;

/// <summary>
/// 그룹
/// </summary>
public class Group
{
    //////////////////////////////////////////////////////////////////////////////////////////////////// Property
    ////////////////////////////////////////////////////////////////////////////////////////// Public

    #region ID - ID

    /// <summary>
    /// ID
    /// </summary>
    public int ID { get; set; }

    #endregion
    #region 명칭 - Name

    /// <summary>
    /// 명칭
    /// </summary>
    public string Name { get; set; }

    #endregion
}

namespace TestProject;

/// <summary>

/// 그룹

/// </summary>

public class Group

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

////////////////////////////////////////////////////////////////////////////////////////// Public

#region ID - ID

/// <summary>

/// ID

/// </summary>

public int ID { get; set; }

#endregion

#region 명칭 - Name

/// <summary>

/// 명칭

/// </summary>

public string Name { get; set; }

#endregion

}

▶ Member.cs


namespace TestProject;

/// <summary>
/// 회원
/// </summary>
public class Member
{
    //////////////////////////////////////////////////////////////////////////////////////////////////// Property
    ////////////////////////////////////////////////////////////////////////////////////////// Public

    #region ID - ID

    /// <summary>
    /// ID
    /// </summary>
    public int ID { get; set; }

    #endregion
    #region 성명 - Name

    /// <summary>
    /// 성명
    /// </summary>
    public string Name { get; set; }

    #endregion
    #region 그룹 ID - GroupID

    /// <summary>
    /// 그룹 ID
    /// </summary>
    public int? GroupID { get; set; }

    #endregion
}

namespace TestProject;

/// <summary>

/// 회원

/// </summary>

public class Member

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

////////////////////////////////////////////////////////////////////////////////////////// Public

#region ID - ID

/// <summary>

/// ID

/// </summary>

public int ID { get; set; }

#endregion

#region 성명 - Name

/// <summary>

/// 성명

/// </summary>

public string Name { get; set; }

#endregion

#region 그룹 ID - GroupID

/// <summary>

/// 그룹 ID

/// </summary>

public int? GroupID { get; set; }

#endregion

}

▶ Program.cs


using NMemory;
using NMemory.Indexes;
using NMemory.Tables;

namespace TestProject;

/// <summary>
/// 프로그램
/// </summary>
class Program
{
    //////////////////////////////////////////////////////////////////////////////////////////////////// Method
    ////////////////////////////////////////////////////////////////////////////////////////// Static
    //////////////////////////////////////////////////////////////////////////////// Private

    #region 프로그램 시작하기 - Main()

    /// <summary>
    /// 프로그램 시작하기
    /// </summary>
    private static void Main()
    {
        Database database = new Database();

        Table<Group , int> groupTable  = database.Tables.Create<Group , int>(group  => group.ID , null);
        Table<Member, int> memberTable = database.Tables.Create<Member, int>(member => member.ID, null);

        IIndex<Member, int?> memberGroupIDIndex = memberTable.CreateIndex(new RedBlackTreeIndexFactory(), member => member.GroupID);

        RelationOptions options = new RelationOptions(cascadedDeletion : true);

        database.Tables.CreateRelation
        (
            groupTable.PrimaryKeyIndex,
            memberGroupIDIndex,
            x => x ?? -1,
            x => x,
            options
        );

        groupTable.Insert(new Group() { ID = 1, Name = "그룹 1"});
        groupTable.Insert(new Group() { ID = 2, Name = "그룹 2"});

        memberTable.Insert(new Member() { ID = 1, Name = "김철수", GroupID = 1 });
        memberTable.Insert(new Member() { ID = 2, Name = "홍길동", GroupID = 1 });
        memberTable.Insert(new Member() { ID = 3, Name = "홍삼수", GroupID = 1 });
        memberTable.Insert(new Member() { ID = 4, Name = "김영희", GroupID = 2 });
        memberTable.Insert(new Member() { ID = 5, Name = "이주희", GroupID = 2 });

        groupTable.Delete(new Group() { ID = 2 });

        foreach(Member member in memberTable)
        {
            Console.WriteLine($"{member.Name}, {member.GroupID}");
        }
    }

    #endregion
}

using NMemory;

using NMemory.Indexes;

using NMemory.Tables;

namespace TestProject;

/// <summary>

/// 프로그램

/// </summary>

class Program

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Static

//////////////////////////////////////////////////////////////////////////////// Private

#region 프로그램 시작하기 - Main()

/// <summary>

/// 프로그램 시작하기

/// </summary>

private static void Main()

{

Database database = new Database();

Table<Group , int> groupTable = database.Tables.Create<Group , int>(group => group.ID , null);

Table<Member, int> memberTable = database.Tables.Create<Member, int>(member => member.ID, null);

IIndex<Member, int?> memberGroupIDIndex = memberTable.CreateIndex(new RedBlackTreeIndexFactory(), member => member.GroupID);

RelationOptions options = new RelationOptions(cascadedDeletion : true);

database.Tables.CreateRelation

(

groupTable.PrimaryKeyIndex,

memberGroupIDIndex,

x => x ?? -1,

x => x,

options

);

groupTable.Insert(new Group() { ID = 1, Name = "그룹 1"});

groupTable.Insert(new Group() { ID = 2, Name = "그룹 2"});

memberTable.Insert(new Member() { ID = 1, Name = "김철수", GroupID = 1 });

memberTable.Insert(new Member() { ID = 2, Name = "홍길동", GroupID = 1 });

memberTable.Insert(new Member() { ID = 3, Name = "홍삼수", GroupID = 1 });

memberTable.Insert(new Member() { ID = 4, Name = "김영희", GroupID = 2 });

memberTable.Insert(new Member() { ID = 5, Name = "이주희", GroupID = 2 });

groupTable.Delete(new Group() { ID = 2 });

foreach(Member member in memberTable)

{

Console.WriteLine($"{member.Name}, {member.GroupID}");

}

#endregion

}

TestProject.zip

[C#/COMMON/NMEMORY/.NET6] Table 클래스 : Delete 메소드를 사용해 데이터 삭제하기

■ Table<TEntity, TPrimaryKey> 클래스의 Delete 메소드를 사용해 데이터를 삭제하는 방법을 보여준다. ▶ Group.cs


namespace TestProject;

/// <summary>
/// 그룹
/// </summary>
public class Group
{
    //////////////////////////////////////////////////////////////////////////////////////////////////// Property
    ////////////////////////////////////////////////////////////////////////////////////////// Public

    #region ID - ID

    /// <summary>
    /// ID
    /// </summary>
    public int ID { get; set; }

    #endregion
    #region 명칭 - Name

    /// <summary>
    /// 명칭
    /// </summary>
    public string Name { get; set; }

    #endregion
}

namespace TestProject;

/// <summary>

/// 그룹

/// </summary>

public class Group

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

////////////////////////////////////////////////////////////////////////////////////////// Public

#region ID - ID

/// <summary>

/// ID

/// </summary>

public int ID { get; set; }

#endregion

#region 명칭 - Name

/// <summary>

/// 명칭

/// </summary>

public string Name { get; set; }

#endregion

}

▶ Member.cs


namespace TestProject;

/// <summary>
/// 회원
/// </summary>
public class Member
{
    //////////////////////////////////////////////////////////////////////////////////////////////////// Property
    ////////////////////////////////////////////////////////////////////////////////////////// Public

    #region ID - ID

    /// <summary>
    /// ID
    /// </summary>
    public int ID { get; set; }

    #endregion
    #region 성명 - Name

    /// <summary>
    /// 성명
    /// </summary>
    public string Name { get; set; }

    #endregion
    #region 그룹 ID - GroupID

    /// <summary>
    /// 그룹 ID
    /// </summary>
    public int? GroupID { get; set; }

    #endregion
}

namespace TestProject;

/// <summary>

/// 회원

/// </summary>

public class Member

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

////////////////////////////////////////////////////////////////////////////////////////// Public

#region ID - ID

/// <summary>

/// ID

/// </summary>

public int ID { get; set; }

#endregion

#region 성명 - Name

/// <summary>

/// 성명

/// </summary>

public string Name { get; set; }

#endregion

#region 그룹 ID - GroupID

/// <summary>

/// 그룹 ID

/// </summary>

public int? GroupID { get; set; }

#endregion

}

▶ Program.cs


using NMemory;
using NMemory.Indexes;
using NMemory.Tables;

namespace TestProject;

/// <summary>
/// 프로그램
/// </summary>
class Program
{
    //////////////////////////////////////////////////////////////////////////////////////////////////// Method
    ////////////////////////////////////////////////////////////////////////////////////////// Static
    //////////////////////////////////////////////////////////////////////////////// Private

    #region 프로그램 시작하기 - Main()

    /// <summary>
    /// 프로그램 시작하기
    /// </summary>
    private static void Main()
    {
        Database database = new Database();

        Table<Group , int> groupTable  = database.Tables.Create<Group , int>(group  => group.ID , null);
        Table<Member, int> memberTable = database.Tables.Create<Member, int>(member => member.ID, null);

        IIndex<Member, int?> memberGroupIDIndex = memberTable.CreateIndex(new RedBlackTreeIndexFactory(), member => member.GroupID);

        database.Tables.CreateRelation
        (
            groupTable.PrimaryKeyIndex,
            memberGroupIDIndex,
            x => x ?? -1,
            x => x
        );

        groupTable.Insert(new Group() { ID = 1, Name = "그룹 1"});
        groupTable.Insert(new Group() { ID = 2, Name = "그룹 2"});

        memberTable.Insert(new Member() { ID = 1, Name = "김철수", GroupID = 1 });
        memberTable.Insert(new Member() { ID = 2, Name = "홍길동", GroupID = 1 });
        memberTable.Insert(new Member() { ID = 3, Name = "홍삼수", GroupID = 1 });
        memberTable.Insert(new Member() { ID = 4, Name = "김영희", GroupID = 2 });
        memberTable.Insert(new Member() { ID = 5, Name = "이주희", GroupID = 2 });

        memberTable.Delete(new Member() { ID = 3 });

        foreach(Member member in memberTable)
        {
            Console.WriteLine($"{member.Name}, {member.GroupID}");
        }
    }

    #endregion
}

using NMemory;

using NMemory.Indexes;

using NMemory.Tables;

namespace TestProject;

/// <summary>

/// 프로그램

/// </summary>

class Program

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Static

//////////////////////////////////////////////////////////////////////////////// Private

#region 프로그램 시작하기 - Main()

/// <summary>

/// 프로그램 시작하기

/// </summary>

private static void Main()

{

Database database = new Database();

Table<Group , int> groupTable = database.Tables.Create<Group , int>(group => group.ID , null);

Table<Member, int> memberTable = database.Tables.Create<Member, int>(member => member.ID, null);

IIndex<Member, int?> memberGroupIDIndex = memberTable.CreateIndex(new RedBlackTreeIndexFactory(), member => member.GroupID);

database.Tables.CreateRelation

(

groupTable.PrimaryKeyIndex,

memberGroupIDIndex,

x => x ?? -1,

x => x

);

groupTable.Insert(new Group() { ID = 1, Name = "그룹 1"});

groupTable.Insert(new Group() { ID = 2, Name = "그룹 2"});

memberTable.Insert(new Member() { ID = 1, Name = "김철수", GroupID = 1 });

memberTable.Insert(new Member() { ID = 2, Name = "홍길동", GroupID = 1 });

memberTable.Insert(new Member() { ID = 3, Name = "홍삼수", GroupID = 1 });

memberTable.Insert(new Member() { ID = 4, Name = "김영희", GroupID = 2 });

memberTable.Insert(new Member() { ID = 5, Name = "이주희", GroupID = 2 });

memberTable.Delete(new Member() { ID = 3 });

foreach(Member member in memberTable)

{

Console.WriteLine($"{member.Name}, {member.GroupID}");

}

#endregion

}

TestProject.zip

[C#/COMMON/NMEMORY/.NET6] Table 클래스 : Update 메소드를 사용해 데이터 수정하기

■ Table<TEntity, TPrimaryKey> 클래스의 Update 메소드를 사용해 데이터를 수정하는 방법을 보여준다. ▶ Group.cs


namespace TestProject;

/// <summary>
/// 그룹
/// </summary>
public class Group
{
    //////////////////////////////////////////////////////////////////////////////////////////////////// Property
    ////////////////////////////////////////////////////////////////////////////////////////// Public

    #region ID - ID

    /// <summary>
    /// ID
    /// </summary>
    public int ID { get; set; }

    #endregion
    #region 명칭 - Name

    /// <summary>
    /// 명칭
    /// </summary>
    public string Name { get; set; }

    #endregion
}

namespace TestProject;

/// <summary>

/// 그룹

/// </summary>

public class Group

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

////////////////////////////////////////////////////////////////////////////////////////// Public

#region ID - ID

/// <summary>

/// ID

/// </summary>

public int ID { get; set; }

#endregion

#region 명칭 - Name

/// <summary>

/// 명칭

/// </summary>

public string Name { get; set; }

#endregion

}

▶ Member.cs


namespace TestProject;

/// <summary>
/// 회원
/// </summary>
public class Member
{
    //////////////////////////////////////////////////////////////////////////////////////////////////// Property
    ////////////////////////////////////////////////////////////////////////////////////////// Public

    #region ID - ID

    /// <summary>
    /// ID
    /// </summary>
    public int ID { get; set; }

    #endregion
    #region 성명 - Name

    /// <summary>
    /// 성명
    /// </summary>
    public string Name { get; set; }

    #endregion
    #region 그룹 ID - GroupID

    /// <summary>
    /// 그룹 ID
    /// </summary>
    public int? GroupID { get; set; }

    #endregion
}

namespace TestProject;

/// <summary>

/// 회원

/// </summary>

public class Member

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

////////////////////////////////////////////////////////////////////////////////////////// Public

#region ID - ID

/// <summary>

/// ID

/// </summary>

public int ID { get; set; }

#endregion

#region 성명 - Name

/// <summary>

/// 성명

/// </summary>

public string Name { get; set; }

#endregion

#region 그룹 ID - GroupID

/// <summary>

/// 그룹 ID

/// </summary>

public int? GroupID { get; set; }

#endregion

}

▶ Program.cs


using NMemory;
using NMemory.Indexes;
using NMemory.Tables;

namespace TestProject;

/// <summary>
/// 프로그램
/// </summary>
class Program
{
    //////////////////////////////////////////////////////////////////////////////////////////////////// Method
    ////////////////////////////////////////////////////////////////////////////////////////// Static
    //////////////////////////////////////////////////////////////////////////////// Private

    #region 프로그램 시작하기 - Main()

    /// <summary>
    /// 프로그램 시작하기
    /// </summary>
    private static void Main()
    {
        Database database = new Database();

        Table<Group , int> groupTable  = database.Tables.Create<Group , int>(group  => group.ID , null);
        Table<Member, int> memberTable = database.Tables.Create<Member, int>(member => member.ID, null);

        IIndex<Member, int?> memberGroupIDIndex = memberTable.CreateIndex(new RedBlackTreeIndexFactory(), member => member.GroupID);

        database.Tables.CreateRelation
        (
            groupTable.PrimaryKeyIndex,
            memberGroupIDIndex,
            x => x ?? -1,
            x => x
        );

        groupTable.Insert(new Group() { ID = 1, Name = "그룹 1"});
        groupTable.Insert(new Group() { ID = 2, Name = "그룹 2"});

        memberTable.Insert(new Member() { ID = 1, Name = "김철수", GroupID = 1 });
        memberTable.Insert(new Member() { ID = 2, Name = "홍길동", GroupID = 1 });
        memberTable.Insert(new Member() { ID = 3, Name = "홍삼수", GroupID = 1 });
        memberTable.Insert(new Member() { ID = 4, Name = "김영희", GroupID = 2 });
        memberTable.Insert(new Member() { ID = 5, Name = "이주희", GroupID = 2 });

        memberTable.Update(new Member() { ID = 3, Name = "홍삼수 (수정)", GroupID = 1 });

        foreach(Member member in memberTable)
        {
            Console.WriteLine($"{member.Name}, {member.GroupID}");
        }
    }

    #endregion
}

using NMemory;

using NMemory.Indexes;

using NMemory.Tables;

namespace TestProject;

/// <summary>

/// 프로그램

/// </summary>

class Program

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Static

//////////////////////////////////////////////////////////////////////////////// Private

#region 프로그램 시작하기 - Main()

/// <summary>

/// 프로그램 시작하기

/// </summary>

private static void Main()

{

Database database = new Database();

Table<Group , int> groupTable = database.Tables.Create<Group , int>(group => group.ID , null);

Table<Member, int> memberTable = database.Tables.Create<Member, int>(member => member.ID, null);

IIndex<Member, int?> memberGroupIDIndex = memberTable.CreateIndex(new RedBlackTreeIndexFactory(), member => member.GroupID);

database.Tables.CreateRelation

(

groupTable.PrimaryKeyIndex,

memberGroupIDIndex,

x => x ?? -1,

x => x

);

groupTable.Insert(new Group() { ID = 1, Name = "그룹 1"});

groupTable.Insert(new Group() { ID = 2, Name = "그룹 2"});

memberTable.Insert(new Member() { ID = 1, Name = "김철수", GroupID = 1 });

memberTable.Insert(new Member() { ID = 2, Name = "홍길동", GroupID = 1 });

memberTable.Insert(new Member() { ID = 3, Name = "홍삼수", GroupID = 1 });

memberTable.Insert(new Member() { ID = 4, Name = "김영희", GroupID = 2 });

memberTable.Insert(new Member() { ID = 5, Name = "이주희", GroupID = 2 });

memberTable.Update(new Member() { ID = 3, Name = "홍삼수 (수정)", GroupID = 1 });

foreach(Member member in memberTable)

{

Console.WriteLine($"{member.Name}, {member.GroupID}");

}

#endregion

}

TestProject.zip

[C#/COMMON/NMEMORY/.NET6] LINQ를 사용해 데이터 조회하기

■ LINQ를 사용해 데이터를 조회하는 방법을 보여준다. ▶ Group.cs


namespace TestProject;

/// <summary>
/// 그룹
/// </summary>
public class Group
{
    //////////////////////////////////////////////////////////////////////////////////////////////////// Property
    ////////////////////////////////////////////////////////////////////////////////////////// Public

    #region ID - ID

    /// <summary>
    /// ID
    /// </summary>
    public int ID { get; set; }

    #endregion
    #region 명칭 - Name

    /// <summary>
    /// 명칭
    /// </summary>
    public string Name { get; set; }

    #endregion
}

namespace TestProject;

/// <summary>

/// 그룹

/// </summary>

public class Group

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

////////////////////////////////////////////////////////////////////////////////////////// Public

#region ID - ID

/// <summary>

/// ID

/// </summary>

public int ID { get; set; }

#endregion

#region 명칭 - Name

/// <summary>

/// 명칭

/// </summary>

public string Name { get; set; }

#endregion

}

▶ Member.cs


namespace TestProject;

/// <summary>
/// 회원
/// </summary>
public class Member
{
    //////////////////////////////////////////////////////////////////////////////////////////////////// Property
    ////////////////////////////////////////////////////////////////////////////////////////// Public

    #region ID - ID

    /// <summary>
    /// ID
    /// </summary>
    public int ID { get; set; }

    #endregion
    #region 성명 - Name

    /// <summary>
    /// 성명
    /// </summary>
    public string Name { get; set; }

    #endregion
    #region 그룹 ID - GroupID

    /// <summary>
    /// 그룹 ID
    /// </summary>
    public int? GroupID { get; set; }

    #endregion
}

namespace TestProject;

/// <summary>

/// 회원

/// </summary>

public class Member

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

////////////////////////////////////////////////////////////////////////////////////////// Public

#region ID - ID

/// <summary>

/// ID

/// </summary>

public int ID { get; set; }

#endregion

#region 성명 - Name

/// <summary>

/// 성명

/// </summary>

public string Name { get; set; }

#endregion

#region 그룹 ID - GroupID

/// <summary>

/// 그룹 ID

/// </summary>

public int? GroupID { get; set; }

#endregion

}

▶ Program.cs


using NMemory;
using NMemory.Indexes;
using NMemory.Tables;

namespace TestProject;

/// <summary>
/// 프로그램
/// </summary>
class Program
{
    //////////////////////////////////////////////////////////////////////////////////////////////////// Method
    ////////////////////////////////////////////////////////////////////////////////////////// Static
    //////////////////////////////////////////////////////////////////////////////// Private

    #region 프로그램 시작하기 - Main()

    /// <summary>
    /// 프로그램 시작하기
    /// </summary>
    private static void Main()
    {
        Database database = new Database();

        Table<Group , int> groupTable  = database.Tables.Create<Group , int>(group  => group.ID , null);
        Table<Member, int> memberTable = database.Tables.Create<Member, int>(member => member.ID, null);

        IIndex<Member, int?> memberGroupIDIndex = memberTable.CreateIndex(new RedBlackTreeIndexFactory(), member => member.GroupID);

        database.Tables.CreateRelation
        (
            groupTable.PrimaryKeyIndex,
            memberGroupIDIndex,
            x => x ?? -1,
            x => x
        );

        groupTable.Insert(new Group() { ID = 1, Name = "그룹 1"});
        groupTable.Insert(new Group() { ID = 2, Name = "그룹 2"});

        memberTable.Insert(new Member() { ID = 1, Name = "김철수", GroupID = 1 });
        memberTable.Insert(new Member() { ID = 2, Name = "홍길동", GroupID = 1 });
        memberTable.Insert(new Member() { ID = 3, Name = "홍삼수", GroupID = 1 });
        memberTable.Insert(new Member() { ID = 4, Name = "김영희", GroupID = 2 });
        memberTable.Insert(new Member() { ID = 5, Name = "이주희", GroupID = 2 });

        var queryable =
            from m in memberTable
            join g in groupTable on m.GroupID equals g.ID
            select new
            {
                Name      = m.Name,
                GroupName = g.Name
            };

        foreach(var item in queryable)
        {
            Console.WriteLine($"{item.Name}, {item.GroupName}");
        }
    }

    #endregion
}

using NMemory;

using NMemory.Indexes;

using NMemory.Tables;

namespace TestProject;

/// <summary>

/// 프로그램

/// </summary>

class Program

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Static

//////////////////////////////////////////////////////////////////////////////// Private

#region 프로그램 시작하기 - Main()

/// <summary>

/// 프로그램 시작하기

/// </summary>

private static void Main()

{

Database database = new Database();

Table<Group , int> groupTable = database.Tables.Create<Group , int>(group => group.ID , null);

Table<Member, int> memberTable = database.Tables.Create<Member, int>(member => member.ID, null);

IIndex<Member, int?> memberGroupIDIndex = memberTable.CreateIndex(new RedBlackTreeIndexFactory(), member => member.GroupID);

database.Tables.CreateRelation

(

groupTable.PrimaryKeyIndex,

memberGroupIDIndex,

x => x ?? -1,

x => x

);

groupTable.Insert(new Group() { ID = 1, Name = "그룹 1"});

groupTable.Insert(new Group() { ID = 2, Name = "그룹 2"});

memberTable.Insert(new Member() { ID = 1, Name = "김철수", GroupID = 1 });

memberTable.Insert(new Member() { ID = 2, Name = "홍길동", GroupID = 1 });

memberTable.Insert(new Member() { ID = 3, Name = "홍삼수", GroupID = 1 });

memberTable.Insert(new Member() { ID = 4, Name = "김영희", GroupID = 2 });

memberTable.Insert(new Member() { ID = 5, Name = "이주희", GroupID = 2 });

var queryable =

from m in memberTable

join g in groupTable on m.GroupID equals g.ID

select new

{

Name = m.Name,

GroupName = g.Name

};

foreach(var item in queryable)

{

Console.WriteLine($"{item.Name}, {item.GroupName}");

}

#endregion

}

TestProject.zip

[C#/COMMON/NMEMORY/.NET6] Database 클래스 상속하기

■ Database 클래스를 상속하는 방법을 보여준다. ▶ Group.cs


namespace TestProject;

/// <summary>
/// 그룹
/// </summary>
public class Group
{
    //////////////////////////////////////////////////////////////////////////////////////////////////// Property
    ////////////////////////////////////////////////////////////////////////////////////////// Public

    #region ID - ID

    /// <summary>
    /// ID
    /// </summary>
    public int ID { get; set; }

    #endregion
    #region 명칭 - Name

    /// <summary>
    /// 명칭
    /// </summary>
    public string Name { get; set; }

    #endregion
}

namespace TestProject;

/// <summary>

/// 그룹

/// </summary>

public class Group

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

////////////////////////////////////////////////////////////////////////////////////////// Public

#region ID - ID

/// <summary>

/// ID

/// </summary>

public int ID { get; set; }

#endregion

#region 명칭 - Name

/// <summary>

/// 명칭

/// </summary>

public string Name { get; set; }

#endregion

}

▶ Member.cs


namespace TestProject;

/// <summary>
/// 회원
/// </summary>
public class Member
{
    //////////////////////////////////////////////////////////////////////////////////////////////////// Property
    ////////////////////////////////////////////////////////////////////////////////////////// Public

    #region ID - ID

    /// <summary>
    /// ID
    /// </summary>
    public int ID { get; set; }

    #endregion
    #region 성명 - Name

    /// <summary>
    /// 성명
    /// </summary>
    public string Name { get; set; }

    #endregion
    #region 그룹 ID - GroupID

    /// <summary>
    /// 그룹 ID
    /// </summary>
    public int? GroupID { get; set; }

    #endregion
}

namespace TestProject;

/// <summary>

/// 회원

/// </summary>

public class Member

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

////////////////////////////////////////////////////////////////////////////////////////// Public

#region ID - ID

/// <summary>

/// ID

/// </summary>

public int ID { get; set; }

#endregion

#region 성명 - Name

/// <summary>

/// 성명

/// </summary>

public string Name { get; set; }

#endregion

#region 그룹 ID - GroupID

/// <summary>

/// 그룹 ID

/// </summary>

public int? GroupID { get; set; }

#endregion

}

▶ TestDatabase.cs


using NMemory;
using NMemory.Indexes;
using NMemory.Tables;

namespace TestProject;

/// <summary>
/// 테스트 데이터베이스
/// </summary>
public class TestDatabase : Database
{
    //////////////////////////////////////////////////////////////////////////////////////////////////// Property
    ////////////////////////////////////////////////////////////////////////////////////////// Public

    #region 그룹 테이블 - GroupTable

    /// <summary>
    /// 그룹 테이블
    /// </summary>
    public ITable<Group> GroupTable { get; private set; }

    #endregion
    #region 회원 테이블 - MemberTable

    /// <summary>
    /// 회원 테이블
    /// </summary>
    public ITable<Member> MemberTable { get; private set; }

    #endregion

    //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
    ////////////////////////////////////////////////////////////////////////////////////////// Public

    #region 생성자 - TestDatabase()

    /// <summary>
    /// 생성자
    /// </summary>
    public TestDatabase()
    {
        Table<Group , int> groupTable  = Tables.Create<Group , int>(g => g.ID, new IdentitySpecification<Group >(g => g.ID, 1, 1));
        Table<Member, int> memberTable = Tables.Create<Member, int>(m => m.ID, new IdentitySpecification<Member>(m => m.ID, 1, 1));

        GroupTable  = groupTable;
        MemberTable = memberTable;

        RelationOptions options = new RelationOptions(cascadedDeletion : true);

        IIndex<Member, int?> memberGroupIDIndex = memberTable.CreateIndex(new RedBlackTreeIndexFactory(), m => m.GroupID);

        Tables.CreateRelation
        (
            groupTable.PrimaryKeyIndex,
            memberGroupIDIndex,
            x =>  x ?? -1,
            x => x,
            options
        );
    }

    #endregion
}

using NMemory;

using NMemory.Indexes;

using NMemory.Tables;

namespace TestProject;

/// <summary>

/// 테스트 데이터베이스

/// </summary>

public class TestDatabase : Database

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 그룹 테이블 - GroupTable

/// <summary>

/// 그룹 테이블

/// </summary>

public ITable<Group> GroupTable { get; private set; }

#endregion

#region 회원 테이블 - MemberTable

/// <summary>

/// 회원 테이블

/// </summary>

public ITable<Member> MemberTable { get; private set; }

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - TestDatabase()

/// <summary>

/// 생성자

/// </summary>

public TestDatabase()

{

Table<Group , int> groupTable = Tables.Create<Group , int>(g => g.ID, new IdentitySpecification<Group >(g => g.ID, 1, 1));

Table<Member, int> memberTable = Tables.Create<Member, int>(m => m.ID, new IdentitySpecification<Member>(m => m.ID, 1, 1));

GroupTable = groupTable;

MemberTable = memberTable;

RelationOptions options = new RelationOptions(cascadedDeletion : true);

IIndex<Member, int?> memberGroupIDIndex = memberTable.CreateIndex(new RedBlackTreeIndexFactory(), m => m.GroupID);

Tables.CreateRelation

(

groupTable.PrimaryKeyIndex,

memberGroupIDIndex,

x => x ?? -1,

x => x,

options

);

}

#endregion

}

▶ Program.cs


namespace TestProject;

/// <summary>
/// 프로그램
/// </summary>
class Program
{
    //////////////////////////////////////////////////////////////////////////////////////////////////// Method
    ////////////////////////////////////////////////////////////////////////////////////////// Static
    //////////////////////////////////////////////////////////////////////////////// Private

    #region 프로그램 시작하기 - Main()

    /// <summary>
    /// 프로그램 시작하기
    /// </summary>
    private static void Main()
    {
        TestDatabase database = new TestDatabase();

        database.GroupTable.Insert(new Group() { Name = "그룹 1"});
        database.GroupTable.Insert(new Group() { Name = "그룹 2"});

        database.MemberTable.Insert(new Member() { Name = "김철수", GroupID = 1 });
        database.MemberTable.Insert(new Member() { Name = "홍길동", GroupID = 1 });
        database.MemberTable.Insert(new Member() { Name = "홍삼수", GroupID = 1 });

        database.MemberTable.Insert(new Member() { Name = "김영희", GroupID = 2 });
        database.MemberTable.Insert(new Member() { Name = "이주희", GroupID = 2 });

        foreach(Group group in database.GroupTable)
        {
            Console.WriteLine($"{group.ID}, {group.Name}");
        }

        foreach(Member member in database.MemberTable)
        {
            Console.WriteLine($"{member.ID}, {member.Name}, {member.GroupID}");
        }
    }

    #endregion
}

namespace TestProject;

/// <summary>

/// 프로그램

/// </summary>

class Program

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Static

//////////////////////////////////////////////////////////////////////////////// Private

#region 프로그램 시작하기 - Main()

/// <summary>

/// 프로그램 시작하기

/// </summary>

private static void Main()

{

TestDatabase database = new TestDatabase();

database.GroupTable.Insert(new Group() { Name = "그룹 1"});

database.GroupTable.Insert(new Group() { Name = "그룹 2"});

database.MemberTable.Insert(new Member() { Name = "김철수", GroupID = 1 });

database.MemberTable.Insert(new Member() { Name = "홍길동", GroupID = 1 });

database.MemberTable.Insert(new Member() { Name = "홍삼수", GroupID = 1 });

database.MemberTable.Insert(new Member() { Name = "김영희", GroupID = 2 });

database.MemberTable.Insert(new Member() { Name = "이주희", GroupID = 2 });

foreach(Group group in database.GroupTable)

{

Console.WriteLine($"{group.ID}, {group.Name}");

}

foreach(Member member in database.MemberTable)

{

Console.WriteLine($"{member.ID}, {member.Name}, {member.GroupID}");

}

#endregion

}

TestProject.zip

[C#/COMMON/NMEMORY/.NET6] Table 클래스 : Insert 메소드를 사용해 데이터 추가하기

■ Table<TEntity, TPrimaryKey> 클래스의 Insert 메소드를 사용해 데이터를 추가하는 방법을 보여준다. ▶ Group.cs


namespace TestProject;

/// <summary>
/// 그룹
/// </summary>
public class Group
{
    //////////////////////////////////////////////////////////////////////////////////////////////////// Property
    ////////////////////////////////////////////////////////////////////////////////////////// Public

    #region ID - ID

    /// <summary>
    /// ID
    /// </summary>
    public int ID { get; set; }

    #endregion
    #region 명칭 - Name

    /// <summary>
    /// 명칭
    /// </summary>
    public string Name { get; set; }

    #endregion
}

namespace TestProject;

/// <summary>

/// 그룹

/// </summary>

public class Group

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

////////////////////////////////////////////////////////////////////////////////////////// Public

#region ID - ID

/// <summary>

/// ID

/// </summary>

public int ID { get; set; }

#endregion

#region 명칭 - Name

/// <summary>

/// 명칭

/// </summary>

public string Name { get; set; }

#endregion

}

▶ Member.cs


namespace TestProject;

/// <summary>
/// 회원
/// </summary>
public class Member
{
    //////////////////////////////////////////////////////////////////////////////////////////////////// Property
    ////////////////////////////////////////////////////////////////////////////////////////// Public

    #region ID - ID

    /// <summary>
    /// ID
    /// </summary>
    public int ID { get; set; }

    #endregion
    #region 성명 - Name

    /// <summary>
    /// 성명
    /// </summary>
    public string Name { get; set; }

    #endregion
    #region 그룹 ID - GroupID

    /// <summary>
    /// 그룹 ID
    /// </summary>
    public int? GroupID { get; set; }

    #endregion
}

namespace TestProject;

/// <summary>

/// 회원

/// </summary>

public class Member

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

////////////////////////////////////////////////////////////////////////////////////////// Public

#region ID - ID

/// <summary>

/// ID

/// </summary>

public int ID { get; set; }

#endregion

#region 성명 - Name

/// <summary>

/// 성명

/// </summary>

public string Name { get; set; }

#endregion

#region 그룹 ID - GroupID

/// <summary>

/// 그룹 ID

/// </summary>

public int? GroupID { get; set; }

#endregion

}

▶ Program.cs


using NMemory;
using NMemory.Indexes;
using NMemory.Tables;

namespace TestProject;

/// <summary>
/// 프로그램
/// </summary>
class Program
{
    //////////////////////////////////////////////////////////////////////////////////////////////////// Method
    ////////////////////////////////////////////////////////////////////////////////////////// Static
    //////////////////////////////////////////////////////////////////////////////// Private

    #region 프로그램 시작하기 - Main()

    /// <summary>
    /// 프로그램 시작하기
    /// </summary>
    private static void Main()
    {
        Database database = new Database();

        Table<Group , int> groupTable  = database.Tables.Create<Group , int>(group  => group.ID , null);
        Table<Member, int> memberTable = database.Tables.Create<Member, int>(member => member.ID, null);

        IIndex<Member, int?> memberGroupIDIndex = memberTable.CreateIndex(new RedBlackTreeIndexFactory(), member => member.GroupID);

        database.Tables.CreateRelation
        (
            groupTable.PrimaryKeyIndex,
            memberGroupIDIndex,
            x => x ?? -1,
            x => x
        );

        groupTable.Insert(new Group() { ID = 1, Name = "그룹 1"});
        groupTable.Insert(new Group() { ID = 2, Name = "그룹 2"});

        memberTable.Insert(new Member() { ID = 1, Name = "김철수", GroupID = 1 });
        memberTable.Insert(new Member() { ID = 2, Name = "홍길동", GroupID = 1 });
        memberTable.Insert(new Member() { ID = 3, Name = "홍삼수", GroupID = 1 });
        memberTable.Insert(new Member() { ID = 4, Name = "김영희", GroupID = 2 });
        memberTable.Insert(new Member() { ID = 5, Name = "이주희", GroupID = 2 });

        foreach(Group group in groupTable)
        {
            Console.WriteLine($"{group.ID}, {group.Name}");
        }

        foreach(Member member in memberTable)
        {
            Console.WriteLine($"{member.ID}, {member.Name}, {member.GroupID}");
        }
    }

    #endregion
}

using NMemory;

using NMemory.Indexes;

using NMemory.Tables;

namespace TestProject;

/// <summary>

/// 프로그램

/// </summary>

class Program

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Static

//////////////////////////////////////////////////////////////////////////////// Private

#region 프로그램 시작하기 - Main()

/// <summary>

/// 프로그램 시작하기

/// </summary>

private static void Main()

{

Database database = new Database();

Table<Group , int> groupTable = database.Tables.Create<Group , int>(group => group.ID , null);

Table<Member, int> memberTable = database.Tables.Create<Member, int>(member => member.ID, null);

IIndex<Member, int?> memberGroupIDIndex = memberTable.CreateIndex(new RedBlackTreeIndexFactory(), member => member.GroupID);

database.Tables.CreateRelation

(

groupTable.PrimaryKeyIndex,

memberGroupIDIndex,

x => x ?? -1,

x => x

);

groupTable.Insert(new Group() { ID = 1, Name = "그룹 1"});

groupTable.Insert(new Group() { ID = 2, Name = "그룹 2"});

memberTable.Insert(new Member() { ID = 1, Name = "김철수", GroupID = 1 });

memberTable.Insert(new Member() { ID = 2, Name = "홍길동", GroupID = 1 });

memberTable.Insert(new Member() { ID = 3, Name = "홍삼수", GroupID = 1 });

memberTable.Insert(new Member() { ID = 4, Name = "김영희", GroupID = 2 });

memberTable.Insert(new Member() { ID = 5, Name = "이주희", GroupID = 2 });

foreach(Group group in groupTable)

{

Console.WriteLine($"{group.ID}, {group.Name}");

}

foreach(Member member in memberTable)

{

Console.WriteLine($"{member.ID}, {member.Name}, {member.GroupID}");

}

#endregion

}

TestProject.zip

[C#/COMMON/NMEMORY/.NET6] TableCollection 클래스 : CreateRelation 메소드를 사용해 테이블 관계 생성하기

■ TableCollection 클래스의 CreateRelation 메소드를 사용해 테이블 관계를 생성하는 방법을 보여준다. ▶ Group.cs


namespace TestProject;

/// <summary>
/// 그룹
/// </summary>
public class Group
{
    //////////////////////////////////////////////////////////////////////////////////////////////////// Property
    ////////////////////////////////////////////////////////////////////////////////////////// Public

    #region ID - ID

    /// <summary>
    /// ID
    /// </summary>
    public int ID { get; set; }

    #endregion
    #region 명칭 - Name

    /// <summary>
    /// 명칭
    /// </summary>
    public string Name { get; set; }

    #endregion
}

namespace TestProject;

/// <summary>

/// 그룹

/// </summary>

public class Group

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

////////////////////////////////////////////////////////////////////////////////////////// Public

#region ID - ID

/// <summary>

/// ID

/// </summary>

public int ID { get; set; }

#endregion

#region 명칭 - Name

/// <summary>

/// 명칭

/// </summary>

public string Name { get; set; }

#endregion

}

▶ Member.cs


namespace TestProject;

/// <summary>
/// 회원
/// </summary>
public class Member
{
    //////////////////////////////////////////////////////////////////////////////////////////////////// Property
    ////////////////////////////////////////////////////////////////////////////////////////// Public

    #region ID - ID

    /// <summary>
    /// ID
    /// </summary>
    public int ID { get; set; }

    #endregion
    #region 성명 - Name

    /// <summary>
    /// 성명
    /// </summary>
    public string Name { get; set; }

    #endregion
    #region 그룹 ID - GroupID

    /// <summary>
    /// 그룹 ID
    /// </summary>
    public int? GroupID { get; set; }

    #endregion
}

namespace TestProject;

/// <summary>

/// 회원

/// </summary>

public class Member

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

////////////////////////////////////////////////////////////////////////////////////////// Public

#region ID - ID

/// <summary>

/// ID

/// </summary>

public int ID { get; set; }

#endregion

#region 성명 - Name

/// <summary>

/// 성명

/// </summary>

public string Name { get; set; }

#endregion

#region 그룹 ID - GroupID

/// <summary>

/// 그룹 ID

/// </summary>

public int? GroupID { get; set; }

#endregion

}

▶ Program.cs


using NMemory;
using NMemory.Indexes;
using NMemory.Tables;

namespace TestProject;

/// <summary>
/// 프로그램
/// </summary>
class Program
{
    //////////////////////////////////////////////////////////////////////////////////////////////////// Method
    ////////////////////////////////////////////////////////////////////////////////////////// Static
    //////////////////////////////////////////////////////////////////////////////// Private

    #region 프로그램 시작하기 - Main()

    /// <summary>
    /// 프로그램 시작하기
    /// </summary>
    private static void Main()
    {
        Database database = new Database();

        Table<Group , int> groupTable  = database.Tables.Create<Group , int>(group  => group.ID , null);
        Table<Member, int> memberTable = database.Tables.Create<Member, int>(member => member.ID, null);

        IIndex<Member, int?> memberGroupIDIndex = memberTable.CreateIndex(new RedBlackTreeIndexFactory(), member => member.GroupID);

        database.Tables.CreateRelation
        (
            groupTable.PrimaryKeyIndex,
            memberGroupIDIndex,
            x => x ?? -1,
            x => x
        );
    }

    #endregion
}

using NMemory;

using NMemory.Indexes;

using NMemory.Tables;

namespace TestProject;

/// <summary>

/// 프로그램

/// </summary>

class Program

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Static

//////////////////////////////////////////////////////////////////////////////// Private

#region 프로그램 시작하기 - Main()

/// <summary>

/// 프로그램 시작하기

/// </summary>

private static void Main()

{

Database database = new Database();

Table<Group , int> groupTable = database.Tables.Create<Group , int>(group => group.ID , null);

Table<Member, int> memberTable = database.Tables.Create<Member, int>(member => member.ID, null);

IIndex<Member, int?> memberGroupIDIndex = memberTable.CreateIndex(new RedBlackTreeIndexFactory(), member => member.GroupID);

database.Tables.CreateRelation

(

groupTable.PrimaryKeyIndex,

memberGroupIDIndex,

x => x ?? -1,

x => x

);

}

#endregion

}

TestProject.zip

[C#/COMMON/NMEMORY/.NET6] Table 클래스 : CreateIndex 메소드를 사용해 인덱스 생성하기

■ Table<TEntity, TPrimaryKey> 클래스의 CreateIndex 메소드를 사용해 인덱스를 생성하는 방법을 보여준다. ▶ Member.cs


namespace TestProject;

/// <summary>
/// 회원
/// </summary>
public class Member
{
    //////////////////////////////////////////////////////////////////////////////////////////////////// Property
    ////////////////////////////////////////////////////////////////////////////////////////// Public

    #region ID - ID

    /// <summary>
    /// ID
    /// </summary>
    public int ID { get; set; }

    #endregion
    #region 성명 - Name

    /// <summary>
    /// 성명
    /// </summary>
    public string Name { get; set; }

    #endregion
    #region 그룹 ID - GroupID

    /// <summary>
    /// 그룹 ID
    /// </summary>
    public int? GroupID { get; set; }

    #endregion
}

namespace TestProject;

/// <summary>

/// 회원

/// </summary>

public class Member

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

////////////////////////////////////////////////////////////////////////////////////////// Public

#region ID - ID

/// <summary>

/// ID

/// </summary>

public int ID { get; set; }

#endregion

#region 성명 - Name

/// <summary>

/// 성명

/// </summary>

public string Name { get; set; }

#endregion

#region 그룹 ID - GroupID

/// <summary>

/// 그룹 ID

/// </summary>

public int? GroupID { get; set; }

#endregion

}

▶ Program.cs


using NMemory;
using NMemory.Indexes;
using NMemory.Tables;

namespace TestProject;

/// <summary>
/// 프로그램
/// </summary>
class Program
{
    //////////////////////////////////////////////////////////////////////////////////////////////////// Method
    ////////////////////////////////////////////////////////////////////////////////////////// Static
    //////////////////////////////////////////////////////////////////////////////// Private

    #region 프로그램 시작하기 - Main()

    /// <summary>
    /// 프로그램 시작하기
    /// </summary>
    private static void Main()
    {
        Database database = new Database();

        Table<Member, int> memberTable = database.Tables.Create<Member, int>(member => member.ID, null);

        IIndex<Member, int?> memberGroupIDIndex = memberTable.CreateIndex(new RedBlackTreeIndexFactory(), member => member.GroupID);
    }

    #endregion
}

using NMemory;

using NMemory.Indexes;

using NMemory.Tables;

namespace TestProject;

/// <summary>

/// 프로그램

/// </summary>

class Program

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Static

//////////////////////////////////////////////////////////////////////////////// Private

#region 프로그램 시작하기 - Main()

/// <summary>

/// 프로그램 시작하기

/// </summary>

private static void Main()

{

Database database = new Database();

Table<Member, int> memberTable = database.Tables.Create<Member, int>(member => member.ID, null);

IIndex<Member, int?> memberGroupIDIndex = memberTable.CreateIndex(new RedBlackTreeIndexFactory(), member => member.GroupID);

}

#endregion

}

TestProject.zip

[C#/COMMON/NMEMORY/.NET6] IdentitySpecification 클래스 : ID 컬럼 설정하기

■ IdentitySpecification 클래스를 사용해 ID 컬럼을 설정하는 방법을 보여준다. ▶ Group.cs


namespace TestProject;

/// <summary>
/// 그룹
/// </summary>
public class Group
{
    //////////////////////////////////////////////////////////////////////////////////////////////////// Property
    ////////////////////////////////////////////////////////////////////////////////////////// Public

    #region ID - ID

    /// <summary>
    /// ID
    /// </summary>
    public int ID { get; set; }

    #endregion
    #region 명칭 - Name

    /// <summary>
    /// 명칭
    /// </summary>
    public string Name { get; set; }

    #endregion
}

namespace TestProject;

/// <summary>

/// 그룹

/// </summary>

public class Group

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

////////////////////////////////////////////////////////////////////////////////////////// Public

#region ID - ID

/// <summary>

/// ID

/// </summary>

public int ID { get; set; }

#endregion

#region 명칭 - Name

/// <summary>

/// 명칭

/// </summary>

public string Name { get; set; }

#endregion

}

▶ Program.cs


using NMemory;
using NMemory.Tables;

namespace TestProject;

/// <summary>
/// 프로그램
/// </summary>
class Program
{
    //////////////////////////////////////////////////////////////////////////////////////////////////// Method
    ////////////////////////////////////////////////////////////////////////////////////////// Static
    //////////////////////////////////////////////////////////////////////////////// Private

    #region 프로그램 시작하기 - Main()

    /// <summary>
    /// 프로그램 시작하기
    /// </summary>
    private static void Main()
    {
        Database database = new Database();

        Table<Group, int> groupTable = database.Tables.Create<Group, int>(group => group.ID, new IdentitySpecification<Group>(x => x.ID, 1 , 1));
    }

    #endregion
}

using NMemory;

using NMemory.Tables;

namespace TestProject;

/// <summary>

/// 프로그램

/// </summary>

class Program

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Static

//////////////////////////////////////////////////////////////////////////////// Private

#region 프로그램 시작하기 - Main()

/// <summary>

/// 프로그램 시작하기

/// </summary>

private static void Main()

{

Database database = new Database();

Table<Group, int> groupTable = database.Tables.Create<Group, int>(group => group.ID, new IdentitySpecification<Group>(x => x.ID, 1 , 1));

}

#endregion

}

TestProject.zip

[C#/COMMON/NMEMORY/.NET6] TableCollection 클래스 : Create 메소드를 사용해 테이블 생성하기

■ TableCollection 클래스의 Create 메소드를 사용해 테이블을 생성하는 방법을 보여준다. ▶ Group.cs


namespace TestProject;

/// <summary>
/// 그룹
/// </summary>
public class Group
{
    //////////////////////////////////////////////////////////////////////////////////////////////////// Property
    ////////////////////////////////////////////////////////////////////////////////////////// Public

    #region ID - ID

    /// <summary>
    /// ID
    /// </summary>
    public int ID { get; set; }

    #endregion
    #region 명칭 - Name

    /// <summary>
    /// 명칭
    /// </summary>
    public string Name { get; set; }

    #endregion
}

namespace TestProject;

/// <summary>

/// 그룹

/// </summary>

public class Group

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

////////////////////////////////////////////////////////////////////////////////////////// Public

#region ID - ID

/// <summary>

/// ID

/// </summary>

public int ID { get; set; }

#endregion

#region 명칭 - Name

/// <summary>

/// 명칭

/// </summary>

public string Name { get; set; }

#endregion

}

▶ Program.cs


using NMemory;

namespace TestProject;

/// <summary>
/// 프로그램
/// </summary>
class Program
{
    //////////////////////////////////////////////////////////////////////////////////////////////////// Method
    ////////////////////////////////////////////////////////////////////////////////////////// Static
    //////////////////////////////////////////////////////////////////////////////// Private

    #region 프로그램 시작하기 - Main()

    /// <summary>
    /// 프로그램 시작하기
    /// </summary>
    private static void Main()
    {
        Database database = new Database();

        Table<Group, int> groupTable = database.Tables.Create<Group, int>(group => group.ID, null);
    }

    #endregion
}

using NMemory;

namespace TestProject;

/// <summary>

/// 프로그램

/// </summary>

class Program

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Static

//////////////////////////////////////////////////////////////////////////////// Private

#region 프로그램 시작하기 - Main()

/// <summary>

/// 프로그램 시작하기

/// </summary>

private static void Main()

{

Database database = new Database();

Table<Group, int> groupTable = database.Tables.Create<Group, int>(group => group.ID, null);

}

#endregion

}

TestProject.zip

[C#/COMMON/NMEMORY/.NET6] NMemory 누겟 설치하기

■ NMemory 누겟을 설치하는 방법을 보여준다. 1. Visual Studio를 실행한다. 2. [도구] / [NuGet 패키지 관리자] / [패키지 관리자 콘솔] 메뉴를 실행한다.

[C#/COMMON/NMEMORY/.NET6] Database 클래스 : 메모리 데이터베이스 생성하기

■ Database 클래스를 사용해 메모리 데이터베이스를 생성하는 방법을 보여준다. ▶ 예제 코드 (C#)


using NMemory;

Database database = new Database();

using NMemory;

Database database = new Database();