I has encountered conversion from integer to string with MySql+SubSonic3 (it generates wrong SQL query). After I found root of the problem in SubSonic sources and fixed it, everything works fine, but I'm not sure that it won't pull some other stuff. I believe in MySqlFormatter.cs the following code on line 309 sb.Append...
private void BuildGridView2() { GridView1.DataSource = new Select() .From("NewsReleases") .Where("RelMonth").IsEqualTo(this.ddlAward.SelectedValue) .And("RelYear").IsEqualTo(this.ddlYear.SelectedValue) .OrderAsc("RelDate") .ExecuteDataSet(); } The SQL statement above is not working for some reason. Is there a ...
In the following code, if one of the values assigned violates a database constraint, the Save() updates the record with the other good values. However, the database constraint does not appear to bubble up and and be caught by SubSonic. Does SubSonic provide a way to catch constraint violations like this? try { OutboundShipmentControlle...
Hello, I am a front end developer working on a small social network. Currently, we are using SubSonic and it has satisfied all of our needs. Since Microsft has stopped supporting LINQ, I want to know how this will affect the development of SubSonic if at all. Is there any reason to move to ADO.net? ...
Hi, I was wondering if anyone knows a reference on how to configure subsonic 3.0 to use mySQL? ...
To use transaction construct(as follows) in Subsonic, MSDTC needs to be running on Windows machine. Right? using (TransactionScope ts = new TransactionScope()) { using (SharedDbConnectionScope sharedConnectionScope = new SharedDbConnectionScope()) { // update table 1 ...
Hi I am using (evaluating :)) Subsonic ActiveRecord mode for accessing sqLite. Need transaction to work. Regular stuff... Of ocurse! Following snippet explains the desired logic. I couldn't find the right example in docs. using (TransactionScope ts = new TransactionScope()) { using (SharedDbConnectionScope ...
In one SqLite table, I have a BLOB column for saving images (or binary data as a matter of fact). The table is Documents. Strangely, in Subsonic's ActiveRecord's Documents class, the type of that column shows as STRING which doesn't make sense. It should be byte array. Right? What am I missing here? How do I map SqLite BLOB column in S...
I encountered bug in my programm because of SubSonic3 returns records with default connection string in SingleOrDefault(ByVal expression As System.Linq.Expressions.Expression(Of System.Func(Of Company.filter, Boolean)), ByVal connectionString As String, ByVal providerName As String) In Subsonic sources, Database.cs line 323: instanc...
I am playing around with SubSonic 3 ActiveRecord. I have a table called Users and I have the following fields in a MySQL database: CREATE TABLE `users` ( `ID` int(10) NOT NULL auto_increment, `Username` varchar(50) NOT NULL, `FirstName` varchar(50) default NULL, `LastName` varchar(50) default NULL, `EmailAddress` varchar(10...
I have this error when try to implement pagging using sqlite in subsonic. error :near "DECLARE": syntax error ---> SubSonic.SqlQueryException: SQLite error here is my code SqlQuery q = new Select( new SubSonic.TableSchema.TableColumn[] { UserProfile.UseridColumn, UserProfile.UsernameColumn, UserP...
It Subsonic can support Postgres? I dont see or find any Postgres Provider in Subsonic 2.x or 3.x. It too bad it Subsonic not support it. nHibernate support most of the database include MS Access and Postgres. ...
Problems Background (you can skip to the question) I have many ASP.Net websites which are same application. different database but same schema, in the same SQL Server. The administration site is already implemented in each virtual directory, and I use subsonic for DAL. http://website1.com/admin http://website2.com/admin http://websit...
Ok, this is very weird. I'm using SubSonic 3.0 and Linq to select a list of IDs (and other properties) into a list of user-defined-objects. Like this: public class ListItem { public int C { get; set; } } public class ListItemWithID { public int ID { get; set; } ...
Hi, I'm trying to mock the Add method of subsonic SimpleRepository with Rihino mocks, I'm using the IRepository Interface but I'm new to mocking and dont know how to go from there, can this be done? thanks for your help. ...
I'm playing around with the SimpleRepository provider (with automigrations) in SubSonic 3 and I have an annoying problem: The only way I can control the string length in my database tables is by adding the SubSonicStringLength or SubSonicLongString attributes to the properties of the objects that need to be persisted. I don't really w...
I have a site that saves a date in my model to the database. After launching my site I realised that the server has US regional settings so I had to make sure that all date's on the public site were formatted in the UK format. However now when I go to my 'Create' page and choose a date and click save I get the error The value '22/11/20...
Here is the situation. I am using SubSonic 3 and would like to specify at run time which connection string to use. This a command line application and the connection string name will be specified by the user as a command line argument. What is the best way to accomplish this? ...
Need some help with this one. I'm working on a site for a company that uses SubSonic 2.1, VS 2008, MySQL and C#. Their current SubSonic build doesn't support MySQL paging. In order to correct this, I've attempted to upgrade the project to 2.2. I've tried two different methods. Attempt #1 - Upgraded to 2.2 binary available on the site ...
Hi, Using templates, how can I delete multiple records from a table in same Delete statement? Please advise. Thanks Pankaj ...