Stack Overflow
Stack Overflow

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

Subsonic many-to-many

For Subsonic users, is there a source of information about how to deal with many-to-many relations in Subsonic? I keep getting "//no ManyToMany tables defined (0)" in my generated code, although I have defined the right relations in database. any…
Emad Alashi
  • 493
  • 6
  • 13
3
votes
1 answer

Combining multiple SubSonic.Where filters

Is it possible to combine multiple filters in Subsonic 2.1 to a shorter piece of code? SubSonic.Where filterTaal = new SubSonic.Where(); filterTaal.ColumnName = Pagina.Columns.Taal; filterTaal.Comparison =…
Caspar Kleijne
  • 21,552
  • 13
  • 72
  • 102
3
votes
2 answers

Subsonic - Active Records doesn't grab all my tables

I have a real simple database with 8 tables: Activities Classes Companies Computers Customers Services Users Vendors but whenever I include the TT files for Subsonic, it seems to only create classes for two of my tables, Classes and…
Malfist
  • 31,179
  • 61
  • 182
  • 269
3
votes
5 answers

Any ORM can programmatically change its connection string at runtime?

I created my own CMS for my own use. currently, I already launch 3 websites using my CMS. and will keep adding. since all the websites always use the same version of my CMS, I just need to create one administration site to rule them all. I use…
Anwar Chandra
  • 8,538
  • 9
  • 45
  • 61
3
votes
1 answer

Subsonic 3.0 ActiveRecord with dates

I'm having a little trouble with a query. In my database datetimes are stored as YYYY-MM-dd HH:mm:ss I have the following LINQ query: var visitors = Visitor.All().Where(x=>x.Date_Moderated < dateTime).OrderByDescending(x =>…
Rob Stevenson-Leggett
  • 35,279
  • 21
  • 87
  • 141
3
votes
2 answers

SubSonic not recognizing SQLite foreign keys

I'm using SubSonic 3.0.0.3 and I can't seem to get the ActiveRecord .tt files to recognize and generate code for the foreign keys and relationships in my SQLite database. I think it generates everything else just fine, but after looking at other…
Sodium Hydroxide
  • 147
  • 1
  • 7
3
votes
3 answers

Which DAL approach to take?

ActiveRecord is too limiting normally. However, i'm in a difficult situation in terms of the views held by each member of the team in regards to using ORM's. We currently use a very basic ActiveRecord with regret I say is written mostly by hand with…
user203538
  • 295
  • 5
  • 15
3
votes
0 answers

is there any way to stream binary content with javascript

I am hoping to make an example using the developer build of chrome and being able to use subsonic to stream a binary audio file. So far I have not had any luck though. Granted my next option will be try to load in the audio files into windowStorage…
Josh Knutson
  • 325
  • 1
  • 5
  • 11
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
3 answers

add connection string without using app.config

i created a data access layer dll using subsonic. however it uses the connectionstring from the app.config. i am using it in ninjatrader and dont want to mess around with the ninjatrader app.config for the connecitonstring. how do i avoid this…
junkone
  • 1,427
  • 1
  • 20
  • 45
3
votes
1 answer

how to force Jetty to recompile jsp servlet

I'm running subsonic-5.2.1 media server on ubuntu 14.04.2 server which utilizes Jetty (not sure the version). I added a custom jsp file to the project called jtest.jsp and then modified the web.xml file so it would run as as servlet and it looks…
Jpsh
  • 1,697
  • 12
  • 17
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 Access To App.Config Connection Strings From Referenced DLL in Powershell Script

I've got a DLL that contains Subsonic-generated and augmented code to access a data model. Actually, it is a merged DLL of that original assembly, Subsonic itself and a few other referenced DLL's into a single assembly, called…
J Wynia
  • 10,464
  • 4
  • 40
  • 38
3
votes
0 answers

Subsonic and .Net 4.0

Possible Duplicate: Is Subsonic compatible with .Net 4.0 Does Subsonic support .Net 4.0?
LiamB
  • 18,243
  • 19
  • 75
  • 116
3
votes
4 answers

Subsonic: Comparing two columns instead of an input parameter

s it possible to do the following in subsonic. SELECT * FROM TABLE1 WHERE Column1 > Column2 or Column1 < Colum3 All examples that I've seen assume you now a value to pass to the where clause. I'm trying to do this without creating a view. Thanks
Dwight T
  • 1,457
  • 2
  • 11
  • 20
1 2 3
…
79 80