LINQ

Follow these instructions: EF4 - EntityException: The connection's current state is connecting.[^]

Do you really think OP is still waiting for a reply after 9 months?

Use SQL To Linq of LinqPad to convert your sql queries to Linq. Below are the link: Linqer | SQL to LINQ converter[^] LINQPad - The .NET Programmer's Playground[^] Life is a computer program and everyone is the programmer of his own life.

It's possible to achieve that using Linq To Dataset[^]. Assuming that you did Load[^] data into DataTable object via using SqlReader[^]: var result = dt.AsEnumerable() .GroupBy(a=>a.Field("ID")) .Select(g=>new { Id = g.Key, Count = g.Count() }) .ToList(); Returns a list of Id's with the number of occurences. For further information, please see: Programming Guide (LINQ to DataSet)[^] Queries in LINQ to DataSet[^] Querying DataSets (LINQ to DataSet)[^] LINQ to DataSet Examples[^]

Hi, through this link which contains code as well as data to explain. hope this will help. Simple LINQ to SQL in C#[^] hi

The error message is quite clear - "An item with the same key has already been added". In your dictionary initializer, you have added the key "Inventurart" twice - the 6th and 29th items. Remove one of those items. "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

You can use the SqlQuery method[^] on the Database[^] to execute a raw query: IEnumerable<string> tables = context.Database.SqlQuery<string>("SELECT QUOTENAME(s.name) + '.' + QUOTENAME(t.name) As TableName FROM sys.tables As t INNER JOIN sys.schemas As s ON s.schema_id = t.schema_id ORDER BY s.name, t.name"); Entity Framework Raw SQL Queries[^] "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

Richard Deeming wrote: Any reason you can't use an interface? Only that the classes are generated by a code generator and putting the method in the base class work eliminates the risk of regenerating and losing the interface reference. Support will be simpler, possibly! Never underestimate the power of human stupidity RAH

"Old school" is good, though! Cuz, "it just works..."

from qTeam in teams select NickName = qTeam.NickName, Population = qTeam.City.Population

thanks really appreciate your help cheers

var list = objTable.AsEnumerable(); var query = from l in list where l.Field<string>("root") == "1" select l; var result = query.Concat(from q in query from l in list where l.Field<string>("root") == q.Field<string>("id") select l); foreach (var r in result) { Console.WriteLine("value has id:{0}, root:{1}", r.Field<string>("id"), r.Field<string>("root")); }

from A in dataClass.vwPLANODINs join B in dataClass.LANCADAs on new { A.Codplano, Data = data } equals new { Codplano = B.Subord, Data = Convert.ToString(B.Data) } into B_join from B in B_join.DefaultIfEmpty(new LANCADAs{Data == null}) select new { A.Codplano, A.Secao, A.Setor, A.Subsetor, A.Contato, Situacao = (B.Subord ?? "N/A") }; something like this will work.

You can use IComparer or IComparable interface to compare the list of objects.

/jmot wrote: i really don't know for what this place is?? Then maybe you should read http://www.codeproject.com/Messages/3122366/How-to-get-an-answer-to-your-question.aspx[^].

http://techgurulab.com/course/sql-tutorial/[^] This link is help to basic concept on SQL