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
13
votes
1 answer

Subsonic custom mapping of objects to tables

I'm using Compact Framework 3.5 and have tentatively settled on a custom build of Subsonic 3.0 to do data access. The trouble is that I am used to developing model-first but am also interested in keeping control of my DB schema. Therefore, neither…
codekaizen
  • 26,990
  • 7
  • 84
  • 140
13
votes
2 answers

SQL Views in SubSonic 3.0

Is there any way that I can access my SQL views in SubSonic 3.0? The code generation seems to skip views altogether
Karl
  • 1,257
  • 4
  • 14
  • 16
11
votes
1 answer

variable 'x' of type 'Product' referenced from scope, but it is not defined

I have a class named Product in class library project. I am using SubSonic SimpleRepository to persist objects. I have a method as follows in Product class: public static IList Load(Expression> expression) { var…
TheVillageIdiot
  • 40,053
  • 20
  • 133
  • 188
8
votes
3 answers

Future Proof DALs

We are in the beginning of a really long development project with several sub projects. Basically each sub-project will take several months to develop. The code itself will be split up into several C# projects, but the physical database will be…
Timothy Baldridge
  • 10,455
  • 1
  • 44
  • 80
8
votes
4 answers

Subsonic 3.0.0.3 not generating parameters for stored procedures

I have a SQL Server 2008 database with a bunch of stored procedures. When I use the ActiveRecord Template provided with Subsonic 3.0.0.3, it generates methods for all of my stored procedures, but they do not have any parameters. I am dbo on the…
Mike Stonis
  • 2,184
  • 14
  • 24
7
votes
5 answers

Benchmark Linq2SQL, Subsonic2, Subsonic3 - Any other ideas to make them faster?

I am working with Subsonic 2 more than 3 years now... After Linq appears and then Subsonic 3, I start thinking about moving to the new Linq futures that are connected to sql. I must say that I start move and port my subsonic 2 with SubSonic 3, and…
Aristos
  • 66,005
  • 16
  • 114
  • 150
7
votes
3 answers

Adding DataAnnontations to Generated Partial Classes

I have a Subsonic3 Active Record generated partial User class which I've extended on with some methods in a separate partial class. I would like to know if it is possible to add Data Annotations to the member properties on one partial class where…
Naz
  • 1,793
  • 2
  • 13
  • 25
7
votes
2 answers

Subsonic 3 VS Entity Framework

Anyone worked with Subsonic3 and Entity Framework here who can tell me the pros and cons? This is my first time attempting to try these. Subsonic is easy to setup so as the Entity Framework. I am not sure if Entity Framework works with other…
Shuaib
  • 1,561
  • 3
  • 19
  • 28
6
votes
1 answer

Subsonic 3 - SimpleRepository

I am playing around with Subsonic 3's simple repository and am hitting walls in understanding how to deal with foreign keys... If I have a product object containing int ID; string name; string description; Category category; int categoryID…
Paul
  • 5,514
  • 2
  • 29
  • 38
6
votes
2 answers

Relationships and Lazy Loading in SubSonic 3.0

I'm playing around with SubSonic 3.0 at the moment, and it looks really straight-forward (except that I still have to decide between SimpleRepository and ActiveRecord, but that's another story). However, as the documentation is a bit sparse, I am…
Michael Stum
  • 177,530
  • 117
  • 400
  • 535
5
votes
3 answers

Subsonic 3 LINQ Projection issue, fixed or no?

I'm currently experiencing the issue mentioned here (and several other places): Subsonic 3 Linq Projection Issue This is occurring using the 3.0.0.4 release package, and it also occurs when I grab the latest from GitHub and build it. I am using the…
quentin-starin
  • 26,121
  • 7
  • 68
  • 86
5
votes
3 answers

Problem about SQLite's integer and int datatype

I meet a problem about: Object of type 'System.Int64' cannot be converted to type 'System.Int32' when run the SubSonic.Examples.SimpleRepo project base on SQLite provider. I fond that the data type for table Categories's column CategoryID is…
Liu Peng
  • 1,226
  • 2
  • 11
  • 13
4
votes
2 answers

Which SubSonic 3 template to use

EDIT: There's now a doc page on this so this question is irrelevant, also it's outdated. Read the docs not this question. I've been toying with the SubSonic 3 code generation for a month or so now and I'm interested in getting some feedback from…
Adam Cooper
  • 8,077
  • 2
  • 33
  • 51
4
votes
1 answer

SubSonic 3 simple repository question

I am using simple repository pattern of Subsonic 3 to store and get values from database. I want to know if I should use Singleton patten to create SimpleRepository or should create one whenever is needed. Like if I have Person class like…
TheVillageIdiot
  • 40,053
  • 20
  • 133
  • 188
4
votes
1 answer

Failed to batch insert in Subsonic3 with error "Must declare the scalar variable..."

I have met a problem about inserting multiple rows in a batch with Subsonic3. My development environment includes: 1. Visual Studio 2010, but use .NET 3.5 2. Active Record Mode in SubSonic 3.0.0.4 3. SQL Server 2005 express 4. Northwind sample…
cheka
  • 51
  • 4
1
2 3
…
37 38