subsonic

Subsonic Vs NHibernate

What is the concensus on when to use one of these tools adversed to the other? I find Subsonic very useful in terms of getting things done quickly, but on large projects it tends not to scale, and its ties your domain model to your database model. That is where Nhibernate comes in as it gives you lightweight POCOs that are unrelated to y...

Open Source Licensing Options for ASP.NET MVC Application?

I'm working on a personal project in ASP.NET MVC that I plan on making open source. In the past, I've open-sourced quite a few PHP scripts and UNIX-based stuff. For those, I typically went with a BSD/Apache style license, unless I was including a library that prevented it. On the Linux/PHP side of things, that usually meant something tha...

SqlServer Express slow performance

Yesterday, I did a stress test for a .NET web application. I did this for 2 reasons, I wanted to see what performance was like under real world conditions and also to make sure we hadn't missed any problems during testing. We had 30 concurrent users in the application using it as they would during the normal course of their jobs. Most us...

How Do I Load an Assembly and All of its Dependencies at Runtime in C# for Reflection?

I'm writing a utility for myself, partly as an exercise in learning C# Reflection and partly because I actually want the resulting tool for my own use. What I'm after is basically pointing the application at an assembly and choosing a given class from which to select properties that should be included in an exported HTML form as fields....

Are there any tips/tricks about using Subsonic with Asp.Net MVC Framework?

Is there anyone using Subsonic with asp.net mvc framework? If so, can you tell us something about your experience. Are there tips and tricks that can be shared? ...

Using Subsonic for potentially heavily accessed ASPNET MVC Application

I am about to start a project for a potentially heavily accessed ASPNET MVC application and I was thinking to use Subsonic for my DAL. I have some concern about the ability of Subsonic to handle thousands of concurrent requests. Can anyone give me some examples of popular web sites using Subsonic? Also if you have any suggestion regardi...

Subsonic and sp_help_job

Is it possible for subsonic to access dbo.sp_help_job? ...

SubSonic SubSonic.SqlQuery & Dates

Does SubSonic.SqlQuery have a between/and for date ranges? If not, what would be the best way to get a range. ...

Quick/Easy generation of CRUD pages & Data Access Layer in CMS

I have a database that I would like class files generated from, and also a .aspx page generated which contains a listview to interface with the classfile for create/read/update/delete. I have started to use Subsonic but am not sure how flexible the scaffold control is. Also, LINQ seems like an option, but it would be nice if that was g...

For those of you using SubSonic, what kind of performance are you seeing in large applications?

I've used SubSonic in a few POC projects, but nothing large. It's so easy to use, and it's possible to abstract away the fact that it uses the active record pattern (can move it toward a more domain driven approach). Has anyone on here used SubSonic on larger applications, and what kind of performance did you witness? Was your experienc...

SubSonic and Stored Procedures

When using SubSonic, do you return the data as a dataset or do you put that in a strongly typed custom collection or a generic object? I ran through the subsonic project and for the four stored procs I have in my DB, it gave me a Sps.cs with 4 methods which return a StoredProcedure object. If you used a MVC, do you usually use the Stor...

Generic contraints on derived classes

I have class A: public class ClassA<T> Class B derives from A: public class ClassB : ClassA<ClassB> Class C derives from class B: public class ClassC : ClassB Now I have a generic method with constraints public static T Method<T>() where T : ClassA<T> OK, now I want to call: ClassC c = Method<ClassC>(); but I get the compi...

Subsonic: Comparing two columns instead of an input parameter

s it possible to do the following in subsonic. SELECT * FROM TABLE1 WHERE Column1 > Column2 or Column1 < Colum3 All examples that I've seen assume you now a value to pass to the where clause. I'm trying to do this without creating a view. Thanks ...

What would you choose for your data layer today, Linq or Subsonic?

We are ready to start a brand new project at work, no legacy code. We did use Subsonic in the past and we pretty happy with it. But that was before Linq. Has anyone had to face this same issue (Linq x Subsonic)? What was your decision? What were the reasons? Any insight appreciated. ...

data access layer - subsonic, C# 2.0

digging around subsonic, i came across this link text good article but have some ?'s now i want the option to return either a IList or Dataset, would I create an abstarct factory for this, if so can I have one generic method which would take in either IList or Dataset as a ref parameter and populate the passed in object? is it a good...

Stored procedures or inline queries?

First of all there is partial question regarding this, but it is not exactly what I'm asking, so, bear with me and go for it. My question is, after looking at what SubSonic does and the excellent videos from Rob Connery I need to ask: Shall we use a tool like this and do Inline queries or shall we do the queries using a call to the stor...

Subsonic\ORM on Windows CE\Mobile

Has anyone managed to get subsonic or a variant working on Windows Mobile? We cant get it to work as it has a dependency on System.Configuration. Any suggestions on an alternate ORMs that would work on a windows mobile device? ...

SubSonic build errors

I'm trying to use SubSonic for a new project with an existing database but when I try to build the project after generating the SubSonic files I'm getting these same two exceptions on different classes: Partial declarations of 'MyData.UserCollection' must not specify different base classes Type 'MyData.UserCollection' already defines a...

Subsonic Join issue

For those of you who are decent with subsonic! TblNewsCollection col = new Select().From(Tables.TblNews) .InnerJoin(Tables.TblContent) .Paged(currentPage, pageSize) .OrderDesc(TblContent.Columns.PubDate) .ExecuteAsCollection<TblNewsCollection>(); The a...

jQuery Autocomplete and ASP.NET

I searched all over this site and the web for a good and simple example of autocomplete using jQuery and ASP.NET. I wanted to expose the data used by autocomplete with a webservice (and will probably do that next). In the meantime, I got this working, but it seems a little hacky... In my page I have a text box: <input id="txtSearch" ty...