Questions tagged [subsonic3]

SubSonic is A Super High-fidelity Batman Utility Belt that works up your data access (using LINQ in 3.0), throws in some much-needed utility functions, and generally speeds along your development cycle.

SubSonic is an open source project designed to act as a data access layer in your application. It was originally conceived by Rob Conery.

SubSonic is A Super High-fidelity Batman Utility Belt that works up your data access (using LINQ in 3.0), throws in some much-needed utility functions, and generally speeds along your development cycle.

Our focus is that you have better things to do with your time than worry about data access. It's a problem - we understand. But we're here to help with the addiction.

The main project website is located at http://subsonicproject.com/.

557 questions
0
votes
2 answers

Subsonic 3 getpaged filter question

I am sure this is a stupid question, but how would I get a pagedlist of filtered items? Here is how I ended up doing it: PagedList company = Company.GetPaged(1, 10); var list = Company.Find(x =>…
chad
  • 5
  • 2
0
votes
3 answers

Subsonic 3: Invalid cast from 'System.Byte' to 'System.Byte[]'

I'm trying to use Subsonic 3.0 but with every query I try it gives me this error: "Invalid cast from 'System.Byte' to 'System.Byte[]'." I've tried using linq and activerecord on several different tables and always having this problem. Just to make…
Yannick Smits
  • 875
  • 9
  • 14
0
votes
1 answer

Subsonic 3 Active Record Testing

Using the new built in testing for Active Record (set "Test" as the connection string) I've hit a problem performing an update. The code I'm testing pulls an existing object out of the database, makes some changes to it, and then saves it. public…
Jon Hilton
0
votes
3 answers

Is there any demo to insert a new record into a table with identity primary key using Subsonic 3?

Is there any demo to insert a new record into a table with identity primary key using Subsonic 3?
Leo
0
votes
1 answer

Subsonic SimpleRepository problem with Category.All

I have a problem with the Create View in the SimpleRepository example in Subsonic 3. I get an error at line (28): <%=Html.DropDownList("CategoryID",new SelectList(Blog.Category.All(), "categoryid", "description")) %> Basically, .All() is not known.…
Coolcoder
  • 4,036
  • 6
  • 28
  • 35
0
votes
2 answers

Problem with RunMigrations in SimpleRepository Example - Subsonic 3

I downloaded today Subsonic 3 and tried out the examples. I am having a problem with the SimpleRepository example and I wondered if anyone else has had this. In the HomeController there is a defintion as follows: public HomeController() { …
Coolcoder
  • 4,036
  • 6
  • 28
  • 35
0
votes
3 answers

Is my IQueryable syntax correct?

The generated SQL does a cross join but as the ID's are matched it acts like an inner join but is there a better performing way to do this by actually using the join keyword in C#? Is there a way where you don't have to specify how the properties…
Jon
  • 38,814
  • 81
  • 233
  • 382
0
votes
1 answer

Create Foreign Key to ASP.Net Roles table

I have a Pages table, I have a PagesRoles table with PageId, RoleID that links to ASP.Net Membership Roles table and the Pages table. I want to somehow return a Page that links to the currently logged in User's Roles. The User may be in more than…
Jon
  • 38,814
  • 81
  • 233
  • 382
0
votes
1 answer

Does Subsonic 3 ActiveRecord Handle Many To Many Relationships?

Does the ActiveRecord template files create classes that handle many to many relationships?
Jon
  • 38,814
  • 81
  • 233
  • 382
-1
votes
2 answers

Some values in LINQ Query Statement aren't saved correctly to class with subsonic 3

I am developing a MVC 3 Application which uses Subsonic 3 for accessing the database. My Problem is, i don't understand why the Enum "GlobalType" is not being written into the property. Everytime i check, the value is 0 instead of "One". The "Name"…
KampfFussel
  • 137
  • 9
-1
votes
2 answers

On subsonic3 How to get the name of a field from a table, and the max length, type etc

How to get the string-name of a field from a table on subsonic 3? On subsonic version 2 I use the TableName.columns.Field Also in subsonic 2 I have the opportunity to get the max length of a string field. How can I do that on subsonic 3 ?
Aristos
  • 66,005
  • 16
  • 114
  • 150
-1
votes
1 answer

Why is SubSonic and ActiveRecord throwing an exception when updating a record?

I have the following table in MS SQL Server 2008 Standard Edition: CREATE TABLE [dbo].[NewTestQueue]( [JobID] [int] IDENTITY(1,1) NOT NULL, [ServerName] [varchar](50) NULL, [DomainID] [int] NOT NULL, [Action] [varchar](50) NULL, …
Kev
  • 118,037
  • 53
  • 300
  • 385
-2
votes
2 answers

Index was outside of bounds of the array

I am getting this Index out of bound error when i am trying to add product with more than 1 quantity into order table. To be more clear, this is not the same case when I am adding a product with quantity 1 or multiple product each with quantity…
ALOK
  • 553
  • 6
  • 17
-2
votes
1 answer

SubSonic 3 and WebApplication Installation

Will SubSonic work in Visual Web Developer 2008 Express Edition, and if it works what is the installation steps.
Kishh
  • 2,005
  • 4
  • 19
  • 16
-3
votes
1 answer

what do I need to work with subsonic?

Possible Duplicate: Give an example of using subsonic 3 Please tell me what do I need to know to work with subsonic? What do I need to read and where ? I ask this because I see no documentation on subsonicproject.com. Please give me a list of to…
1 2 3
37
38