SubSonic is great and helps me code a lot faster, but now I've run into something that I think would help a ton of programmers. I'm programming against a huge database, but only need about 6 or 7 tables out of the 50 or so tables. The exclude in the Settings.ttinclude requires me to enter the other tables not needed. I would love to h...
Where is InlineQuery on SubSonic 3.0 or is there a new equivalient? thanks ...
Hello guys here is what i am doing, and not working for me. I have a DAL generated with SubSonic 3 ActiveRecord template, i have a service layer (business layer if you well) that have mixture of facade and some validation. say i have a method on the Service layer like public void UpdateClient(Client client); in my GUI i create a Clien...
I cannot get the latest SubSonic with SQLite ActiveRecord to work. I grabbed the latest 3.0x bits from the web site on July 15th. I made a brand new WPF project with the namespace 'MineSpace'. I created a SQLite v3 database with 5 tables and FKey relationships (no triggers). I added ActiveRecord.tt, Settings.ttinclude, SQLite.ttinclud...
D:\Web\CityV2\App_Code\ActiveRecord.tt(0,0) : error CS0006: Compiling transformation: Metadata file 'MySql.Data' could not be found Let me start by saying I'm using VWD 2008 Express. These are the steps I've taken so far: Created an entirely new project Added references for Subsonic.Core.dll and MySql.Data.dll Copied Active Record te...
I'm curious if there are any SubSonic ports for use with php on a unix environment. I'm using SubSonic at work and I love it, and I'd like to create a MySQL database on a FreeBSD server and talk to it using php. I was hoping to use SubSonic again, but I'm not sure if there are any versions of it that work with php. Are there any versi...
Ok, I was eagerly awaiting the release of subsonic 3.0 to use as my low-level data layer, and now its out. I'm currently using the ActiveRecord templates (having tried both the repository and advanced templates) and I have one HUGE request and a few questions: Request: Other than bug fixes, Rob please spend the time to provide docume...
Ok, please bear with me as I can be a bit of a wood duck at times... I have a gridview in asp.net that will be pulling back many thousand of records. This is all well and good apart from the performance aspect of things. I am binding my Gridview to a dataset and this pulls back every record in the query. I want to change this so that th...
This fails with an error with the method "Contains" is not supported. List<int> usedID= new List<int> { 1, 2, 3 }; var f = WebPageContent.Find(x => !usedID.Contains(x.PageID)); Seems odd so what's the alternative approach? This doesn't work either: var dd = from i in WebPageContent.All() where !usedID.Contains(i.PageID) ...
Considering the following code: List<Processo> listaProcesso = new List<Processo>(); Processo processo; processo = new Processo(); processo.AgendamentoID = 9; processo.DataEntrada = DateTime.Now; processo.EtapaExecucao = 0; processo.RegistrosAfetados = 2; listaProcesso.Ad...
Using VB.net, the following snippet gives the error below. Dim _account = Account.Find(Function(x As Account) x.AccountName = txtFilterAccountName.Text) or similarly if I do .SingleOrDefault (Function(x As Account) x.AccountName = txtFilterAccountName.Text) will both give the error "The method 'CompareString' is not supported". I...
Hi! I'm starting to do some test on SubSonic 3 and I'm missing some stuff. 1st: Where's the Table names constants? The place where we could ask for the same of a certain table using intelisense... 2nd: Same as the above but for the table columns... where are they? This is very useful mostly when you need to pass those names as string.....
How can you create a one to one relationship in Subsonic? For example, I have my table called Readings and each Reading has only one book, however Subsonic returns an IQueryable of books. I want it to return only one book. Thanks. ...
Hi. I try to work with my postgre DB via SubSonic. I have simple config: <configuration> <connectionStrings> <add name="test" connectionString="Server=localhost;Port=5432;User Id=iliy;Password=111;Database=test;" providerName="Npgsql"/> </connectionStrings> </configuration> But it does not work. I got "Unable to fi...
Hi, I am writing a VS2008 add-in that connects to a remote database blah blah. I am having a problem with the app.config in this project. When I use SubSonic in my code, it moans that is cannot find the SubSonicServer section. This is because the .config file cannot be found. This appears to a problem with paths as the add-in is a DLL ...
I am trying to do a simple JSON return but I am having issues I have the following below. public JsonResult GetEventData() { var data = Event.Find(x => x.ID != 0); return Json(data); } I get a HTTP 500 with the exception as shown in the title of this question. I also tried var data = Event.All(...
Anyone worked with Subsonic3 and Entity Framework here who can tell me the pros and cons? This is my first time attempting to try these. Subsonic is easy to setup so as the Entity Framework. I am not sure if Entity Framework works with other databases as SubSonic does like MySql PGsql etc...? I read this post (http://www.timacheson.com/...
I am working on an opensource app that using SubSonic 2.0.3 I need to regenerate some of the code so I need the tool that does that. I cannot find this version 2.0.3 of the code generator executable. Any help would be greatly appreciated! ...
Hi, What linq features are currently not supported in SS3? Can't seem to find a list. Ta, Bob ...
Error 3 Running transformation: System.ArgumentException: Format of the initialization string does not conform to specification starting at index 0. at System.Data.Common.DbConnectionOptions.GetKeyValuePair(String connectionString, Int32 currentPosition, StringBuilder buffer, Boolean useOdbcRules, String& keyname, String& keyvalue) ...