Questions tagged [subsonic]

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 dev cycle.

SubSonic 3.0 is the latest version of SubSonic and was released in June of 2009. Work on SubSonic 3.0 lasted close to a year, and revolved mostly around supporting LINQ.

The focus of SubSonic 3.0 is to provide tools, not guidance or an overall mindset/approach. There are a number of things in SubSonic that allow you to move faster while applying whatever patterning floats your boat. We're not as complete as NHibernate, but you'll work faster with less concept count. We're not as deep as Linq to SQL, but you can use our stuff on most databases.

1195 questions
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
2 answers

Filterable DataGrid with SubSonic

My goal is to create a DataGrid that uses a SubSonic object as its data source. The grid should have database-side paging and sorting, as well as columns that are intelligently filterable based on the data type of that column. I actually have a…
Pete Michaud
  • 1,813
  • 4
  • 22
  • 36
4
votes
3 answers

Is subsonic in asp.net is a good approach or not?

I am trying to make an enterprise application in asp.net. Is Subsonic a better approach or not? How do I write code using Subsonic in asp.net? Or is there another way to access data from the database if we want to fetch thousands of record.
chetan singhal
  • 948
  • 1
  • 13
  • 36
4
votes
2 answers

Select doesn't work on IQueryable but does on IList

I have two lines of code, one is AllItems().Where(c => c.Id== id) .Select(d => new Quality(d.QualityType)).ToList(); and the other one AllItems().Where(c => c.Id== id).ToList() .Select(d => new…
kay.one
  • 7,622
  • 6
  • 55
  • 74
4
votes
1 answer

Subsonic : Self Join , Table Alias

Is there a way with subsonic to preform a self join?
Matt
  • 41
  • 1
4
votes
1 answer

Failed to find or load the registered .Net Framework Data Provider exception subsonic

i created a dataaccess dll with subsonic. now i am using it with my app but i keep getting exceptions when i access it. {"Failed to find or load the registered .Net Framework Data Provider."} it keeps hitting this exception when it goes thro this…
junkone
  • 1,427
  • 1
  • 20
  • 45
4
votes
2 answers

WCF service Exception:The formatter threw an exception while trying to deserialize the message

The formatter threw an exception while trying to deserialize the message: There was an error while trying to deserialize parameter http://tempuri.org/:GetPatientInsuranceInformationResult. The InnerException message was 'Error in line 1…
user632299
  • 299
  • 3
  • 9
  • 22
4
votes
10 answers

Stored procedures or inline queries?

First of all there is a partial question regarding this, but it is not exactly what I'm asking, so, bear with me and go for it. My question is, after looking at what SubSonic does and the excellent videos from Rob Connery I need to ask: Shall we use…
balexandre
  • 73,608
  • 45
  • 233
  • 342
4
votes
5 answers

Is Subsonic compatible with .Net 4.0

Is the latest version of Subsonic compatible with Visual Studio 2010 / .Net 4.0?
Dean
  • 3,336
  • 6
  • 36
  • 37
4
votes
9 answers

If you had one wish for SubSonic what would it be?

I know this question seems subjective but it's really pretty simple. As a long term user, and part time contributor to SubSonic I'm interested in what the community thinks would be the single best way to improve it. So what's your opinion, how would…
Adam Cooper
  • 8,077
  • 2
  • 33
  • 51
4
votes
4 answers

Understanding MSDTC in Windows

To use transaction construct(as follows) in Subsonic, MSDTC needs to be running on Windows machine. Right? using (TransactionScope ts = new TransactionScope()) { using (SharedDbConnectionScope sharedConnectionScope = new…
AJ.
  • 345
  • 5
  • 19
4
votes
2 answers

Does SubSonic run under Mono?

Has anyone deployed SubSonic on Mono?
David Robbins
  • 9,996
  • 7
  • 51
  • 82
4
votes
2 answers

How do I pass constructor arguments with dependency injection using Castle.Windsor?

I am wiring up my first SubSonic 3 application (in an ASP.NET MVC 1.0 front-end) and am looking at Rob's SimpleRepository. I'm using Castle.Windsor as an injection framework. In my application startup, I configure Castle to bind a SubSonic…
nkirkes
  • 2,635
  • 2
  • 21
  • 36
4
votes
3 answers

What are some good ways to debug timeouts? (C#)

I'm building a site that runs fine for a few hours, but then *.asmx and *.ashx calls start timing out. The exception is: "Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool This may have occurred because all…
marclar
  • 3,026
  • 5
  • 35
  • 56
1 2
3
79 80