Stack Overflow
Stack Overflow

Questions tagged [subsonic2.2]

82 questions
9
votes
2 answers

System.Security.VerificationException: Operation could destabilize the runtime. (Subsonic 2.2)

I recently tried to upgrade a .net 2.0 project which had its DAL generated by SubSonic 2.2 to .NET 4.0 under Visual Studio 2010. The projects converted without error but now I am getting a rather vile error message when I try to launch…
Christopher Klein
  • 2,773
  • 4
  • 39
  • 61
7
votes
1 answer

Accessing stored procedures with robconery / massive?

Another great article by Rob on the Massive ORM. What I haven't been able to find is references on how to access stored procedures. SubSonic had some issues with the overhead of using ActiveRecords, so I preferred to do data access with stored…
ElHaix
  • 12,846
  • 27
  • 115
  • 203
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
3 answers

SubSonic equivalent of an SQL update

I'm wondering if the following SQL update query is possible using the equivalent SubSonic commands: UPDATE MYTABLE SET MYFIELD = MYFIELD + 3 WHERE ANOTHERFIELD = ANOTHERVALUE I couldn't find a suitable way to make a reference to the same field with…
Fervelas
  • 73
  • 6
3
votes
3 answers

Getting a log of the SQL SubSonic is using

Linq2SQL has the great Log property to see what the actual SQL statements that it is generating. Does SubSonic 2.2 have something similar to this?
Robert MacLean
  • 38,975
  • 25
  • 98
  • 152
3
votes
2 answers

SubSonic2.2 SharedDbConnectionScope and TransactionScope Transaction Confusion

ARGH!!! There seems to be a little confusion surrounding the SharedDbConnectionScope and TransactionScope objects to enable wrapping your SubSonic queries within a transaction. The docs suggest specifying the using SharedDbConnectionScope wrapped…
BlackMael
  • 3,198
  • 5
  • 25
  • 42
2
votes
3 answers

Telerik OpenAccess vs. SubSonic in simple speed test (not a "which is better")

I have been using SubSonic 2 for ~5 years now and have loved it. However, for the past six months I've been toying with the idea of moving either to SubSonic 3 or to a similar ORM tool. Since my company uses plenty of Telerik's tools, I thought I'd…
AJ Tatum
  • 653
  • 2
  • 15
  • 35
2
votes
1 answer

subsonic 2.2 : how to order a collection by FK Title?

I'm stuck with the following scenario, i have 2 tables called (Products and Categories). the field CategoryID in Products table has a FK to the Categories table. Now for my data table in my CMS I'm looking for a way to sort the products based on the…
Mark
  • 49
  • 3
2
votes
2 answers

SubSonic How to Execute a SQL Statement?

My site is using Subsonic 2.2 on my site. I have 1 weird situation where I need to run some ad-hoc SQL statements. public IList GetDistincList(string TableName, string FieldName) { string sqlToRun = string.Format("SELECT DISTINCT {0}…
aron
  • 2,856
  • 11
  • 49
  • 79
2
votes
2 answers

Change connection on the fly

I have a SQL server with 50 databases. Each one has the exact same schema. I used the awesome Subsonic 2.2 create the DAL based on one of them. I need to loop though a list of database names and connect to each one and perform an update one at a…
aron
  • 2,856
  • 11
  • 49
  • 79
2
votes
2 answers

Why does SubSonic 2.0 use System.Data.SQLite version 1.0.60.0?

Anyone know why Subsonic 2.2 uses System.Data.SQLite version 1.0.60.0 instead of the latest version 1.0.65.0? ie is it just because that's when it was released or is there anything in the newer version that doesn't work with SubSonic? What does…
Rory
  • 40,559
  • 52
  • 175
  • 261
2
votes
0 answers

Change DB server at runtime

I have a large vb.net project running on subsonic 2.2. I am looking for a way to change the connection string for subsonic at run-time, based on a separate configuration file. (basically connect with the sever information in my own configuration…
user1088450
  • 45
  • 1
  • 2
  • 6
2
votes
0 answers

Subsonic - Get All Columns From Joined Tables

How do I display columns from both tables with an "InnerJoin" from SubSonic? var myQuery = New SubSonic.Select().From(TableObject1) InnerJoin(TableObject2.ID,TableObject1.ID)
Saif Khan
  • 18,402
  • 29
  • 102
  • 147
1
vote
1 answer

SubSonic 2.2 encrypted connection string

I want to use SubSonic on a website. I put SubSonic.DLL in the asp.net Bin folder and I've generated some classes from SubSonic Commander and put them in a DLL that is also in Bin folder. The problem is the site I'm working on encrypts their…
user204588
  • 1,613
  • 4
  • 31
  • 50
1
vote
0 answers

SubSonic 2.2 making template for DBF files

I have SubSonic 2.2 and I have some DBF files that I need to use for a project. I'm wondering if it's possible to edit the .aspx templates to work with DBF? Has anyone tried this and have a working template?
user204588
  • 1,613
  • 4
  • 31
  • 50
1
2 3 4 5 6