In Unit Test Framework can we fetch values from DB or using PXSelect Query for Table

@girik06 The idea of Unit tests is that you can run them without a need to setup a DB. Setting up a DB is tedious and a source of errors if data in the DB is not matching. 

Instead, in the unit tests you should prepare all the data you need in the code of the test itself. 

E.g. see here:

https://github.com/Acumatica/UnitTestExamples/blob/master/UnitTestsDemo/Tests/CATransferTest.cs

We need to have a cashaccount for this test. So we just insert it in the cache:

graph.Caches[typeof(CashAccount)].Insert(
                 new CashAccount { 
                     CashAccountCD = "102000", 
                     CuryID = "USD" 
                 });

After that we can use PXSelect<CashAccount>.Select(graph) and it will return the inserted cashaccount form the cache.