Incorrect syntax near '<' ...

Normal 0 false false false EN-US X-NONE HE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin-top:0cm; mso-para-margin-right:0cm; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0cm; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:Arial; mso-bidi-theme-font:minor-bidi;}

I am trying to make a simple query using light speed 4 beta.

but my implementation is a little complex ....base repository.....wrapper for the lightspeed context...getting the Entity using generics...

Are there any limitations to this approach?

BTW: using object.Count seems to work.

How can I trace the generated sql ?

 

Thanks

BTW: this what i get in the exception has some garbage inside

   http://prntscr.com/1ldf0

 

Thanks

after breaking my head in the wall I have found the issue.....

That what i have:

I have created IAdminUser interface and created a partial class similar to the lightspeed genereted object.

I am passing the AdminUser(which has 2 classes) object to the GetQueryable<TEntity>() - my implementation of Repository model & UOW which caused the exception....BTW this model works fine with other orm.

What can I do in order to avoid IAdminUser  implementation  in the genereted objects...?

 

Thanks

 

Without seeing your query, or where the IAdminUser interface fits in, it's hard to know what the issue might be.

You can trace the generated SQL by setting LightSpeedContext.Logger = new TraceLogger() (and optionally VerboseLogging = true).

Hi,

This is the structure of classes

public interface IAdminUser : IEntity, IDisposable
    {

public partial class AdminUser : IAdminUser
    {

 public partial class AdminUser : Entity<long>
  {
class AdminUserRepository : RepositoryBase<IAdminUser, AdminUser>, IAdminUserRepository

 public IAdminUser FindbyUserName(string userName)
        {
            var x = Current().GetQueryable<AdminUser>();
            
            return x.Single(m => m.UserName == userName);
        }

Works only without the partial on the AdminUser

That looks okay, assuming GetQueryable does what I think it does... can't see why having a partial of AdminUser would cause a SQL syntax error.  Could you provide a small complete buildable project (console application or NUnit test) that exhibits the issue please, so we can try to reproduce it here?  Thanks!

I have regenerated the files and it works fine

Thanks