Hi, I am developing a CMS that using database based on Joomla ! In Joomla db, we have 2 table : +----------+ |Categories| +----------+ id title ... +-------+ |Content| +-------+ id title catid ... I have a query below : SqlQuery q = new Select("*") //.Top("1") .From(JosContent.Schem...
I was making tests with SubSonic with SQL Server and everything was fine. I decided to install MySQL and made the same tests, but now I have a little problem My table name is ClienteEndereco in SQL Server but when i make change in my web.config to work with MYSQL and recompile the program the table name comes Clienteendereco SQL Serve...
Can subsonic help me building these main stored procedures? Can i edit its template to make it generate these SPs? Where to begin learning that? ...
Hi, could you please describe in just few words state of the Subsonic 3 project? Will you share the sources, when we can expect the release. How are things with development, what problems have you meet and so on... Thanks a lot! ...
Question #1: Latest working Version I'm currently using SubSonic 2.1 built 491. Is there a later built? Where can I get it? I know 2.2 was released but it doesn't come with a Setup and I wouldn't know how to modify the App.Config/Web.Config to work with it. Question #2: Issue with dateTimePicker control on Windows Form. I keep getting ...
I renamed a database table and added a ~ character to the table name (my way of notifying it is a backup of something). After generating the SubSonic files, my Visual Studio gives a "Character not valid" error on file "AllStructs.vb" When looking into this file the following line of code was generated; Public Shared ReadOnly DbTable1~ol...
In my web application I've to keep audit of the user actions. So whenever user takes an action I update the object on which action is taken and keep audit trail of that action. Now If I first modify the object and then update audit trail but the audit trail fails then what? Obviously I need to roll-back changes to modified object. I c...
The next code runs normally in SQLSERVER but when i change the web.config to runs with mySQL after the loadbykey the connection is closed. is there any configuration to make in MYSQL to change that ??? thanks any help !!! //----------------------------------------------------------- string tipoBanco = System.Configuration.Con...
I'm playing with the SubSonic RESTHandler for the first time and it's awesome... There is one quirk tho, that I'm curious about. RESTHandler.cs (line 319): //if this column is a string, by default do a fuzzy search if(comp == Comparison.Like || column.IsString) { comp = Comparison.Like; paramValue = String.Concat("%", paramVal...
I understand that Subsonic 2.2 requires the MySQL.data 5.2.3 dll. I'm trying to integrate a subsonic DAL for a VB project in Visual Studio. The project already uses a lot of datasets. Because of this, Visual Studio requires that I have the MySQL NET connector software installed, which automatically throws its own MySQL dll deep into ...
I have just installed subSonic 2.2 on an XP Sp3 VM .NET Framework 3.5 and when I try to launch the SubStage exe it crashes immediately. Any ideas? Thought I'd add I am running the VM inside VMWare on Mac OSX. ...
I have a table in my SQL2005 DB named MultiMedia - after DAL generation with SubSonic v2.2, the classes that are generated are named "MultiMedium". The table was originally named Media and this resulted in classes named Medium as well - easy enough to change the name of my table at this point in the project, but wondering if anyone else...
I have a few large forms that I need to provide visual cues about the before/after state, so the person approving the form can see what has been modified (not the previous answer, tho that would be a plus). This is currently being done with an extra column for each column of data (Name, Name_IsModified, Phone, Phone_IsModified, etc...)....
There are a couple of resources on the Internet describing preview 2 of subsonic with Astoria : http://theruntime.com/blogs/jaykimble/archive/2008/11/18/quotsubsonicquot-for-services-found-subsonic-3--ado.net-data-services.aspx and working sample at http://code.msdn.microsoft.com/SubSonicForADONETDS I applied all respective changes ...
In the database I have about 150 tables - most of them from previous versions of the application I currently work on. For my app I only need about 20 tables - is there a way to ignore some of the tables by setting some parameter in web.config? ...
When I generate the DAL via SubCommander/sonic.exe I get an empty StoredProcedures.cs All that's in it is:using System; using System.Text; using System.Data; using System.Data.SqlClient; using System.Data.Common; using System.Collections; using System.Collections.Generic; using System.ComponentModel; using System.Configuration; using ...
Hi, I have 3 tables and need to select some recoreds, In 2 table of them I have fileds with same name , and when I try to use Where Expression on these filed I got error message : If I use TABLENAMe.Columns.COLNAME this error message shows : Ambiguous column name 'FKLoginID'. and if I use TableNAme.COLColumn.QualifiedName , it has error...
Using SubSonic 2.2, after DAL generation with sonic.exe, the AllStruct.cs content looks wrong: // <auto-generated /> namespace ...DAL { #region Tables Struct public partial struct Tables { ... } #endregion #region Schemas public partial class Schemas { ... } #endregion #region View Struct public partia...
This query will only return all records where Active=true and Exempt=false. It should be returning any records also where Active=true and Exempt IS NULL. I guess the .IsNotEqualTo doesn't compare to any records with a null value? Is there a way around this without setting a default? UserCollection ActiveUsersNotExempt = new UserColle...
EDIT: There's now a doc page on this so this question is irrelevant, also it's outdated. Read the docs not this question. I've been toying with the SubSonic 3 code generation for a month or so now and I'm interested in getting some feedback from others on which template they use and why. EDIT: Rob's been blogging about the different t...