Stack Overflow
Stack Overflow

Questions tagged [coolstorage]

Vici CoolStorage is a fully typed Object Relational Mapping library for .NET 3.5, Windows Phone and MonoTouch. CoolStorage is currently (April 2011) the only ORM that runs on Windows Phone for local data access using SQLite in isolated storage

33 questions
7
votes
3 answers

ERROR in Metadata version mismatch for module /node_modules/angular2-cool-storage/index.d.ts, found version 4, expected 3,

I am getting below error on running ng build command. removed node_modules folder and npm installe giving below warning npm WARN angular2-cool-storage@3.1.2 requires a peer of @angular/core@5.0.0 but none was installed. npm WARN…
mahesh kajale
  • 510
  • 1
  • 5
  • 17
4
votes
1 answer

CoolStorage on Windows Phone 7 - Mapping Problem

I am using Vici.CoolStorage in a Windows Phone 7 application to access a SQLite database. I am getting a Null Reference Exception on this line: CSList regimens = Regimen.List(); I have two tables in my database: CREATE TABLE Regimen ( …
JeffCren
  • 396
  • 1
  • 5
  • 15
3
votes
0 answers

MonoTouch CoolStorage OneToMany caching issue

I'm experiencing an issue with CoolStorage where a OneToMany relationship is being cached when reading a list for the first time, that list then fails to update when the data changes later. When restarting my app the list is correct, so it must be…
danfordham
  • 980
  • 9
  • 15
2
votes
2 answers

CoolStorage field not equals filter

I am working on a Windows Phone 7 application with an SQLite Local Database and I've stuck with it a bit. I have several classes defined, each of them has a mapping set up and I wish to retrieve a list with some filterings. I have found many…
Bhawk1990
  • 126
  • 1
  • 5
2
votes
1 answer

Vici coolstorage text fields not showing properly in WP7 app (some characters missing)

I have a sqlite database that I access from my WP7 app using the coolstorage ORM. The charset used for the text fields of the db (which are in German) is UTF-8. The database is quite simple and only has one table. My model in the app looks something…
tomurillo
  • 47
  • 1
  • 5
2
votes
1 answer

How to access extra data in Many-to-Many relationship in CoolStorage?

I'm using CoolStorage in a project where I have some Many-to-Many relationships. Some of the join tables have extra data on them which describe the relationship. For example: Table Alpha, Beta, and AlphaBeta. Many-to-Many relationship between Alpha…
Zack
  • 2,291
  • 2
  • 23
  • 38
2
votes
1 answer

how to you alter a sqlite db with coolstorage on wp7?

I'm writing an app for wp7 using coolstorage and sqlite as the database. The reason I chose sqlite was because it appears to have a good ability to do updates to the schema. However, in my testing I can run an 'alter table...' command but if I add a…
Zack
  • 2,291
  • 2
  • 23
  • 38
2
votes
2 answers

Using Vici cool Storage with monodroid

Hey, At the moment I'm not sure how officially supported it is but, there have been reports of people successfully using monodroid with vici coolStorage. I have been able to drop the assemblies into my project and compile however, certain classes…
Terrance
  • 11,764
  • 4
  • 54
  • 80
2
votes
1 answer

how do i execute a stored procedure with vici coolstorage?

I'm building an app around Vici Coolstorage (asp.net version). I have my classes created and mapped to my database tables and can pull a list of all records fine. I've written a stored procedure where the query jumps across databases that aren't…
lincolnk
  • 11,218
  • 4
  • 40
  • 61
2
votes
1 answer

WPF Datagrid binding with vici coolstorage CSList causes cast error

When I try to use a CSList as the ItemsSource for a WPF DataGrid, I get an error Unable to cast object of type 'System.Object[]' to type 'Product[]' I'm not entirely sure it is possible to use this as a binding source, but according to the almost…
Quasi_Stomach
  • 160
  • 7
2
votes
1 answer

Are UniqueIdentifier keys supported by Vici CoolStorage for MonoTouch?

A sqlite table declared like this: CREATE TABLE Note(Id UNIQUEIDENTIFIER, Title TEXT) is correctly read by Vici CoolStorage on Windows, but on MonoTouch, the following exception is thrown: [ERROR] FATAL UNHANDLED EXCEPTION:…
bright
  • 4,700
  • 1
  • 34
  • 59
2
votes
1 answer

Vici.CoolStorage: filter with ManyToOne and ManyToMany relation

I got an exception in Vici.CoolStorage 'Unable to cast object of type 'System.String' to type 'QueryExpression' when using the following filter on the .List() method of my Event class: Event.List("has(Resource where has(Teams where TeamID =…
Roel
  • 77
  • 3
1
vote
2 answers

NullReferenceException when running query in Vici CoolStorage

Here is my code : BookMark[] st = CSDatabase.RunQuery( @"SELECT * FROM Bookmark WHERE link='" + link + "'"); class BookMark { public string link; } Sometimes I get a NullReferenceException but I don't why. Please help me!
thongaduka
  • 627
  • 1
  • 8
  • 19
1
vote
1 answer

How do I switch between different contexts in CoolStorage

I ave different databases with the same schema, the only difference is the connectionstring. Is it possible to use the context options in CoolStorage to switch the context of the CoolStorage instance to another SQL instance?
Bjorn Bailleul
  • 3,055
  • 1
  • 20
  • 25
1
vote
1 answer

Searching many-to-many relations with Vici CoolStorage

For an application used for managing booktitles and such, I'm using CoolStorage as an ORM. The database has a table named 'titles'. Each title can have n authors, stored in the 'authors' table. The two tables are connected through the linktable…
Cpt. eMco
  • 565
  • 4
  • 13
1
2 3