When I'm using VB.NET to use subsonic, It seems to have problem marking records as Old and Clean. Whenever I query using ExecuteSingle or ExecuteTypedList, i need to manually MarkClean and MarkOld, else whenever I save it will save as a new record. Am I the only one facing this problem ? I'm using SubSonic 2.2 btw. ...
Hi, I would like that someone explain me how is the easy and simple way to change the HeaderText of the GridView control using the SubSonic Scaffolding ? Also, I would like to rename the text of every label control in the Add and Edit Form that is generated with the SubSonic Scaffold. I got my Scaffolding Form in English idiom but I wan...
I am using Subsonic 3 (T4 template) to generate the models for my mvc app. However the default template does not allow for nullable columns, so when I go to save the record it errors out if a nullable datetime column is blank. (See this post...) Question: What is the best practice to handle this? Option 1: Change the template to ch...
Hey guys, I am a little confused as to how to get the T4 templates and use them when you pull down the latest code from SVN for Subsonic 3. Are there any instructions anywhere for this or could someone enlighten me? I looked @ the old alpha release and there was a nice _Generated folder that held all of these files. I'm curious what I...
Hi, This question is about subsonic I am trying to build a select query HAVING joins in it using subsonic. For Example if I want to extract data from 3 tables then how I will be able to do it in Subsonic. Lets say if I have a TSQL given below then How I will be able to translate this into Subsonic? Select la.LoanAppId, ci.FirstName, ...
Could anyone tell me how to do the select function in SubSonic project to query all customer who will have birthday in next two week from today. Table Customer Name Thomas DOB 19/09/1981 Thank you ...
I am using SubSonic in my project. I need to selected rows filtered by some condition. I'm trying to use SqlQuery as follows: SqlQuery q = new Select() .From("TableName") .Where(MyDALObject.Columns.Status) .NotIn(new[] { 1, 8, 9, 22, 23}); IList<MyDALObject> list = ...
I have a very simple web application with 5 tables and one user. I keep getting timeout errors stating the max pool connection has been reached. Every opportunity to use an IDataReader the connection is manually closed. What am I doing wrong? ...
Hi guys, This is an embarrassingly basic n-tier question. I've created a DAL project in VS2008 with subsonic. It's got a widget class, a widgetcollection class, and a widgetcontroller class. I've created my Business logic project (no I can't put it in the same tier) that references it. Using certain business criteria, it selects a co...
In SubSonic, version 2.2, the following (MSSQL-specific) code fails: SqlQuery update = new Update(SomeTable) .SetExpression(SomeTable.SomeDateTimeColumn).IsEqualTo("GETDATE()") .Where(SomeTable.IdColumn).IsEqualTo(id); At this point update.ToString() produces a perfectly legal SQL sentence: UPDATE [dbo].[SomeTable] SET...
I am trying to bind a SubSonic 2.1 generated DAL object to a WinForm (VB.NET VS2005). In order to work around the lack of IPropertyNotifyChanged implementation, in my binding method I am doing a controlname.DataBindings.Clear() before a controlname.DataBindings.Add() for each control I want to bind. Textboxes work fine with code like t...
Using SubSonic 2.1 in a web app in a hosted enironment (e.g. I don't have control over what happens on the server). Does the SubSonic dll have to be registered in the server GAC, or can it simply be in the website bin folder? Thanks. ...
I have been using subsonic with MS SQL 2005 for about a year now. For those of you who have moved to SQL 2008, is subsonic compatiable with that? Have you had too many issues with SubSonic with SQL 2008? Just trying to get a feel if I should upgrade to SQL 2008 at this time or not. Thanks ...
I have a datagrid where I am using the custom paging option (ref: http://subsonicproject.com/querying/webcast-using-paging/) in the Subsonic framework. I also have a dropdown that filters the data by State. This is added to the query through the addwhere call. the data is ordered by state ASC and then city ASC. the data seems to be...
Hello! I updated my ASP.NET/C# project to version 2.2 of Subsonic, before it was 2.0.3. After this update all Update commands don't work! There is no exception, nothing, but the database is not updated! Someone know how to resolve that? I need to modify something in project or to resolve I have to modify all update commands? Example, ...
I'm interested in using Subsonic 3.0 for developing a new ASP.Net MVC application that will be going into production use soon. Would this be a feasible option? Does anyone have an idea when 3.0 is going to be released? Is anyone else using it on a production MVC application? ...
Hi, I am moving 1 project, just the data tier, the project is using MVC 1.0 and acess mdb :S Now I am moving to SubSonic + Sql server and all is fine, except when I try to implement to my class IDataErrorInfo for validation messages, I get always 2 times every error message I have a table class generated by subsonic:MyTable, then I ext...
Ok, Today I am trying to learn Subsonic. Pretty cool stuff. I am trying to build some search functionality into my website but am struggling about how I might achieve this in Subsonic. I have one search field that could contain multiple keywords. I want to return results that match all of the keywords. The target on the search is a...
I am very confused with the use subsonic or ado.net entity framework Which one I should pefer? I creating a web site using asp.net mvc and all i need is greater performance and I also want to save time using ORM. So Which orm i should use? ...
I love NHibernate's ability to have one table to store multiple types based on a discriminator. When I fetch an RegularItem, it will come back as the sub type of the discriminator is correct. Does SubSonic have this ability? ...