Stack Overflow
Stack Overflow

Questions tagged [subsonic3]

SubSonic is A Super High-fidelity Batman Utility Belt that works up your data access (using LINQ in 3.0), throws in some much-needed utility functions, and generally speeds along your development cycle.

SubSonic is an open source project designed to act as a data access layer in your application. It was originally conceived by Rob Conery.

SubSonic is A Super High-fidelity Batman Utility Belt that works up your data access (using LINQ in 3.0), throws in some much-needed utility functions, and generally speeds along your development cycle.

Our focus is that you have better things to do with your time than worry about data access. It's a problem - we understand. But we're here to help with the addiction.

The main project website is located at http://subsonicproject.com/.

557 questions
3
votes
3 answers

Linq and SubSonic - returning nested complex types

I'm new to SubSonic and reasonably new to LINQ as well, so I'm just trying to put a little app together. I've got the templates all sorted and running okay, but I've run into a bit of trouble with this LINQ statement (simplified slightly, the real…
Matt B
  • 8,315
  • 2
  • 44
  • 65
3
votes
2 answers

SubSonic + Oracle - what's better 2.2 or 3?

I've been using SubSonic 2 & 2.2 for a few years now with Sql Server. For my new job I just recently used SubSonic 2.2 with Oracle and ran into a few small issues. Example: It could not find a column in a table at run time even though it found it…
aron
  • 2,856
  • 11
  • 49
  • 79
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
2 answers

LINQ, "Argument types do not match" error, what does it mean, how do I address it?

I'm new to linq and I'm trying to databind to an anonymous type. I'm using SubSonic 3.0 as my DAL. I'm doing a select from 2 tables like so var myDeal = (from u in db.Users select new { …
Biff MaGriff
  • 8,102
  • 9
  • 61
  • 98
3
votes
2 answers

Subsonic Query Construction for Contains(Guid)

I have a "Notes" table. Notes support one level of threading - in other words you can reply to a note but cannot reply to another reply. So the table looks something like the following: CREATE TABLE [dbo].[Notes] ( [NoteId] [uniqueidentifier]…
sestocker
  • 3,522
  • 6
  • 27
  • 32
3
votes
0 answers

.Net RIA Services and SubSonic3 usage examples

I am looking for any examples which ideally cover several possible combinations ( SimpleRepository, ActiveRecord , POCO ) - something similar to Brad Abrams…
MicMit
  • 2,372
  • 5
  • 28
  • 41
3
votes
2 answers

Subsonic 3.0 and linq

I'm playing around with Subsonic 3.0 SimpleRepository and try to get menus and menuitems with one linq query, but the menuitems is allways null Menu public class Menu { public Menu() { MenuId = 0; MenuName = ""; …
Martin Overgaard
  • 355
  • 2
  • 7
  • 21
3
votes
2 answers

Avoid App.config file in project when using with SQLite/SubSonic (or any other database)

I have a project which I am developing with SQLite and SubSonic 3. I want to know that how can I avoid the App.config file altogether. How do I tell my program to use SQLite Data provider. I mean, how can I tell it this: …
Yogesh
  • 14,498
  • 6
  • 44
  • 69
3
votes
3 answers

Subsonic 3.0.0.3 SQL Paging using Linq

Have just updated from Subsonic 2.2 ActiveRecord to 3.0.0.3. I am trying to use LINQ to do a paged Find query like this (my object/table is called "Repository"): Repository.Find(item => item.DocumentTitle.Contains(searchTerm)) .OrderBy(i =>…
Steve
  • 113
  • 9
3
votes
2 answers

SQLite Int64 vs Int32 Problem and SubSonic ActiveRecord

I thought this was covered elsewhere but I don't see it now. Anyway, having a problem with a simple v3 query. Using SQLite ADO.NET provider 1.0.65.0. My table structure looks like this: CREATE TABLE "SamplerData" ("RowId" INT PRIMARY KEY NOT NULL…
Snowy
  • 5,942
  • 19
  • 65
  • 119
3
votes
2 answers

can't select into class using linq

I have a query that works fine when using an anonymous type but as soon as I try to un-anonymize it it fails to select all values into the class. here is the linq i'm using (in combination with Subsonic 3): var producten = (from p in Premy.All() …
Yannick Smits
  • 875
  • 9
  • 14
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
7 answers

Subsonic 3 - how do you execute a stored procedure that returns a value?

How do you execute a stored procedure in subsonic 3.0 that returns a value? For example many of my stored procedures return @@identity, and I can't figure out how to access that value without re querying the table. Again, not an output parameter,…
mafudge
  • 33
  • 1
  • 4
3
votes
3 answers

Subsonic 3.0 General Questions

Ok, I was eagerly awaiting the release of subsonic 3.0 to use as my low-level data layer, and now its out. I'm currently using the ActiveRecord templates (having tried both the repository and advanced templates) and I have one HUGE request and a…
Jeff
  • 121
  • 1
  • 8
1 2
3
…
37 38