# MemoryDB

**Repository Path**: jackletter/memory-db

## Basic Information

- **Project Name**: MemoryDB
- **Description**: 使用c#写的一个内存db
- **Primary Language**: C#
- **License**: MIT
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2023-04-23
- **Last Updated**: 2023-04-23

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# MemoryDB

#### 介绍
使用c#写的一个内存db

```csharp
public class CategoryTable:Table<CategoryEntity,int>
{
	public Index<int> Sorts { get; set; }

	[IndexArgs(StringCompaire=StringCompare.IgnoreCase)]
	public Index<string> PathsStart { get; set; }
}

puclic class CategoryEntity
{
	public int Id { get; set; }
	public string Name { get; set; }
	public string Path { get; set; }
	public int Sort { get; set; }
	public DateTime CreateTime { get; set; }
}

var table = db.LoadTable<CategoryTable>(new List<CategoryEntity>());

//主键
//getById
var category = table.Primary.FirstOrDefault(1);
//range
var categories = table.Primary.Where(i=>i>2 && i<10).ToList();

//其他索引
var categories = table.Paths.Where(i=>i.StartWith("中国/河南")).ToList()
var categories = table.Paths.Where(i=>i=="中国/河南")).ToList()

//联合查询
var categories = table.Paths.Where(i=>i.StartsWith("中国/河南")).Where(i=>i.Row.Sort>10).Limit(1,10).ToList();
var page = table.Paths.Where(i=>i.StartsWith("中国/河南")).Where(i=>i.Row.Sort>10).ToPage(1,10);
IEnurable<CategoryEntity> categories = table.Paths.Where(i=>i.StartsWith("中国/河南")).Where(i=>i.Row.Sort>10).AsEnumarable();



Where<string> tmp = table.Paths.Where(i=>i.StartsWith("中国/河南"));


```