Vitorm.EntityGenerate 2.0.2

Vitorm.EntityGenerate

Library to generate Entity Type from Database

source address: https://github.com/VitormLib/Vitorm

Build	NuGet

Vitorm.EntityGenerate Documentation

Installation

Before using , install the necessary package:

dotnet add package Vitorm.EntityGenerate
dotnet add package Vitorm.Sqlite

Minimum viable demo

The Entity for table GeneratedUser does not exist, Vitorm.EntityGenerate can help us generate an temporary one.

using Microsoft.VisualStudio.TestTools.UnitTesting;
using Vitorm.Sql;
namespace Vitorm.MsTest.Sqlite
{
    [TestClass]
    public partial class EntityGenerate_Test
    {
        [TestMethod]
        public void Test()
        {
            // #1 init
            var entityNamespace = "Vitorm.MsTest.Sqlite";
            var guid = Guid.NewGuid().ToString();
            var filePath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, $"{guid}.sqlite.db");
            var connectionString = $"data source={filePath}";

            using var dbContext = new SqlDbContext();
            dbContext.UseSqlite(connectionString);

            dbContext.Execute(@"
DROP TABLE if exists GeneratedUser;
CREATE TABLE GeneratedUser(id integer NOT NULL PRIMARY KEY,  name text DEFAULT NULL);
Insert into GeneratedUser(id,name) values(1,'u146');
");

            // #2 test
            var dbSet = dbContext.GenerateDbSet(entityNamespace: entityNamespace, tableName: "GeneratedUser");
            var entityType = dbSet.entityDescriptor.entityType;

            // GetEntity
            dynamic user = dbSet.Get(1);
            string name = user.name;
            Assert.AreEqual("u146", name);

            BaseTest.TestDbSet(dbSet);
        }
    }
}

Test Example