I'm in the process of starting up a web site project. My plan is to roll out the site in a somewhat rudimentary form first and then add to the site functionality along the way. I'm using Subsonic 3 for my DAL, and I'm expecting the database will go through multiple versions as the sites evolve. This means I'll need some kind of versioni...
Hi there, I'm new in subsonic3, and I'm getting some errors when I try to use LeftJoin var q = from c in categories join p in products on c equals p.Category into ps from p in ps.DefaultIfEmpty() select new { Category = c, ProductName = p == null ? "(No products)" : p.ProductName }; The error is "System.Collec...
I have an application that's due to be rolled out in May. I just took over the project and dumped EntityFramework 1.0 in favor of SubSonic. (We don't have the time to wait for EF 4.0.) There is the possibility of moving the application to Azure, and I was wondering what the implications of that might be. My understanding is that EF 4.0 ...
I'm having trouble saving a record in Subsonic 3 using Active record. I've generated my objects using the DALs and tts and everything seems fine because the following test passes. I think that my connection string is correct or the generation wouldn't have succeeded. [Test] public void TestSavingAnEmail() { ...
Hi There I have been using SimpleRepository for months now, and for the first time i have to upload and store an Image/Document in the database My Class looks as follow: public class Document: ObjectMetaData { public string FileName { get; set; } public Guid UserId { get; set; } public DocumentType DocumentType { get; set;...
Hi! i´m using subsonic 3 trying convert a SQL2008 project to MySQL. when the projects try execute this LINQ query : public IQueryable<Marca> SelecionaMarcas() { try { return (from mc in _db.Marcas where mc.Ativo == true ord...
Is the latest version of Subsonic compatible with Visual Studio 2010 / .Net 4.0? ...
I'm tring to increment a field in a MySQL database using SubSonic 3 ActiveRecord. In SQL, this is what I'm after: UPDATE people SET messages_received=messages_received+1 WHERE people_id=@id_to; I tried the following, but it didn't seem to work (messages_received always seemed to be 1): _db.Update<person>() .Set("messages_receive...
Hi, If using subsonic, i know you hav to close a datareader. but what if you get a dataset back, from a stored procedure? What can you close? So if its like this - SubSonic.StoredProcedure sp = SubSonic.StoredProcedure; DataSet ds = DataSet; ds = sp.GetDataSet; What do i close when done? I don't think dataset can be closed, righ...
Hey, I want to convert the following SQL Query to a SubSonic Query. SELECT [dbo].[tbl_Agency].[ParentCompanyID] FROM [dbo].[tbl_Agency] WHERE REPLACE(PhoneNumber, ' ', '') LIKE REPLACE('%9481 1111%', ' ', '') I thought I would do it like below, but I just can't get it to produce valid SQL. //SubSonic string agencyPhone...
Is there a technique for getting my enum properties to 'serialize' to the database using Simple Repository? ...
I've been trying to use SubSonic 3.0's test repository support for unit testing but encountered a few issues, so I thought I document them, and the fixes I've come up with: Auto-Increment Columns Don't Work Obviously with no DB, auto-increment columns don't work automatically, but if like me you're using simple ints or longs for all id...
Hi everybody, I'm using Subsonic (simplerepository) and SQLite, and I have a class with an Int64 property marked as [SubSonicPrimaryKey]: [SubSonicPrimaryKey] public Int64 MyID; which is transformed into: [MyID] integer NOT NULL PRIMARY KEY AUTOINCREMENT Is it possible to disable the AUTOINCREMENT feature? ...
I've got the following code: UserLoginData userLoginData = _securitySoap.Login(username, password); _repository = new SimpleRepository(SimpleRepositoryOptions.RunMigrations); _repository.Add<UserLoginData>(userLoginData); var queryResult = _repository.Exists<UserLoginData>(x => x.UserName == userLoginData.UserName); The last line thro...
How can I perform an idempotent insert row using subsonic with a SQL 2008 backend? e.g. I have a table "Colors" where name is the primary key. Color c = new Color; c.name = "red"; c.Save; Color c2 = new Color; c2.name = "red"; c2.Save; // throws duplicate key error; I know I can just trap the error but I would prefer to do somethi...
I'm looking at using Subsonic with a multi-tenant ASP.net web application. There are multiple DB's (one per client/instance). The user logs in with a domain suffix to their username (e.g. user@tenant1, user@tenant2). The custom membership provider will then determine which database a user is using, and authenticate against it. All user-...
Is it possible to use ASP.NET Dynamic Data with SubSonic 3 in-place of Linq to SQL classes or the Entity Framework? MetaModel.RegisterContext() throws an exception if you use the context class that SubSonic generates. I thought I remembered coming across a SubSonic/Dynamic Data example back before SubSonic 3 was released but I can't find...
Hi there! I can't understand if we have linq to sql is there any benefits of using subsonic's active record because thay are similar (table=class). and sorry for offtop but does it support Oracle or DB2? Thanks! Victor. ...
Hi guys, I'm currently using SubSonic 2.2 to code against an Oracle XE DB, which carries certain tables that have a primary key which gets automatically filled by means of a sequence and corresponding trigger. In SQL Server this isn't a problem, since SubSonic automatically fills in the autoincrement key value into the correct property...
i try to use subsonic 3.0 but i can not do that. i decided to use subsonic.2.0. So i try to make it i can not :( my Web Config : <?xml version="1.0" encoding="utf-8" ?> <configuration> <configSections> <section name="SubSonicService" type="SubSonic.SubSonicSection, SubSonic" requirePermission="false"/> </configSec...