1

Does SubSonic support SQL Server 2008 R2?

Regards Sundar

Sundar
  • 11
  • 1

3 Answers3

1

I can't answer for SubSonic 3.x, but can tell you that 2.x will support both SQL Server 2008 and 2008 R2 providing that your database doesn't use any of the new 2008 data types (date, time, etc)

kevinw
  • 2,088
  • 1
  • 14
  • 15
1

Yes. I'm using SubSonic 3.0 with ActiveRecord T4 templates right now, and they are awesome.

Earlz
  • 62,085
  • 98
  • 303
  • 499
  • @Aristos really? I've not noticed any speed problems and most of the SQL queries it generates are sane, if not better than what I'd write. But anyway, you didn't specify what version of SubSonic, so I'm saying SubSonic 3 works. The other answers say SubSonic 2 works. So you got your answer :P – Earlz Jun 24 '11 at 21:40
  • Yes you have right +1, it did not specify the version. Now subsonic 3 is the slow. I have s2 on my programs, and I discover the different when I start change it with the s3. See also http://stackoverflow.com/questions/2363735/benchmark-linq2sql-subsonic2-subsonic3-any-other-ideas-to-make-them-faster – Aristos Jun 24 '11 at 22:09
  • @Aristos I stand corrected. I thought you were just assuming, but it's true. Doing a [SingleOrDefault](https://github.com/subsonic/SubSonic-3.0/issues/258) is 20x slower. And to overcome issues with it not supporting nested queries(or joins), you must basically do a [complete table fetch](http://stackoverflow.com/questions/2529468/left-join-in-subsonic-3). With these issues in light I'm now looking for an alternative ORM – Earlz Jun 27 '11 at 22:44
  • Subsonic 2 is very good. With some extra optimization inside the code, I have archive super high speed, and easy development. Subsonic 2 is my tool. Subsonic 3 have the problem that need to compile everything again and again in real time, thats why is so slow. – Aristos Jun 27 '11 at 23:50
0

I'm almost positive that it does. Also see here: SubSonic with MS SQL 2008?

Community
  • 1
  • 1
CodingWithSpike
  • 42,906
  • 18
  • 101
  • 138