Stack Overflow
Stack Overflow

Questions tagged [subsonic2.2]

82 questions
1
vote
1 answer

Unable to insert a record (SqlServer) using Subsonic 2.2

I use SqlServer 2008. Here is the DB schema: (Please note that this only to test SubSonic) Create Table Dept ( DeptID int not null Identity(1,1) primary key, DeptName varchar(20), Location varchar(30) ) GO Create Table tUsers ( UserID int…
sanar
  • 437
  • 9
  • 22
1
vote
1 answer

Trouble getting transaction working with SubSonic

I'm having a little trouble getting a multi delete transaction working using SubSonic in an ASP.NET/SQL Server 2005. It seems it always makes the change(s) in the database even without a call the complete method on the transactionscope object? I've…
Knoxy
  • 31
  • 3
1
vote
1 answer

SubSonic: MySql, Float, and Single->Decimal issues

Have 2 MySQL databases. One is the main database, the other is used for geolocation data. Now, for SubSonic to play nice with the generated files via Subcommander, I made it easy and just created a view that maps to the geolocation data in the other…
StephenPAdams
  • 2,797
  • 2
  • 30
  • 49
1
vote
1 answer

Fixing the SubSonic 2.2 Calendar, How do I get RegisterClientScriptInclude calls to render when control is not visible?

I really liked the SubSonic 2.2 calendar control. It is a .Net implementation of the old Dynarch calendar found here. So I did what any developer would do and I swiped all the code for the calendar and put it in it's own library. Unfortunately the…
Biff MaGriff
  • 8,102
  • 9
  • 61
  • 98
1
vote
1 answer

Is there a way to use T4 templates with Subsonic 2.2

I understand Subsonic 3.0 is the latest and greatest, and I understand Subsonic 3.0 has T4 templates. But Subsonic 3.0 is not backwards compatible with Subsonic 2.2, meaning, my project with hundreds of code files written in the subsonic 2.2 query…
bladefist
  • 1,084
  • 3
  • 15
  • 25
1
vote
1 answer

SubSonic - How can i create my business logic layer

Im new to subsonic and generally this was of programming, i usually develop from a rad perspective so using the visual studio dataset designer, but i wanted to start looking at developing n teir approach. Ive never used a business logic layer,…
Dan
  • 11
  • 1
1
vote
3 answers

How does one do an Oracle top-n (paged) query in SubSonic 2.2?

(Disclaimer: I changed/obfuscated some of the variable/table/column names here for security reasons. Please forgive me if something looks a little off.) I am building a front-end to an Oracle 10g database, and I'm trying to get paged data. Aside…
Joel Wietelmann
  • 1,447
  • 1
  • 9
  • 16
1
vote
1 answer

Subsonic Strips trailing s from Table Name in Object names

I have a table called Group_Focus and when we generated our code with Subsonic 2.2 it's calling the object GroupFocu while the files are named GroupFocu.cs and GroupFocuController.cs. Is there anyway to get it to not strip off the s when it builds…
Scott
  • 189
  • 2
  • 10
1
vote
1 answer

SubSonic 2.2 support for Lazy Loading

Does SubSonic 2.2 support lazy loading? Can I lazy load a property of an object? If yes, where can I find info on this?
Saif Khan
  • 18,402
  • 29
  • 102
  • 147
1
vote
3 answers

Locking problems with sqlite and SubSonic when using transactions on a single thread

I'm getting locking exceptions when trying to use transactions with SubSonic and SQLite. I'm using this from a single thread and there are no other processes accessing my db, so I really didn't expect any such problems. If I write code like this…
Rory
  • 40,559
  • 52
  • 175
  • 261
1
vote
3 answers

Inserting primary key values using SubSonic and sqlite - problem because SubSonic thinks columns are either AutoIncrement or not

I'm using SubSonic 2.2 and sqlite and have encountered a problem when dealing with tables with an INTEGER PRIMARY KEY column that isn't AUTOINCREMENT. According to the faq: If you declare a column of a table to be INTEGER PRIMARY KEY, then…
Rory
  • 40,559
  • 52
  • 175
  • 261
1
vote
1 answer

SubSonic2.2 Add() not working

I have 2 tables in my DB, Customers, Contacts. CusID is a Foreign Key in Contacts table. I tried the following Dim contact as New Contact(Guid.NewGuid()) contact.FirstName = "Mary" contact.LastName =…
Saif Khan
  • 18,402
  • 29
  • 102
  • 147
1
vote
1 answer

SubSonic: MaxLength of TableColumn (exceeding)

So, we're using SubSonic as our DAL/ORM for one of our projects. Everything has been running smoothly (the database already existed, so we used SubSonic on top of it), however, on occasion we'll run into an exception that says something like the…
StephenPAdams
  • 2,797
  • 2
  • 30
  • 49
1
vote
1 answer

SubSonic-based app that connects to multiple databases

I currently developed an app that connects to SQL Server 2005 database, so my DAL objects where generated using information from that DB. It will also be possible to connect to an Oracle and MySQL db, all with the same table structures (aside from…
Fervelas
  • 73
  • 6
1
vote
3 answers

Update a primary key value using SubSonic 2.2

I'm currently developing an app using SubSonic 2.2 and I'm having problems updating one of the columns of a composite PK on a table. My code is roughly this: foreach (pageItem page in pages) { page.IdFile = newIdFile; page.PageNumber =…
Fervelas
  • 73
  • 6
1
2
3 4 5 6