Search Results

Search found 2 results on 1 pages for 'sqlbuilder'.

Page 1/1 | 1 

• Generic SQL builder .NET

  - by Patrick

  I'm looking for a way to write an SQL statement in C# targeting different providers. A typical example of SQL statements differentiating is the LIMIT in PostgreSQL vs. TOP in MSSQL. Is the only way to solve SQL-syntax like the two above to write if-statements depending on which provider the user selects or using try catch statements as flow control (LIMIT didn't work, I'll try TOP instead)? I've seen the LINQ Take method, but I'm wondering if one can do this without LINQ? In other words, does C# have some generic SQL Provider class that I have failed to find that can be used?

  Read the article

• Method to Create an Entity Framework Object Context

  - by Kubi

  public RBSEntities GetContext() { SqlConnectionStringBuilder sqlBuilder = new SqlConnectionStringBuilder(); sqlBuilder.DataSource = "a-pc"; sqlBuilder.InitialCatalog = "ABS"; sqlBuilder.IntegratedSecurity = true; string providerString = sqlBuilder.ToString(); EntityConnectionStringBuilder entityBuilder = new EntityConnectionStringBuilder(); entityBuilder.Provider = "System.Data.SqlClient"; entityBuilder.ProviderConnectionString = providerString; entityBuilder.Metadata = @"res://*/RBSModel.csdl| res://*/RBSModel.ssdl| res://*/RBSModel.msl"; RBSEntities entities = new RBSEntities(entityBuilder.ToString()); return entities; } Something wrong with the Metadata. Anybody having an idea about how to fix this ?

  Read the article

1