LLBLGen Pro Support System Generated code FAQ feed

Can I use the generated code in a Medium Trust environment? by Otis

Otis — Tue, 05 Apr 2011 09:28:45 GMT

Starting with the LLBLGen Pro runtime framework build of April 4th, 2011, the generated code of v3.0 and v3.1 can be used in a Medium Trust environment. Medium Trust is sometimes required on shared hosting platforms and cloud service providers like GoDaddy or Rackspace.

.NET 4 For using the generated code in a Medium Trust environment with .NET 4, the following additional action has to be taken to avoid a security exception related to inheritance:

Adapter Add the following line to the AssemblyInfo.cs/vb class in the generated DbGeneric VS.NET project:


// C#:
[assembly: System.Security.SecurityRules(System.Security.SecurityRuleSet.Level1)]

' VB.NET:
<Assembly: System.Security.SecurityRules(System.Security.SecurityRuleSet.Level1)>

SelfServicing Add the following line to the AssemblyInfo.cs/vb class in the generated VS.NET project:


// C#:
[assembly: System.Security.SecurityRules(System.Security.SecurityRuleSet.Level1)]

' VB.NET:
<Assembly: System.Security.SecurityRules(System.Security.SecurityRuleSet.Level1)>

Linq To use Linq, the service provider has to have enabled ReflectionPermission to be unrestricted. This is in general the case, as Entity Framework and Linq to Sql require this setting to be unrestricted. It's a change in the Medium Trust level, so it's not enabled by default when the default Medium Trust is selected. If your service provider doesn't want to enable ReflectionPermission to be unrestricted, you have to use our native query API instead of Linq. Linq uses compiled lambda's and this .NET 3.5 feature requires ReflectionPermission to be unrestricted.

My entity classes don't have a Save() method by MTrinder

MTrinder — Tue, 14 Oct 2008 19:52:50 GMT

Alternate Solution

You are using the SelfServicing templates but the project you are calling the generated code from does not have a reference to the ORMSupportClasses DLL and has not yet been built.

The .Save methods are inherited from base classes in the support dll, and so this needs to be referenced, and the project built, for these to be visible.

How to generate DTOs with LLBLGen Pro? by Otis

Otis — Mon, 19 Nov 2007 09:59:55 GMT

For C#, start here: http://www.llblgen.com/tinyforum/GotoMessage.aspx?MessageID=41429&ThreadID=6261

the same template ported to VB.NET: http://www.llblgen.com/tinyforum/GotoMessage.aspx?MessageID=65950&ThreadID=11870

Is there a Find method in the Entity collections? by Aglaia

Aglaia — Tue, 21 Aug 2007 11:20:58 GMT

Question: I want to look up an entity in a collection with read entities. Is there a Find method in the Entity collections?

Solution: You can find entities easily with in-memory filtering on an entitycollection. Take for example the following code, which finds the CustomerEntity with the PK "CHOPS" in the customer collection. This works for both Adapter and SelfServicing. It will use the DefaultView object for this.


// C#
CustomerCollection customers = new CustomerCollection();
// get all customers
customers.GetMulti(null);
IEntityView view = customers.DefaultView;
// filter view
view.Filter = (CustomerFields.CustomerId == "CHOPS");
// get a reference to the entity to find:
CustomerEntity toFind = view[0];

 VB.NET
Dim customers As New CustomerCollection()
' get all customers
customers.GetMulti(Nothing)
Dim view As IEntityView = customers.DefaultView
' filter view
view.Filter = New FieldCompareValuePredicate(CustomerFields.CustomerId, _
ComparisonOperator.Equals, "CHOPS")
' get a reference to the entity to find:
CustomerEntity toFind = view(0)

Added entity in visual studio.net project isn't there by Aglaia

Aglaia — Tue, 21 Aug 2007 11:20:05 GMT

Question: I've added a new table (also applies to renaming a table and re-adding the entity) and have added the entity to my project after the project refresh. When I generate the code in the directory where my generated code was located and I open the visual studio.net project, the entity is not there! How to solve this?

Solution: Generating code will also create a visual studio.net project file. Since a user can have added own classes to this project file, it will not be overwritten, but updated, if the file is writable. If your visual studio.net project file isn't updated, it's probably read-only, perhaps due to the usage of Visual Sourcesafe. You can check the result of every generation task in the application output window in LLBLGen Pro.

Using NUnit for testing purposes by Aglaia

Aglaia — Tue, 21 Aug 2007 11:19:34 GMT

Question: I want to unit test the generated code together with my code using NUnit. However it doesn't work, NUnit can't connect to the database, how come?

Solution: If you want to use NUnit for testing purposes, you have to create an app.dll.config file (where app is the name of the project created for NUnit testing) and place it in the bin\debug directory for the NUnit project. For example if you create a new project called "UnitTest" for NUnit testing, and after adding the appropriate references (see LLBLGen Pro and NUnit documentation) you must copy the App.config file that LLBLGen Pro creates to the directory where the NUnit test dll resides (bin\debug) and rename it to "UnitTest.dll.config".

Is the generated code vulnerable to SQL injection attacks? by Aglaia

Aglaia — Tue, 21 Aug 2007 11:18:56 GMT

Question: LLBLGen Pro generates SQL on the fly and doesn't use stored procedures to do its database operations. Aren't these queries vulnerable for SQL injection attacks? ** Solution:** All SQL generated by LLBLGen Pro is parameterized. This means that no values are embedded into the SQL query being generated. Due to the parameters, a value can never influence the query being executed, as the value will never be part of the query itself, but just a value of a parameter. The generated code is therefore not vulnerable for SQL injection attacks.

My entity classes don't have a Save() method by Aglaia

Aglaia — Tue, 21 Aug 2007 11:18:24 GMT

Question: When I generate code, I noticed that my entity classes don't have a Save() method and my typed list classes don't have a Fill() method. What's wrong?

Solution: You've chosen one of the Adapter generator configurations in the generator configuration screen but you expected SelfServicing code. To get SelfServicing code, select SelfServicing from the Template Group drop-down-list in the General Settings tab of the code generation window.