Lightspeed is an Object-Relational Mapper (ORM) for .NET.
Questions tagged [lightspeed]
56 questions
134
votes
19 answers
How to check whether mod_rewrite is enable on server?
Currently I am using the hosting with lightspeed server. Hosting says mod_rewrite is enabled but I can't get my script working there. Whenever I try to access the URL, it returns 404 - not found page.
I put the same codes at another server which is…

knightrider
- 2,533
- 7
- 30
- 42
13
votes
6 answers
Lightspeed vs NHibernate
What is the experience with LightSpeed? The comparison provided by Mindscape doesn't say too much about NHibernate. Lightspeed seems flexible, but I don't see much about performance. How well does Lightspeed perform? Also are there any drawbacks…

Papa Burgundy
- 6,397
- 6
- 42
- 48
7
votes
3 answers
SQL Update is really slow (about 20-50sec), Select takes less than 1 second
I have a SQL Tabe "Document" which contains a lot of rows (up to a few millions).
When I'm executing an Select-Statement it takes about 0.5seconds.
But when I'm executing an Update with the very same WHERE-clause it takes about 20 to 50 seconds,…

Tobias Koller
- 2,116
- 4
- 26
- 46
4
votes
6 answers
Convert string to int for ordering using LINQ
I'd like to order my list by a string converted into an int:
var orderedListOfRfidTags = uow.RfidTags.OrderBy(t => Convert.ToInt32(t.Number)).ToList();
but get: The method 'ToInt32' is not supported.

Dave Mateer
- 6,588
- 15
- 76
- 125
4
votes
1 answer
Why is autofac disposing an object before the HttpRequest ends?
I'm writing an ASP.NET MVC website, using autofac for dependency injection, and Mindscape's Lightspeed as the ORM. There's a UserRepository class, which depends on a lightspeed UnitOfWork, and which services the Logon controller.
Problem: The…

Mark
- 9,320
- 6
- 57
- 70
4
votes
3 answers
How do I group my LINQ query correctly?
I am having an issue getting my LINQ query to output as I would like. I am unsure I am taking the right approach.
Tables:
I have two tables Contacts and Permissions with which I perform a LEFT OUTER JOIN.
Join Query:
from contact in Contacts
join…

Scott
- 21,211
- 8
- 65
- 72
3
votes
2 answers
How do I convert an array of T (IEnumerable) to IQueryable for processing with LINQ?
I'm working on an app using a WCF server (using the new beta Mindscape LightSpeed ORM) and consuming the service at an ASP.NET MVC2 client. My entities show up at the client as array of T, or IEnumerable. I want to do cool things with the data…

DaveN59
- 3,638
- 8
- 39
- 51
3
votes
1 answer
Is there a Lightspeed 5.x NuGet package that can be used with ASP.Net 5?
I did a search on NuGet and couldn't find a Lightspeed NuGet package.
I have pro license for Lightspeed 5 so I have all the binaries I need to use Lightspeed in a non-ASP.Net 5 code.
However, it is my understanding that ASP.Net 5 doesn't allow you…

TheMagnificent11
- 1,424
- 4
- 19
- 40
3
votes
2 answers
LightSpeed with IoC/Dependency Injection using Repository Pattern
Does anyone have an example of using LightSpeed with the Repository Pattern using interfaces and dependency injection?

dsapala
- 123
- 2
- 5
3
votes
2 answers
Conditionally allowing for null in LINQ WHERE clause
Working:
I am trying to perform a LEFT OUTER JOIN between my Contacts table and my Permissions table. I have the basis of this working correctly, and get back a list of contacts regardless of whether they have a corresponding permission.
// Query…

Scott
- 21,211
- 8
- 65
- 72
2
votes
3 answers
How do I save changes to a sequential list of names to sql database?
OK, here's the scenario. I think it's pretty common, and I have solved it in a prior life using a brute-force approach, but I'm thinking there has to be a better way.
Given an ordered list of names, and a UI where the user can re-order, delete, edit…

DaveN59
- 3,638
- 8
- 39
- 51
2
votes
2 answers
Can I create domain schema only (without any data) in Amazon SimpleDB?
I am evaluating Amazon SimpleDB at this time. SimpleDB is very flexible in the sense that it does not have to have table (or domain) schemas. The schema evolves as the create / update commands flow in. All this is good but while I am using a…

Kabeer
- 4,138
- 7
- 40
- 62
2
votes
0 answers
Issues Logging in Twice After Installing Lightspeed Module
We are having an issue with logging in a second time on our site ever since we installed the lightspeed module. At first I thought this might have to do with the need for hole punching, but now I'm not sure.
If you try to log into our website the…

blttoinfinity
- 43
- 1
- 3
1
vote
2 answers
LightSpeed and multi-tenant databases
I have a database shared by many organisations (a multi-tennant scenario).
I would like to ensure that an authorised user can only view a single organisation's data without the need to to explicitly code such a constraint each time.
Is there a good…

Scott McKenzie
- 16,052
- 8
- 45
- 70
1
vote
1 answer
Excel VBA - When opening Hyperlink in chrome, my current sign-on to Lightspeed is Invalid?
I have been building a rather large Excel program for adding and editing Tags in lightspeed Retail POS since they have a rather weak interface.
At times, it would be nice to have a command button to open the product page in Lightspeed to double…