如何从sqlite sql查询中检索日期并发送给调用函数

Question

我正在从db(sqlite)检索日期列值。

public Contacts ReadDaysLeft(int daysid)            
{               
    using (var dbConn = new SQLiteConnection(App.DB_Path))               
    {                  
      var data = dbConn.Query<DaysLeft>("select  * from DaysLeft where Id = " + daysid).FirstOrDefault();
      DateTime dt =  Convert.ToDateTime(data.Date);      
      return data;                
    }      
}

我可以从sql查询中得到日期值DateTime = Convert.ToDateTime(data.Date);

但我的问题是，如何发送日期值到我的调用函数…请帮助

Answer 1

来电者:

DateTime dt;
var result = ReadDaysLeft(123, out dt);
Console.WriteLine(dt); //Is that what you need?

Calee:

public Contacts ReadDaysLeft(int daysid, out DateTime dt)            
{               
    using (var dbConn = new SQLiteConnection(App.DB_Path))               
    {                  
      var data = dbConn.Query<DaysLeft>("select  * from DaysLeft where Id = " + daysid).FirstOrDefault();
      dt =  Convert.ToDateTime(data.Date);      
      return data;                
    }      
}

更多信息参见:out (c# Reference)