Stack Overflow
Stack Overflow

Questions tagged [subsonic2.2]

82 questions
0
votes
1 answer

SubSonic Save() changes not working

I am trying to save changes to a record, however I am getting the error Violation of PRIMARY KEY constraint 'PK_TStoreAssignment'. Cannot insert duplicate key in object 'TAssignment'. The statement has been terminated. Here is the subsonic…
Saif Khan
  • 18,402
  • 29
  • 102
  • 147
0
votes
1 answer

Listbox.DisplayMember won't display value from calculated property

I'm using SubSonic 2.2 for my DAL and extended one of my classes with a calculated property that returns a string containing another property with indenting based on the level of the outline at which the item occurs. The code for the property is…
Mike Devenney
  • 1,758
  • 1
  • 23
  • 42
0
votes
1 answer

Subsonic - query with optional parameters

Using C# 3.5 through VS 2008 and subsonic 2.2. Anyone know if it's possible to create a subsonic query that essentially has an 'IF' in the middle of it, depending on whether a passed parameter was, for example, greater than zero. For example, a…
scaryjones
  • 119
  • 8
0
votes
1 answer

c# subsonic 2.2 : many-to-many relationship and pagination problem

i have 3 tables (Categories, Articles and ArticleCategories). The ArticleCategories has a combined PK and concists of: ArticleID (PK, FK, int) CategoryID (PK, FK, int) Now when I'm using the subsonic paging methods I'm running into some very…
Mark
  • 49
  • 3
0
votes
2 answers

Subsonic 2.2 varchar2 maxlength problem

I have a problem with saving 4000 characters to varchar2(4000) oracle 10g column it lets me save just 2000 characters and when I try to save exceeding 2000 character I get tihs error Can't save: GENERAL_ NOTE exceeds the maximum length of 4000…
Adem
  • 3
  • 2
0
votes
1 answer

Saving a null date to SQL2008 via. SubSonic 2.x

Ok, So I am trying to set a datetime column to null via SubSonic 2.x DateTime? dt = new DateTime(); dt= null; Datum pd = (new DatumCollection() .Where(Datum.Columns.Data, cp[0].Data) .Load())[0]; …
Jonathan Michaels
  • 68
  • 9
0
votes
1 answer

SubSonic 2.0 Delete() is 'method' bus is used like a 'type'

I've recently had to adopt a SubSonic based solution, and i'm getting an error for Delete Insert and Update Delete is a 'method' but is used like a 'type' public static Delete Delete() { return Repository.Delete(); …
Hellola
  • 113
  • 1
  • 3
0
votes
2 answers

using like condition in Subsonic 2.2

I need some help in using "like" condition in Subsonic 2.2 Following is my query DAL.DB.Select() .From("tblName") .Where("NewFirstName") .Like(strFirstName) .Or("PrevFirstName") .Like(strFirstName) .ExecuteDataSet(); the…
eagle1150
  • 1
0
votes
1 answer

SQL connection is too slow

We have a business web application in ASP.NET + SQL Server 2008. In the beginning, SQL Server and IIS were on the same machine. Now we bought another machine. Current configuration is IIS machine plus SQL Server machine, and they are connected by a…
user453665
  • 1
  • 1
0
votes
1 answer

Trouble running mbUnit 2 tests in SubSonic 2.1

I'm still using Subsonic 2 for a few of my projects. Wanting to hack it a little. I've got the latest pull from the GIT repo, I'm using VS2008 Pro. Looking in the SubSonic.Test project, the mbUnit dll referenced has a description of…
Ben McIntyre
  • 1,972
  • 17
  • 28
0
votes
1 answer

Help with SubSonic 2.2 binding

I have the following tables TUser (user_id,firstname,lastname) PK user_id TGroup (group_id,name) PK group_id TUsersGroups (user_id,group_id) PK (user_id,group_id) FK (user_id) FK (group_id) I need to bind to a DataGrid the TUsers, showing…
Saif Khan
  • 18,402
  • 29
  • 102
  • 147
0
votes
2 answers

SUBSONIC using subcommander via VS2008 causing following errors - help please

Ive been using subcommander to generate my dal. Im using vb.net and sqlexpress and .net 3.5 My webconfig looks like this
Dan
  • 1
0
votes
3 answers

Subsonic - Where do i include my busines logic or custom validation

Im using subsonic 2.2 I tried asking this question another way but didnt get the answer i was looking for. Basically i ususally include validation at page level or in my code behind for my user controls or aspx pages. However i haev seen some small…
Dan
  • 11
  • 1
0
votes
1 answer

Why am I getting this error after updating the VS Project

I have been tasked with updating an ASP.net Visual Studio 2005 project to Visual Studio 2013. The original project used a product called Subsonic version 2.2 and several Telerik controls. I have been able to solve the Telerik DLL issues but have…
Perry
  • 1,277
  • 2
  • 17
  • 39
0
votes
1 answer

SubSonic generation of tables with columns as ColumnX

This doesn't make much sense to me. We had this happen twice recently when generating SubSonic objects for a database table or view columns got renamed to ColumnX. The first time it made sense because the column name is Value, a C# keyword. But…
Evan Lynch
  • 103
  • 1
1 2 3
4
5 6