I want to use subsonic in combination with an oracle database. I just can't find the template needed to generate the code. In the TemplateProviders a provider for oracle is missing. Does anyone have an implementation for this. Thanks in advance. ...
Can SimpleRepository output a xml? just like DataSet WriteXml. ...
Hello. I'm currently using Subsonic 3.03 Active Record repository. I have setup a Test connection string to utilise the dummy internal storage. [TestInitialize] public void TestInitialize() { List<ServiceJob> jobs = new List<ServiceJob>() { new ServiceJob() { ServiceJobID = 1 }, new S...
Hi I have a Subsonic3 Active Record generated partial User class which I've extended on with some methods in a separate partial class. I would like to know if it is possible to add Data Annotations to the member properties on one partial class where it's declared on the other Subsonic Generated one I tried this. public partial class U...
Hi all, I have this simple little method that is trying to use the SimpleRepositry Find method in SubSonic 3.0.0.3. When I make the call I get a invalid operation exception "Lambda Parameter not in scope", which added a touch of sadness to my coding afternoon. public override IEnumerable<ICustomer> FindCustomers(string searchTerm) { ...
I downloaded and installed the SubSonic MVC templates. I'm able to create a new project from this template and the 'prewritten' views work fine. I'm able to edit records from the Artist table of the included 'Chinook' database. So now I'd like to get this to work with MY database. Here's what I've done. Changed to connectionstring in...
I'm writing some unit tests for an ASP.NET MVC controller that's using SubSonic3 generated model objects (using ActiveRecord "mode" (not sure what else to call it), and am wondering how I can clear out the test data from the test database in my TestFixture's TearDown method. I don't have a direct reference to the model object in my test ...
I am using SubSonic Active Record in a C# web application. I followed all the setup instructions and went well. i queried the database for some simple results and presto I got data. I then changed the namespace in the settings file right clicked on the ActiveRecord file and everything broke. Since then any classes and namespace generated...
Does some resource of Audit exist in SubSonic? ...
I want to check 1 day old created record(s), and below is my code. my problem is, it does returning any record even if I do have a match. And even I run it on LinqPad, It just outputing blank result. from x in Users where (DateTime.Today - x.CreatedDate).ToString().Equals("1.00:00:00") select x but when i try to remove the "where" f...
How do you fashion projections in SubSonic 2.2? Basically I wish to return columns from two tables that are joined. ...
Using the code below, the expected behavior is that the database won't reflect the update since ts.Complete() is never called but the updates seems to go through. But if I leave out the SharedDbConnectionScope then the expected behavior is seen. Is there a problem with SharedDbConnectionScope? Btw I am using Subsonic 2.2 using (SharedDb...
I have this class/object below: public class Person { public string FirstName; public string MI; public string LastName; } Person p=new Person(); p.FirstName = "Jeff"; p.MI = "A"; p.LastName = "Price"; Is there any built in in linq or c# or in subsonic that will create an output of this?: string myString =...
Does anyone know of a way to do a left outer join with SubSonic 3.0 or another way to approach this problem? What I am trying to accomplish is that I have one table for departments and another table for divisions. A department can have multiple divisions. I need to display a list of departments with the divisions it contains. Getting...
(Warning: This may be a stupid question...) I am am one of those who are not willing to move to SubSonic 3.0. I am currently using a customized fork of SubSonic 1.(?). I want to migrate to version 2 for many reasons, and I have been successfully been playing with Subcommander. Cool stuff! Here's my question... When I generate the D...
Hi guys how do you implementing an Audit Trails on all objects/class on SubSonic under Data Access Layer? If what I want is, all changes on all objects will be recorded on a single table/object. public class AuditTrail { public int Id { get; set; } public string SourceObjectName { get; set; } public int RowPK { get; set; } // ...
Hi I have been trying to use Subsonic 3 in a test application in order to understand how it works. However, when it builds the vb files from the database the files are full of '' has multiple definitions with identical signatures errors. I am using Visual Studio 2008 configured for VB. Has anyone else seen this problem and have sugges...
is this a bug? my property of type bool from a bit field on SQL DB, always return (false), even though the value on the Database is (true). although altering the property to true or false seems to be working, if you look at the database/table, the only problem is the fetching... return always "false" I am using - subsonic-SubSonic-3.0...
Hi All, I'm trying to get eager loading working with Subsonic, and it's been returning null for me. In the method below, I'm trying to hydrate a domain model (UserModel) which contains another domain model (CompanyModel). However, with the code below, UserModel.Company is always null. What am I missing here. Any help would be appre...
This is not a question but a bug in subsonic 2.1/2.2 The method public QueryCommand BuildUpdateCommand(Query qry) in Dataprovider.cs generates and invalid Update statement if the Table to be updated is a member of a Schema, i.e. a Schema other than "dbo". The offending line is sql.Append(qry.Provider.DelimitDbName(table.Name)); T...