Stack Overflow
Stack Overflow

Questions tagged [llblgenpro]

LLBLGen is an Object Relational Mapper (O/RM) for .NET. With it you can generate your data access layer for multiple O/RM frameworks (LLBLGen Pro Runtime Framework, Entity Framework, Linq to Sql, and NHibernate 2.x / 3.0 (hbm.xml and FluentNHibernate)).

165 questions
1
vote
1 answer

LINQ - Left Outer Join with multiple parameters in Where clause

How can I do this SQL query in LINQ: select * from chat c left outer join lead s on c.key = s.id where (typeId = 5 AND c.key = @clientId) OR (c.typeId = 4 AND s.clientId = @clientId) Or this SQL query -- Same, same select * from chat c where…
MartinHN
  • 19,542
  • 19
  • 89
  • 131
1
vote
0 answers

examples of llblgen catalog name switching?

Everyone touts the wonders of llblgen, but I've found very little in the way of examples of its usage in c#. The documentation for llblgen explains how much you can do, but provides virtually no examples, preferring instead to provide complicated…
neil1967
  • 257
  • 3
  • 16
1
vote
1 answer

Cannot switch a connection string in LLBL Gen Pro

I have two databases with the same schema inside a Sql 2008 R2 Server, of which names are Database1 and Database2. I connected and performed queries on the Database1, and then changed to Database2 to fetch my entities using the following…
Toan Nguyen
  • 11,263
  • 5
  • 43
  • 59
1
vote
0 answers

LLBLGen Template Binding test for date type

In the LLBLGen Template Bindings Viewer, I want to check if a field is a date type, and if so, do an action I have similar, that checks for a string type: <[Foreach EntityField]> <[If IsStringField]><[EntityFieldName]> = "";…
Craig
  • 381
  • 5
  • 22
1
vote
2 answers

LLBLGen viewing generated SQL statement

I'm using LLBLGen to access a SQL Express database using LLBLGen runtime framework. Using Visual Studio 2010. I have created a predicate expression, however It does not seem to be doing what I thought it should, how can I view the Generated SQL…
Craig
  • 381
  • 5
  • 22
1
vote
0 answers

How to load distinct items into llblgen pro collection

I have a collection like the code below. I load all items from table. How to load just distinct items on specific field? var objlogcollection = new ClsfIcdNineToClsfIcdTenDiagnosisCollection(); IPredicateExpression filter = new…
Mindaugas
  • 163
  • 1
  • 7
  • 16
0
votes
1 answer

Could I use LLBL Gen to JOIN columns between tables which don't have a relationship of primary-foreign keys?

I have the following DB structure Table1( ID1,Col1,Col2) and Table1( ID2,Col3,Col4) Table1 and Table2 are separate table and don't have any relationships between them. and I would like to achieve the following result SELECT * FROM Table1 JOIN…
Toan Nguyen
  • 11,263
  • 5
  • 43
  • 59
0
votes
1 answer

Domain Driven Design with ORM

i am designing the object model an application and there is certaint level of impedance mismtach between objects and tables. For example I have…
Gonzales Gokhan
  • 512
  • 4
  • 13
0
votes
1 answer

how to Return first row using llblgen

Hi im really new to llblgen and was wondering how to do this simple task.. sigh currently I'm grabbing this row by row field.id = 1, but rows can be moved and deleted and i will always want the first row so how do i grab the first row always in…
Ryan86
  • 77
  • 1
  • 7
0
votes
1 answer

LLBLGenPro - How to update database field value directly based on predicate

I have a table that has a column called Ordinal used to keep track of display order. When an entity changes its ordinal value, the other records in the database need to have their ordinal value adjusted, either up or down depending on the situation.…
JeremyWeir
  • 24,118
  • 10
  • 92
  • 107
0
votes
1 answer

What would this sql query (w count and group by) look like when translated to linq?

How would the following sql query look when translated to linq? SELECT myId, Count(myId) FROM MyTable GROUP BY myId I've tried the following: var q = from a in db.MyTable group a by a.Id into g let count = g.Count() select new { Count =…
Dane O'Connor
  • 75,180
  • 37
  • 119
  • 173
0
votes
2 answers

Error deploying SharePoint 2010 solution - Cannot create more than '500' IEntity objects per ILobSystem object

I am generating a sharepoint 2010 bdc model xml file along with the entities and associated service classes from a model 1st LLBLGen framework/ C# .net 3.5 project. All was going well when suddenly I started receiving this error while deploying the…
Sam West
  • 3
  • 3
0
votes
1 answer

llblgen Pro SELECT TOP (n) equivalent query

Is it possible to perform a select top (n) query in llblgen pro?...not LINQ. If so, how can I achieve that using the SelfServicing?
Saif Khan
  • 18,402
  • 29
  • 102
  • 147
0
votes
1 answer

Can multiple filters be used on a llblgen data source?

I have the following (sample)code to filter search results from a LLBLGen data source: IPredicateExpression firstFilter = new PredicateExpression(); firstFilter.Add(new FieldLikePredicate(CustomerFields.FirstName, null, txtSearchFirst.Text.Trim() +…
JamesEggers
  • 12,885
  • 14
  • 59
  • 86
0
votes
1 answer

Transaction in LLBLGen Pro

I am using LLBLGen Pro 2.5 with self-servicing. If I want to add some rows into my tables within a transaction and then update the first row I added, do I have to add that first entity into the transaction object again? Here is a fictional example…
Dan Appleyard
  • 7,405
  • 14
  • 49
  • 80
1 2 3
…
10 11