SQLite error on releasing android-app with XAMARIN.NET and SQLite

Question

I am working with VS 2017 and XAMARIN/Android and SQLite. In "debug" mode there is no problem. When i try to run the android "release" mode on the smart phone i become following error:

Unhandled Exception: System.Exception: Cannot create a table without columns (does 'SolarmonAndroidApp.Models.TicketPageModels.TicketType' have public properties?)

How can i properly configure the app to install the SQLite_DB on Android mobile phone.

Model:

using SQLite;
using System;
using System.Collections.Generic;
using System.Text;

namespace SolarmonAndroidApp.Models.TicketPageModels
{
    public class TicketType
    {
        [PrimaryKey, AutoIncrement]
        public int Id { get; set; }

        public int _Id { get; set; }
        public string Name { get; set; }
        public bool IsActive { get; set; }
        public bool IsFixed { get; set; }
    }
}

Calls:

        _sql.CreateTable<TicketAction>();
        _sql.CreateTable<TicketType>();
        _sql.CreateTables<Park, Section, Ticket, User>();
        _sql.CreateTables<Row, Inverter, Number, Pool, Attachment>();
        _sql.CreateTable<CatchLog>();
        _sql.CreateTable<AppSettings>();
        _sql.CreateTables<TicketChecklist, TicketCheckpoint, SubTicket>();

i think the exception is pretty self explanatory, does your TicketType class from Models > TicketPageModelsm have public properties? post your class here so we can help — Ricardo Dias Morais
– Ricardo Dias Morais, Commented Jul 30, 2019 at 10:39
You need to post the code that gives you the error. We cannot help you otherwise. Maybe start by 1. How you try to create the table?, 2. How you defined the class for which you want to create the table? — iSpain17
– iSpain17, Commented Jul 30, 2019 at 10:39
it does not work only in release mode ?, i.e. does it work in debug mode ? — Philippe Banwarth
– Philippe Banwarth, Commented Jul 30, 2019 at 11:40
What is the linking mode (project's Properties / Android Options / Linking ) ? Is it Sdk and user assemblies ? — Philippe Banwarth
– Philippe Banwarth, Commented Jul 30, 2019 at 12:06

Philippe Banwarth · Accepted Answer · 2019-07-31 11:18:05Z

1

Comments recap :

It seems that the problem was linked (pun intended) to the linker. It is the part of the build process that tries to remove unused code, with the laudable goal of reducing the APK size, but is sometimes too aggressive.

This can be changed in the project's properties (for a release build) : Android Options tab, Linker properties.

The safest choice for Linking is None but it results in huge APKs, so it is usually only useful to check if build problem is related to the linking process.

The best choice is almost always Sdk Assemblies Only : All of your code is left untouched, and most of the unused code is removed.

edited Jul 31, 2019 at 11:18

answered Jul 31, 2019 at 11:07

Philippe Banwarth

17.8k2 gold badges45 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQLite error on releasing android-app with XAMARIN.NET and SQLite

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related