Simpper

This is a lightweight orm mapping and sql query excuter.

Any kind of support is welcomed.

Status:

Installation
Usage
- Sample entity
- Insert
- BulkInsert
- Update
- Query
- Delete
Advanced usage:
- Sharding:

Installation

Todo: pack as nuget package

Usage

Sample entity

[Table("TestEntity")]
public class TestEntity
{
    public TestEntity()
    {
        DateTimeField = DateTime.Now;
    }

    [Key]
    [Identity]
    public int Id { get; set; }

    [Column("StringField")]
    public string StringField { get; set; }
    [Column("IntField")]
    public int IntField { get; set; }
    [Column("DateTimeField")]
    public DateTime DateTimeField { get; set; }
    [Column("NullableDateTimeField")]
    public DateTime? NullableDateTimeField { get; set; }
    [Column("EnumField")]
    public TestEnum EnumField { get; set; }
    [Column("DecimalField")]
    public decimal DecimalField { get; set; }
    [Column("GuidField")]
    public Guid GuidField { get; set; }
    [Column("LongField")]
    public long LongField { get; set; }
    public string ExtraReadOnly {
        get { return this.StringField + this.IntField; }
    }
    [NotMapped]
    public string ExtraNotMapped { get; set; }
    [NotMapped]
    public string ExtraNotMappedWithBackingField { get; set; }
}

public enum TestEnum
{
    Default,
    One
}

Insert

using (var ormContext = new SqlConnection(_connStr).ToOrmContext())
{
    var entity = new TestEntity
    {
        IntField = 1,
        DateTimeField = DateTime.Now.ToUnixEpoch(),
        DecimalField = 0.23333333333M,
        EnumField = TestEnum.One,
        ExtraNotMapped = "ExtraNotMapped",
        ExtraNotMappedWithBackingField = "ExtraNotMappedWithBackingField",
        GuidField = Guid.Parse("025017ca-7259-4604-8760-85b4b343270a"),
        LongField = 2222222222,
        NullableDateTimeField = null,
        StringField = "StringField"
    };
    var affectRowCount = ormContext.Insert(entity);
}

BulkInsert

using (var ormContext = new SqlConnection(_connStr).ToOrmContext())
{
    var list = new List<TestEntity>();
    for (var i = 0; i < 100; i++)
    {
        list.Add(new TestEntity
        {
            IntField = i,
            StringField = i.ToString()
        });
    }
    var affectRowCount = ormContext.BulkInsert(list);
}

Update

using (var ormContext = new SqlConnection(_connStr).ToOrmContext())
{
    var affectRowCount = ormContext.Update<TestEntity>(
        x => x.GuidField == Guid.Parse("025017ca-7259-4604-8760-85b4b343270a"),
        new
        {
            LongField = entity.LongField + 3,
            IntField = entity.IntField + 4
        });
}

Query

Important:

In all conditional query, the entity field should be in the left side.
All functions that do with entity field(excluding these introduced bellow) is not supported

Note:

To select all, just pass x=>true (or optional params will be available in the near future).
Support Contains, StartWith and EndsWith for strings.

x.StringField.Contains("xx") to generate [StringField] LIKE '%xx%'.

Support sql in

var result = ormContext.QueryFirst<TestEntity>(x => x.IntField.In(new[] {2, 4, 7}));

Support nested conditions

var result = ormContext.QueryFirst<TestEntity>(
                x => x.IntField == 30 || x.LongField == 68 || x.StringField == "32" || x.StringField == "33" && x.IntField == 33 || !(x.IntField < 49))

SingleQuery

using (var ormContext = new SqlConnection(_connStr).ToOrmContext())
{
    var entity = ormContext.QueryFirst<TestEntity>(x => x.IntField == 3);
}

CountQuery

using (var ormContext = new SqlConnection(_connStr).ToOrmContext())
{
    var result = ormContext.Count<TestEntity>(x => x.IntField < 28);
}

PagedQuery

using (var ormContext = new SqlConnection(_connStr).ToOrmContext())
{
    var list = ormContext.QueryPage<TestEntity>(
        x => x.IntField >= 0,
        sort: x => x.StringField,
        asc: false,
        pageIndex: 0,
        pageSize: 10);
}

Delete

using (var ormContext = new SqlConnection(_connStr).ToOrmContext())
{
    var result = ormContext.Delete<TestEntity>(x => x.IntField < 28);
}

Advanced usage:

Sharding:

Please try look at the test project

snys98/Simpper