-
Thanks for vbandrade , evolved , I think I have not describe the issue clearly . I mean should I can get EntityList this way: TList<GalleryCommonClass> list = DataRepository.GalleryCommonClassProvider.Find(" charIndex(',1,',CommonClassCode)>0" ) --(just Like! not use find method...
-
Thanks for vbandrade , I have tried , It works. Anyelse ,How to use SQL tum functions in the query , such as CharIndex,trim,length and so on for example I wan to get entity list through this way : select * from galleryCommonClass where charIndex(',1,',CommonClassCode)>0 ,does the EntityProvider...
-
hi, When I want to query a EntitiList from my own where clause ! I have tried to the two way ,but they also throw exception , code like this method 1. TList<GalleryCommonClass> list = DataRepository.GalleryCommonClassProvider.Find("CommonClassId in (1,2,3,4)"); method 2. TList<GalleryCommonClass>...
-
Hi all ! First, thanks for this wonderful that is .NetTiers ! It saved my days of work ! I have a question about the generated select methods and their use in strongly type datasources. I understood that Find is more secure than GetPaged (or is it GetAll) because it uses prepared statements and thus...
-
Hi all, I have a newbie question that I can't seem to figure out myself: I have a database table, "Table1", that holds a couple of Guid-identifer fields, EventID and CompanyID. These Guid-identifiers have their own "Get"-methods in the auto-generated DataRepository.Table1Provider...
-
hi all, when try to find on a bit column don't retrieve anything. If execute the whereClause directly in sqlserver all is right. Can you help me? My code is: MyEntityFilters filters = new MyEntityFilters (); filters.AppendEquals( MyEntityColumn .BitColumn, "1" ); TList < MyEntity >...
-
A feature I've seen in a lot of DALs and have used in the past is the ability to pass an entity instance to a search method (e.g., Find(), GetPaged()) in order to pass search parameters. I find this approach particularly elegant, personally, and was surprised not to find it in .netTiers. I would see...
-
Call me a purist, but Dynamic SQL gives me the shivers. There are clearly cases where it's unavoidable, of course, and thus the use of it in _GetPaged. I'm wondering, however, if it wouldn't be possible to limit these situations by boosting the interface for the _Find stored procedure. One approach I...