ormlite-servicestack Questions

2

Solved

I have started using ServiceStack and OrmLite for the first time and have got myself in a bit of a pickle. I have built 2 classes, 1 is to take the input parameters and 1 is to hold the response. ...
Mapel asked 1/2, 2014 at 11:10

1

Solved

Is there a preferred way to detect change in your code model and automatically recreate database? I don't need to migrate data, if there is a change I would be OK with just completely dropping all ...
Edgaredgard asked 23/1, 2014 at 22:17

3

Solved

Currently there exists an async branch of ServiceStack which will make it possible to create async services. But to get all benefits of async, all IO bound operations should be async and therefore ...

2

I would like to write a method for querying table with one method by null cheking parameters using SqlExpressionVisitor of Ormlite Here is my method : public static List<UserChatsDTO> GetUse...
Sweated asked 8/5, 2013 at 15:50

2

Solved

tl;dr: I am registering a serializer and a deserializer on a struct. The serializer is not called, but the deserializer is. How can I fix this? It works properly on reference types, and doing JsC...
Bookstand asked 27/11, 2013 at 15:30

3

Solved

I am using ServiceStack.OrmLite to persist data in a SQLite database, and quite happy with it so far. However, many of my objects have properties of a complex type which I don't want serialized us...

1

I've got the ServiceStack MiniProfiler enabled in my AppHost (in Application_Start), and I can view the SQL generated by OrmLite in my page. (using SS v3.9.59.0) What I can't see in the profile tr...
Tympany asked 24/9, 2013 at 0:11

1

Solved

I'm using the Db property in a ServiceStack service to access my database but every now and then I get the following error from IIS: Timeout expired. The timeout period elapsed prior to obtaining ...
Iverson asked 12/11, 2013 at 11:20

1

Solved

Trying to reduce repetition in my code by making a generic GET method. I am using OrmLite and its SQLExpressionVisitor update... The goal is to pass in a lambda. I have seen a few other posts that ...
Push asked 9/10, 2013 at 19:13

2

I'm implementing Repository Pattern using ServiceStack.ORMLite like this: public class MyRepository : IMyRepository { private IDbConnectionFactory DbConnectionFactory = null; public MyRepositor...
Gameness asked 20/2, 2013 at 3:26

1

I love SS but I'm scratching my head trying to unit test my business layer. I'm new to unit testing andmocking and been reading up on NSubstitute as this looks like a fun mocking layer. I have my ...

1

Solved

Is there a way to specify that I want all of the DateTimes that OrmLite materializes to be set to UTC kind? I store a lot of DateTimes in my database via stored procedures when a row is inserted: ...
Contrive asked 2/9, 2013 at 21:28

1

Solved

I'm wondering if ServiceStack.OrmLite's JoinSqlBuilder allow to build the following simple query: SELECT * FROM Table1 a INNER JOIN Table2 b ON ... WHERE a.Column1 = 1 AND (a.Column2 = 2 OR b.Co...
Railroader asked 26/6, 2013 at 4:23

2

i'm trying ormlite. i'm finding that when i insert an object with a DateTime property, it is getting -8:00 (my timezone is +8) applied by ormlite. It should be inserted with literally what the time...
Shortfall asked 10/1, 2013 at 4:13

2

Solved

When using IDbConnection.ExecuteSql how do I set the Command Timeout? IDbConnection db = ConnectionFactory.OpenDbConnection(); db.ExecuteSql("..."); If I use the IDbCommand.ExecuteSql ( See belo...
Genia asked 12/3, 2013 at 5:6

2

Solved

I'm attempting to query my db using Enumerable.Contains inside a SqlExpressionVisitor.Whereclause. When the lambda is compiled, I'm getting a null reference exception. When the visitor makes it to...
Tush asked 17/7, 2013 at 4:36

2

Solved

Currently, I am using OrmLite for DB operations. I am also planning to use Dapper ORM, but can anyone point me how to integrate DapperORM in ServiceStack. Do I need to implement both IDbConnection ...
Sig asked 18/3, 2013 at 21:9

1

Solved

ServiceStack ORMLite is great, I've typically steered clear of the ORM mentality preferring to build databases as it makes sense to build databases instead of a 1:1 class model. That said, there ar...

2

Solved

I have a model call address, with that model i have created a few crud operations, in the process of doing this i want a way i could create a query based on any number of properties: public static...
Speechmaker asked 29/3, 2013 at 14:36

1

Supposing that there are two repository interface : interface IFooRepository { void Delete(int id); } interface IBarRepository { void Delete(int id); } And an IUnitOfWork interface like : in...
Saintpierre asked 20/2, 2013 at 6:33

1

Solved

In dapper you can do something like: var items = connection.Query<Items>("SELECT * FROM `@database`.`table` WHERE `id` IN @idList;", new {database = DatabaseName, idList = someList.Select(n ...
Goddord asked 13/2, 2013 at 15:59

4

Solved

I recently started working with ServiceStack and its ORMLite framework. I have searched on Google and browsed the source code but couldn't find anything relevent. Is there any way to select specif...
Prevost asked 2/10, 2012 at 18:41

4

Solved

I selected ServiceStack OrmLite for my project which is a pure Data-Oriented application. I am willing to allow the end user to create his own Object Types defined in an XML format that will be use...
Inlaw asked 20/1, 2013 at 0:23

1

Solved

Anyone know how to apply the correct Alias attribute to query tables with schema names? I have a table called accounts.register. I've tried using [Alias("accounts.register")] as the class decorat...
Entwine asked 19/12, 2012 at 4:36

1

Solved

I'm building an app around the servicestack framework and need to be able to access data in both Oracle and MS Sql Server. Is this possible using ORMLite, it seems that I can only set a single dial...
Sazerac asked 3/12, 2012 at 20:58

© 2022 - 2024 — McMap. All rights reserved.