The sqlite-net-compactframework from lanwin

lanwin / sqlite-net-compactframework Goto Github PK

View Code? Open in Web Editor NEW

.Net Compact Framework port of sqlite-net. A small library to easily access SQLite databases from .NET/Mono/MonoTouch applications.

C# 2.01% C 97.99%

sqlite-net-compactframework's People

Contributors

Stargazers

Watchers

sqlite-net-compactframework's Issues

NotSupportedException

Exception:"notsupportedException"
SQLite.SQLite3.ColumnDouble(IntPtr stmt, Int32 index)
SQLite.SQLiteCommand.ReadCol(IntPtr stmt, Int32 index, ColType type, Type clrType)
SQLite.SQLiteCommand.ExecuteQuery[T](TableMapping map)
SQLite.SQLiteCommand.ExecuteQueryT
SQLite.TableQuery`1.GetEnumerator()

test entity:

public class EntityStock
{
    [PrimaryKey, AutoIncrement]
    public int Id { get; set; }
    [MaxLength( 8 )]
    public string Symbol { get; set; }

    public override string ToString( ) {return Symbol;   }
}

public class EntityValuation
{
    [PrimaryKey, AutoIncrement]
    public int Id { get; set; }
    [Indexed]
    public int StockId { get; set; }
    public DateTime Time { get; set; }
    public double Price { get; set; }

    public override string ToString( )
    {
        return string.Format( "{0:yyyy-MM-dd} {1:C}", Time, Price );
    }
}

test method:

private void GetStock( string stockSymbol )
{
    var stock = _db.QueryStock( stockSymbol );
    foreach ( var v in _db.QueryValuations( stock ) )
    {
        lbx.Items.Add( "   " + v.ToString( ) );
    }
}

public IEnumerable<EntityValuation> QueryValuations( EntityStock stock )
{
    return Table<EntityValuation>( ).Where( x => x.StockId == stock.Id );
}

error in sqlite.cs:

public IEnumerator<T> GetEnumerator( )
{
    return GenerateCommand( ).ExecuteQuery<T>( ).GetEnumerator( );
}

public List<T> ExecuteQuery<T>( ) where T : new( )
{
    return ExecuteQuery<T>( _conn.GetMapping( typeof( T ) ) );
}

public List<T> ExecuteQuery<T>( TableMapping map ) { }

Recommend Projects