C# (CSharp) SQLite.Net.SQLiteConnection.CreateCommand Beispiele

Beispiel #1

        public int GetAllShipCounts()
        {
            var connection = new SQLite.Net.SQLiteConnection(
                TinyIoC.TinyIoCContainer.Current.Resolve <ISQLitePlatform>(),
                TinyIoC.TinyIoCContainer.Current.Resolve <IFolderProvider>().MasterDatabasePath);

            var getCountCommand = connection.CreateCommand("select COUNT(*) from danfs_ships");

            return(getCountCommand.ExecuteScalar <int>());
        }