예제 #1
0
        public ADOLiteTests()
        {
            IDbConnectionSql Db2Connnection = new Tests.Class.SqlServerContext();

            // BuildQuery.DbConnection = Db2Connnection;

            buildquery = BuildQuery.ContextBuilder(Db2Connnection);
        }
예제 #2
0
        static void Main(string[] args)
        {
            //command.CommandText = "Select TLELEM, TLDESC from SIMCTLC.TBLLIN where TLCODE=640 "


            IDbConnectionSql Db2Connnection = new Tests.Class.DB2Context();
            // BuildQuery.DbConnection = Db2Connnection;

            BuildQuery buildquery = BuildQuery.ContextBuilder(Db2Connnection);

            object result;

            try
            {
                result = buildquery.Get <Matricula>(x => x.DMACCT == "250101620");
            }
            catch (Exception)
            {
                throw;
            }



            //IDbConnectionSql sqlConnnection = new SqlServerContext();
            //BuildQuery.DbConnection = sqlConnnection;



            //// arrange
            //string sql = string.Empty;
            //int totalBefor = 0;
            //int totalAfter = 0;

            //Aluno aluno = new Aluno { curso = "20", Nome = "Fia" };


            //// act
            //totalBefor = BuildQuery.Count("aluno");

            //// Insert query execution
            //BuildQuery.Insert(aluno, new List<string> { nameof(aluno.alunoID), nameof(aluno.data) });

            //totalAfter = BuildQuery.Count("aluno");


            ////Aluno aluno = new Aluno { alunoID = 4, nota = "10" };

            //bool resultado = BuildQuery.CheckAny<Aluno>((x) => x.nota == "10" && x.alunoID == 4);


            //Console.WriteLine(resultado);
            Console.Read();
        }