-
Hi all, Can someone tell me wath is the main difference beetween WHERE and WhereEwpression when writing Query ? SubSonic.SqlQuery sql = new Select().From(PREV331R.Schema).Where(PREV331R.Columns.Idprev101e).IsEqualTo(clespace.Value); or SubSonic.SqlQuery sql = new Select().From(PREV331R.Schema).WhereBLOCKED...
-
Can anyone tell me how to achieve the following in SubSonic 2.1? SELECT f1,f2 FROM t1 WHERE SOUNDEX(f4) = SOUNDEX('some expression') I've tried: ...Where("soundex(f4)").IsEqualTo("soundex('bla bla')")... but it looks like SubSonic is trying to parse the IsEqualTo...
-
Why dont use Get instead of Post for searching in mvc site by default, it's remember me postback in classic asp.net :( i preffer Get , because after i'll can send my query to somebody else, dont u think so? Thanks
-
i have a query .. Select * From Table Where TypeID = 5 AND ( Title Like '%somedate%' OR Content Like '%somedate%' ); Pls Help, how to create this using SubSonic.Query object.
-
Can any one help me how to write query for this select SELECT q_ar.id, q_ar.s_ar, q_ar.sura_ar, q_ar.a_ar, q_ar.ayat_ar, q_en.tr_y, q_en.tr_p, q_en.tr_s FROM q_ar INNER JOIN q_en ON q_ar.s_ar = q_en.s_en AND q_ar.a_ar = q_en.a_en ORDER BY q_ar.id Thanks, K
-
hi guys, im a newbie on subsonic could someone interpret this sql query into subsonic code? SQL query: select Count( Trans.TransId ) from Trans inner join LPSRFileAllocation on LPSRFileAllocation.C4FilePath = trans.FileName or LPSRFileAllocation.LGAFilePath = Trans.FileName where LPSRFileAllocation.C4FilePath...
-
Hi, I want to filter records that records starts with the letter a, b ....... or z depend on the user choice should show. but the problem is that i dont know that ho can i use "Like" operator in subsonic as we used in sqlserver. can anyone help me that how can i use it in subsonic. thx
-
Hi I am porting an app written with the ActiveRecord pattern to Repository pattern (Pakala 2.1). The old app used, for example, Order.GetUpdateCommand()... to generate a QueryCommand that can be used in Transactions. however, with the Repository, I cannot seem to find a way to do this. Once I made changes...
-
How do you write this statement with Subsonic: Update authors Set city = replace(city, 'Salt', 'Olympic')
-
I am new to SubSonic. I have a statement that looks at a field called Search. I would like my users to get results for individual words they input in it. For example they enter "white cars". I want them to get records that contain "white" and records that contain "cars"...