Stack Overflow
Stack Overflow

Questions tagged [simplerepository]

31 questions
4
votes
1 answer

Subsonic:SimpleRepository Parent Child relationship

I am trying to use the SimpleRepository feature in Subsonic3 - first of all, I must say a big thanks to RobC - Subsonic really rocks, and I can't wait to see additional updates to the SimpleRepository. I am a big fan of the migration approach…
A J
4
votes
2 answers

Parent and Child object in SimpleRepository

How would it work in Subsonic's SimpleReporitory if I wanted to be able to have a 1 to many relationship between objects? Would I have to create a bridge object and then build my parent object at runtime, or is this support built in? What I am…
MrHinsh - Martin Hinshelwood
  • 23,409
  • 5
  • 46
  • 69
3
votes
0 answers

Invalid Object Name Exception Thrown on Update

I have a project using Simple Repository which was working before I rebuilt my dev machine. This may just be coincidence but I am now using SQL Server 2008 Express to develop against rather than 2005 and now when I run my project I get the exception…
ProNotion
  • 3,662
  • 3
  • 21
  • 30
3
votes
1 answer

Subsonic 3, SimpleRepository, SQL Server: How to find rows with a null field?

How ca I use Subsonic's Find method to search for rows with a field containing the "null" value. For the sake of the discussion, let's assume I have a c# class called "Visit" which contains a nullable DateTime field called "SynchronizedOn" and…
desautelsj
  • 3,587
  • 4
  • 37
  • 55
3
votes
2 answers

Can SubSonic's SimpleRepository operate in-memory?

I'm working with Subsonic's SimpleRepository, and I'm trying to write some unit tests so they don't touch the database, but I'm having trouble figuring out if SimpleRepository can work against in-memory lists (Like the active record can) instead of…
Lance Fisher
  • 25,684
  • 22
  • 96
  • 122
3
votes
2 answers

Technologies to implement repository similar to dropbox

I have do investigate some ways and technologies to implement a server or client-server similar to dropbox (a simple repository)... Probably I'm not making the best search but I can't find the best technologies to implement or some examples or open…
José Barbosa
  • 913
  • 8
  • 17
2
votes
3 answers

Lambda Contains in SimpleRepository.Find

In SubSonic 3.04's SimpleRepository, I cannot seem to perform a Contains operation within a lambda expression. Here's a trivial example: SimpleRepository repo = new SimpleRepository("ConnectionString"); List userIds = new…
Anton
  • 4,554
  • 2
  • 37
  • 60
2
votes
1 answer

Lifetime management of a SimpleRepository

I'm just starting with SubSonic 3 and playing with the SimpleRepository approach. What's the intended lifetime of SimpleRepository classes when used in a desktop application? Are you expected to keep creating a new instance for everytime you want to…
Scott Bussinger
  • 2,767
  • 4
  • 28
  • 29
1
vote
2 answers

Get Id back when using SubSonic SimpleRepository AddMany

How can I get the Id back to the object when I'm using the AddMany function with SubSonic SimpleRepository. All my objects still get Id=0 when after using it. SimpleRepository repository = new…
Andreas
  • 1,311
  • 5
  • 24
  • 39
1
vote
1 answer

SubSonic SimpleRepository - Foreign Objects

SubSonic SimpleRepository doesn't seem to have a lot of support for foreign relations. How can I have foreign relationships in my code models that persist and load from the database naturally?
Anton
  • 4,554
  • 2
  • 37
  • 60
1
vote
3 answers

SubSonic Simple Repository One-To-Many

I made a class like: public class Video { public Guid VideoID { get; set; } public VideoCategory VideoCategory { get; set; } public int SortIndex { get; set; } public string Title { get; set; } public string Body { get; set; } …
Cederstrom
  • 58
  • 4
1
vote
1 answer

Subsonic SimpleRepository Nullable string problem

I am having a problem with subsonic simplerepository. I have a users class and it has some optional fields.these optional fields are of type string. As soon as I try to persist my object , if the optional fields are null , an exception is being…
gagan
  • 11
  • 2
1
vote
1 answer

Subsonic map POCO to table of a different name

I started a small project and wanted to use Subsonic's SimpleRepository for my database layer. If I have table in my database called Member and I want to create a POCO called TeamMember. Can I map class TeamMember to table Member via an…
Eric Neunaber
  • 431
  • 3
  • 10
1
vote
1 answer

How do you handle SubSonic 'relationships' with migration?

According to this article: http://subsonicproject.com/docs/3.0_Migrations Bottom line: if you're a developer that is concerned about database design, migrations might not be for you. Ok, that's fine, I can treat the database as simply a persistent…
Daniel T.
  • 37,212
  • 36
  • 139
  • 206
1
vote
1 answer

Does SimpleRepository support any in-memory or other "alternative" database engines?

I am looking for options other than MS SQL Server/Express. There seem to be quite a few file based or in-memory database engines supporting some subset or dialect of SQL. Preferably it would be an engine not requiring installation at all. Is any of…
Marek
  • 10,307
  • 8
  • 70
  • 106
1
2 3