Vitorm/test/Vitorm.EntityGenerate.MsTest/SqlServer/EntityGenerate_Test.cs

using Microsoft.VisualStudio.TestTools.UnitTesting;

using Vitorm.Sql;

namespace Vitorm.MsTest.SqlServer
{

    [TestClass]
    public partial class EntityGenerate_Test
    {

        [TestMethod]
        public void Test()
        {
            // #1 init
            var entityNamespace = "Vitorm.MsTest.SqlServer";
            var connectionString = Vitorm.Data.DataProvider(entityNamespace).CreateSqlDbContext().dbConnection.ConnectionString;
            using var dbContext = new SqlDbContext();
            dbContext.UseSqlServer(connectionString);

            dbContext.Execute(@"
if object_id(N'[GeneratedUser]', N'U') is not null  DROP TABLE [GeneratedUser];
CREATE TABLE [GeneratedUser] ([id] int NOT NULL PRIMARY KEY, [name] varchar(1000) );
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);
        }





    }
}