sqlite-net Questions
3
Solved
In UWP, I enjoy the benefits of using SQLite.Net-PCL, creating classes to be used in apps as ObservableCollections to bind to the GridView. After including SQLiteNetExtensions to build a database w...
Phyliciaphylis asked 21/4, 2017 at 21:0
2
Solved
I have seen references to changes in SQLite-net that supports multi-column unique constraints. I know it can be done directly with sqlite however I prefer to stay wit the sqlite-net methods of doin...
Becalm asked 11/9, 2013 at 22:37
6
I recently moved across from SQLite.NET to SQLite-net-pcl due to the Android 7.0 SQlite issue.
In the process I have updated all my libraries and all is working well with regards to insert/drop et...
Englishman asked 20/1, 2017 at 11:2
3
Solved
I have one entity class as
public class someclass
{
public string property1 {get; set;}
public string property2 {get; set;}
public string property3 {get; set;}
}
and using sqlite connecti...
Unlace asked 6/5, 2013 at 12:2
2
Solved
I am using dotnet 6 on a M1 Pro, and am struggling to use the SQLite-Package.
System.DllNotFoundException: Unable to load shared library 'SQLite.Interop.dll' or one of its dependencies.
This is the...
Addlebrained asked 10/1, 2022 at 10:9
1
I'm using Lync syntax in a PCL using Xamarin.
public class settings
{
[PrimaryKey, AutoIncrement]
public int ID { get; set; }
public string user_name { get; set; }
public string password { g...
Icken asked 23/7, 2015 at 14:19
3
Solved
We are using the SQLite.NET PCL in a Xamarin application.
When putting the database under pressure by doing inserts into multiple tables we are seeing BUSY exceptions being thrown.
Can anyone exp...
Anabasis asked 19/9, 2016 at 15:40
4
I have a Xamarin Forms solution. I added sqlite-net-pcl as reference to all projects. It works fine on Android but crashes on Windows 8.1 and Windows Phone 8.1. I have an IOS project but I don't ha...
Beldam asked 5/5, 2017 at 18:36
4
I am trying to create a table using the latest version of sqlite-net-pcl nuget package
var db = new SQLiteAsyncConnection("data.db");
await db.CreateTableAsync<Site>();
The CreateTableAsyn...
Mojica asked 1/9, 2019 at 9:29
3
I'm using the following line of code to query some data from a given table in a SQLite database (platform is WP81 but I guess this doesn't matter here).
return await Connection.Table<WorkDay>...
Sweetheart asked 30/9, 2014 at 22:40
1
First time using SQLite, opted for SQLite.net-pcl,
I have a PCL library, that I consume from my UWP app, my PCL library has the DBContext class :
public NewspaperDataContext(ISQLitePlatform sqLit...
Presidency asked 27/2, 2016 at 11:18
4
Solved
I have build a UWP application using Sqlite. On my local machine I had to install the following SQLite for Universal Windows Platform Visual Studio Extension to get it to build. I followed this blo...
Ablebodied asked 6/5, 2016 at 10:55
7
Solved
I am developing a UWP. I am using the sqlite-net-pcl library. After upgrading my Application from RC to RTM , I got a runtime error - sqlite3.dll could not be found - if it runs on a Mobile emulato...
Pinchpenny asked 6/8, 2015 at 8:49
2
Solved
I am wondering if there is a way to write a generic repository for my Xamarin project versus writing a different Repository for each entity in my object. The Xamarin Tasky Pro example have one Repo...
Thanhthank asked 14/3, 2015 at 15:7
2
Solved
I'm trying to implement a database in my Windows 8.1 Modern UI application.
I made this for a Windows Phone 8.1 app successfully, but it doesn't work in a new Windows 8.1 app.
I got a SQLiteExcept...
Instrumentalism asked 3/10, 2014 at 15:9
2
Solved
I have the simplest of apps that I thought I would try on my device before I got too engrossed. However, I am getting the strangest error message when I run it on my iPhone (as apposed to the the e...
Aimless asked 5/5, 2015 at 17:18
3
I am working on an WinRT app. I want to use sqlite-net-extensions to support OneToMany, ManyToMany.
using SQLiteNetExtensions.Attributes;
using SQLite;
[Table("WorkFlow")]
public class Workflow
...
Foret asked 5/5, 2014 at 2:18
2
Solved
I'm using Sqlite-Net ORM and would like to delete all rows from a table that match a specific condition, like:
conn.Table<MyEntity>().Delete(t => t.someProperty == someValue);
There are...
Reagan asked 14/1, 2014 at 20:19
3
Solved
It's me again, the guy working with SQLite-net. I had my code working when I did not have AutoIncrement on my Primary Keys of the tables. I wanted to AutoIncrement the keys so I reconstructed the T...
Jacob asked 6/7, 2014 at 21:13
1
Solved
I am just curious about this, given that I've already read Xamarin's Documentation regarding Local Databases.
is it that sqlite-net-pcl is designed for use with XAMARIN?. I mean, if they both run ...
Barbel asked 12/8, 2016 at 23:52
0
I am using SQLite.Net-PCL in a UWP project. Now, I need to read one row of a table.
I could use something like:
var row = await _conn.QueryAsync<MyType>("SELECT * FROM MyTable WHERE ID=100"...
Emlin asked 27/7, 2016 at 15:32
2
Solved
I have ID of Row then I will update other values.
I don't know how to update my values!
My Table:
class MyTable
{
[PrimaryKey, AutoIncrement]
public int Id { get; set; }
public string Date { ...
Inception asked 4/11, 2015 at 10:59
1
Solved
Currently I am working on unit tests for a Xamarin MvvmCross Application using SQLite.Net-PCL 3.1.1. The unit test project is a normal .NET project.
So now I am mocking the MvxSqliteConnectionFact...
Richey asked 24/5, 2016 at 8:54
2
Solved
I am using SQLite-net together with the TwinCoders NuGet for extension methods in a MvvmCross Xamarin project. I want to make the database to stay updated even if I will modify the models in future...
Kerikeriann asked 30/3, 2016 at 14:31
2
Solved
I downloaded the package from NuGet and still there's no SQLite.cs neither SQLiteAsync.cs added to the project, If SQLite-NET is still not supporting VS 2015 RTM, Any possible alternatives?
Note t...
Groping asked 6/8, 2015 at 7:58
1 Next >
© 2022 - 2024 — McMap. All rights reserved.