tagged [ormlite-servicestack]

Ability to create clustered indexes in ServiceStack/ORMLite codefirst

Ability to create clustered indexes in ServiceStack/ORMLite codefirst I thought I saw it in ServiceStack 4 release notes, but search is failing me. For ServiceStack, does ORMLite have the ability to c...

ServiceStack AuthUserSession Roles & Permissions not populated when UseDistinctRoleTables

ServiceStack AuthUserSession Roles & Permissions not populated when UseDistinctRoleTables I'm not sure whether this is an issue or not, but AuthUserSession Roles an d Permissions properties are not po...

Typed query for INNER JOIN (SELECT DISTINCT)?

Typed query for INNER JOIN (SELECT DISTINCT)? Is it possible to create a typed query that produces the following SQL?

5 Jun at 10:24

Is it possible to do sub-query join using ServiceStack's OrmLite?

Is it possible to do sub-query join using ServiceStack's OrmLite? Is it possible to do sub-query join using ServiceStack's OrmLite? Something like this?

7 Jul at 02:16

Servicestack - possibility of mapping several POCO to one table

Servicestack - possibility of mapping several POCO to one table I'm looking for a way to map several POCO objects into single table in the ServiceStack. Is it possible to do this in a clean way, witho...

27 Feb at 21:29

ServiceStack OrmLite + Foreign Key

ServiceStack OrmLite + Foreign Key I've got the asp.net forms authentication tables in place, and I'd like to create a FK to one of the tables. Is this possible without creating a type to be used with...

26 Mar at 20:49

How do you inject with parameters using AutoFac?

How do you inject with parameters using AutoFac? I'm trying to figure out the syntax to inject OrmLiteConnectionFactory using AutoFac. This is a working example using Funq, another DI framework.

11 May at 17:31

Using ServiceStack Ormlite global filters with Session

Using ServiceStack Ormlite global filters with Session I want to alter the example found [here](https://github.com/ServiceStack/ServiceStack.OrmLite#global-insert--update-filters) so that modifyby is ...

28 Mar at 14:0

how do I set the command time out in the new ormlite api

how do I set the command time out in the new ormlite api I upgraded to the new version of ormlite and am updating my code but do not see where I can set the commandtime out now that every thing is off...

23 Aug at 09:22

Servicestack add field UserAuth table and check on login

Servicestack add field UserAuth table and check on login I want to add new field(s) on UserAuth table (for example : blocked, verified) and I want to check when login. How I can do this? I did not fou...

What is SqlExpressionVisitor

What is SqlExpressionVisitor I am new to ServiceStack & OrmLite, during my work, I frequently come across `SqlExpressionVisitor` And my question is: What is it basically? and what are the benefits of ...

Difference between QueryById() and GetById() in ServiceStack OrmLite

Difference between QueryById() and GetById() in ServiceStack OrmLite Can anyone explain difference between QueryById() and GetById() as they both have same signatures. And there are many common functi...

13 Mar at 17:38

Servicestack OrmLite Ignore insert update - POCO

Servicestack OrmLite Ignore insert update - POCO Is there any attribute set a POCO field just for SELECT. Something like below;

ServiceStack Ormlite issuing Sqlite specific command

ServiceStack Ormlite issuing Sqlite specific command I am running Ormlite against a sqlite database. Love it. I am adding and deleting lots of records and find that the database does well with an occa...

23 Aug at 15:5

ormlite columns with DB default and no specified value don't appear in INSERT statement

ormlite columns with DB default and no specified value don't appear in INSERT statement Is there a setting I can use to get ormlite to ignore columns that have a DB defined default when doing an inser...

24 Jan at 16:40

JSON serializer instead of JSV in ServiceStack ORMLite

JSON serializer instead of JSV in ServiceStack ORMLite Despite that JSV promoted as faster and more compact alternative to JSON, it's not supported by many platforms and databases, while JSON is. How ...

15 Jul at 15:22

Update WPF datagrid after changes happen in the sqlite database

Update WPF datagrid after changes happen in the sqlite database I'm trying to update my datagrid after I update/add/delete items from the database. Should I create a thread running in a loop and query...

ServiceStack assembly issue - ServiceStack.OrmLite.SqlServer

ServiceStack assembly issue - ServiceStack.OrmLite.SqlServer After installing ServiceStack.OrmLite.SqlServer NuGet Packages, I started getting below error out of no clue.

ServiceStack.OrmLite: How to Insert SYSDATE

ServiceStack.OrmLite: How to Insert SYSDATE I am using OrmLite Oracle in C#. I want to insert current sysdate instead of DateTime.Now in column having date data type, i.e. taking the date at the datab...

6 Mar at 01:10

ServiceStack SelectLazy<long> System.NullReferenceException

ServiceStack SelectLazy System.NullReferenceException Why is x null? It works when I use Select instead of SelectLazy, or when I use SelectLazy on the entire row and not just the Id.

20 Aug at 17:9

Map to custom column names with ServiceStack OrmLite (Without Attributes)

Map to custom column names with ServiceStack OrmLite (Without Attributes) Per title - Is it possible to map to SQL Table I am not interested to use attributes as I don't want to fill my POCOs with gar...

Is it possible to map SQL Server XML column in OrmLite?

Is it possible to map SQL Server XML column in OrmLite? We have a field in our database (SQL Server 2008) that of type "XML". Is it possible to map this into an ORMLite (ServiceStack 3.9.35) model? Wh...

Data annotation in Servicestack References vs ForeignKey

Data annotation in Servicestack References vs ForeignKey Well, in ServiceStack where can I read up on the merits and differences of [References(typeof(ABC))] and [ForeignKey(typeof(XYZ) ] What are t...

OrmLite pasing data do SP like object

OrmLite pasing data do SP like object Is it possible to consume store procedure with ormLite just buy passing object, without using Parameters.Add. Something like this. But this trow error Procedure o...

24 Jul at 16:10

Why is this code added to MetadataTypesHandler.ProcessRequest

Why is this code added to MetadataTypesHandler.ProcessRequest Why is this code added to `MetadataTypesHandler.ProcessRequest()` in ORMLite for ServiceStack? Looks like it's signing the page but the co...

27 May at 19:32