Questions tagged [subsonic2.2]
82 questions
0
votes
1 answer
How hide FriendRequest from other users
I'm developing a social networking site where i'm facing problem when sending
Friend Request from one user to another....The problem is that FriendRequest shows `` to every user not only to whom it send
so i want to show that request to whom it…
Kumar
- 41
- 1
- 11
0
votes
1 answer
Can't find the SubSonicService section of the application config file
When i try to open my MainForm in Visual Studio in the designer, this error pops up instead of the designer of the Visual Studio.
Can't find the SubSonicService section of the application config file
at…
Ben
- 1
- 1
0
votes
1 answer
Subsonic 2 Order By sorting not working
I am trying to sort (ORDER BY ) a subsonic DAL collection
New templateController.FetchAll().OrderByDesc("Name")
But it is not sorting. Am I missing something?
Saif Khan
- 18,402
- 29
- 102
- 147
0
votes
1 answer
Subsonic and SQL Server 2014 Web Edition
We have just upgraded our database from SQL Server Express to SQL Server 2014 Web Edition.
We are also, and don't ask me why, using Subsonic as our database provider.
As soon as we pointed our code to the new SQL 2014 edition we got errors.
It seems…
griegs
- 22,624
- 33
- 128
- 205
0
votes
1 answer
Subsonic Query Select And (OR)
i'm Using subsonic 2.0 and i need to execute the below query
Select * from User where User ID = 1 and (Status = 2 Or Status = 3)
Your help will be highly appreciated.
Allam
- 9
- 1
- 4
0
votes
1 answer
Make SubSonic use existing instead of new data provider
I am adding SubSonic to a legacy application. This application already defines a ConnectionString. Is there a way I can use this connectionstring instead of creating a new Data Provider entry?
I know that one solution is programmatically setting…
paolodm
- 3
- 2
0
votes
1 answer
IndexOutOfRangeException when calling SqlQuery.ExecuteAsCollection() but not in the Command & Watch Windows
I have a very strage problem with the SqlQuery.ExecuteAsCollection() method and I am not sure whether this is related to SubSonic, my database or .NET.
When the following line gets executed:
FlowerCollection myCollection =…
t3chb0t
- 16,340
- 13
- 78
- 118
0
votes
1 answer
Exception with Subsonic 2.2, SQLite and Migrations
I'm playing with Migrations and created a simple migration like
public class Migration001 : Migration
{
public override void Up()
{
TableSchema.Table testTable = CreateTableWithKey("TestTable");
}
…
0
votes
1 answer
subsonic Invalid cast from System.Int32 to System.Byte[]
Subsonic 2.2 is throwing the error
subsonic Invalid cast from System.Int32 to System.Byte[]
When I do the following
If template.Content Is Nothing Then
MsgBox("Blank Document")
Else
MsgBox("Document…
Saif Khan
- 18,402
- 29
- 102
- 147
0
votes
2 answers
Subsonic 2.2 not updating sql changes in the V class
New to SubSonic, inherited it with a project that uses SubSonic 2.2.1
I have tried to added a column to one of my tables and run the tool to update the classes, The table name is Feedback and Feedback.cs added the new property but VFeedback.cs…
saarpa
- 47
- 7
0
votes
2 answers
How can i tell SubSonic 2 to use a different .config file?
I'm using SubSonic 2 from within a project and I'd like to specify a different .config file from the default App.config. How can I tell SubSonic to use a specific config file?
Rory
- 40,559
- 52
- 175
- 261
0
votes
1 answer
Retrieve AutoIncrement key value when the column is NOT the first one in the table
I've got a question regarding how to retrieve the auto-increment or identity value for a column in SQL Server 2005, when said column is not the first declared column in a table.
I can get the generated value for a table just by issuing the following…
Fervelas
- 73
- 6
0
votes
3 answers
InnerJoin with Where Expression trouble
I am using Subsonic 2.1 and I need to do an innerjoin and use a where expression and I keep getting the error:
Must declare the scalar variable "@Partner"
Here is my code:
Dim ds As DataSet = UWP.Model.DB.Select("TOP 30 FirstName, LastName,…
Slee
- 27,498
- 52
- 145
- 243
0
votes
2 answers
SubSonic: Case sensitive test?
I'm curious if there's a way to do a case sensitive string comparison in SubSonic? I have the following statement:
return new Select()
.From()
.Where("email").IsEqualTo(email)
…
StephenPAdams
- 2,797
- 2
- 30
- 49
0
votes
2 answers
SubSonic 2.2 Class Generation
I am using SubSonic on a project with many tables which were created by a sourcecode generator. I noticed Some classes created by SubSonic were generated without code and have the folowing message
The class...was not generated because ... does not…
Saif Khan
- 18,402
- 29
- 102
- 147