I'm building a SqlQuery to support an ad-hoc query screen. I want something like this: SqlQuery q = new Select().From<VwInstitutes>(); if (!string.IsNullOrEmpty(username)) { q.Where(VwInstitutes.Columns.AssignedUser).IsEqualTo(username); } if (!string.IsNullOrEmpty(stage)) { q.Where(VwInstitutes.Columns.Stage).IsEqualTo(stage...
Howdy! I'm still not getting my SP's generated in SubSonic 2.2 against an Oracle 10g DB. The Tables and Views generate up perfectly. Also this product is multiplatform so we're gen'ing up SubSonic libraries against SQL 2K5 and that works great for Tables/Views and SP's. I recall on the old forums there was a bug in earlier versions o...
Using Subsonic 2.2 latest SVN. SQL Server 2008 table has a column called Accreditation The Subsonic generated property for this column is named AccreditationX Can anybody tell me why ? ...
I wanted to use SubSonic as it said it would be easy to use and a time saver. After 3 hours trying to get the connection string for MySQL right I'm about to give up on it. Building configuration from C:\Documents and Settings\user\My Documents\Visual Studio 2 008\Projects\ConfigurationItems\ConfigurationItemsMVC\Web.config Adding conn...
This is not a question, cause I already answerd it. But it may be helpful to others, too. Here's what happens: Create a WinForm with a Datagridview and bind a Subsonic ...Collection with more then 500 objects loaded to it Add some columns to the datagrid and make at least one autosizemode = fill Add logic to delete all selected column...
I'm writing a desktop app which needs a simple persistence layer - I found out about SubSonic and it's capability to work with SQLite. However I need to keep the database file in user's AppData folder and don't know how to put such value into app.config - I don't want to use absolute paths. Can app.config somehow access enviroment varia...
Has anyone been able to use a SubSonic generated collection as a "business object datasource" with Microsoft report (rdlc)? I have generated the SubSonic class code but for some reason the report datasource window is not seeing the class as a potential object collection datasource. Is there something I need to do for this to work? Tha...
I was asked by a fellow developer if I could code in some enums into SubSonic as he was needing them and he pointed out a post on the old SubSonic forums. If anyone is interested in this functionality then an issue has been opened at http://code.google.com/p/subsonicproject/issues/detail?id=81 if you'd like to place some comments and fe...
I want to use an Object Relational Mapper (ORM) tool for my ASP.NET application. I have three options: NHibernate, LINQ to SQL, and Subsonic. Which one is fastest? ...
Where can I find a link to download SubSonic SubStage? ...
Could someone that knows SubSonic add it to this comparison page / or post the answers here on SO? http://c2.com/cgi/wiki?ObjectRelationalToolComparisonDotNet Even if not all 54, any that you know off the top of your head would be great. ...
I have a good sized hobby project, around 66K LOC, over at http://www.wheelmud.net Recently, a team member got the bulk of the code MS StyleCop compliant. The only thing left is our data layer. As you can imagine, this gets regenerated fairly often, as we are still in the early stages of development. I tried modifying the aspx template...
I am new to SubSonic and Linq Stuff and I am trying a figure out the shortest and optimal way of retrieving a single record. What other way is quicker and requires less code to write than this to get a single record? User user2 = DB.Select().From(User.Schema) .Where(User.PasswordColumn).IsEqualTo(password) .And(User.SINumberColumn).IsE...
Hi guys, I need to query a table using FreeTextTable (because I need ranking), with SubSonic. AFAIK, Subsonic doesn't support FullText, so I ended up creating a simple UDF function (Table Function) which takes 2 params (keywords to search and max number of results). Now, how can I inner join the main table with this FreeTextTable? Inline...
I'm getting this error while trying to run my login page. Here's my stack trace: [ArgumentException: No provider is defined with the name evanmoor_sales Parameter name: providerName] SubSonic.DataService.GetInstance(String providerName) in C:\svn\subsonicproject\trunk\SubSonic\DataProviders\DataService.cs:163 Emcom.Sales.SalesUs...
If I use SubSonic to create DAL for my web project do I need to worry about preventing SQL Injection Attacks? ...
Hi, I'm developing a new admin website to update several tables. There is no complicated logic involved (at the moment). The website will be built using VS 2008 C# (3.5 framework) and will have a SQL Server 2008 db. We've decided to look into using SubSonic and I've already set up the the basic scaffolds to input test data. Does a...
I am using an objectdatasource with a gridview to get data from my orm class, but I cannot get it to order by properly. I am using the code below but it does not come up in descending order like I have specified below. What am I missing? Using subsonic 2.1 <DataObjectMethod(DataObjectMethodType.Select, True)> Public Function FetchByP...
I have seen the video of paging using subsonic http://subsonicproject.com/querying/webcast-using-paging/ I am calling a stroed procedure to reterive the data. Is it possible for me to use the Paging? Please give me few samples. Thanks ...
The security policy at our client's production environment requires that we use separate connection to execute writes and read to and from database. We have decided to use SubSonic to generate our DAL. So I am interested in knowing if it is possible and if yes how? ...