I don’t like to use code first because i already has a big Database. I have some questions:
1.Does Ormlite support View and Store Procedure?
2.Could i generate POCO by Database?
3.Could i use linq to select data from Ormlite like EntityFramework?
Yeah it lets you call Views as Tables and can call Stored Procedures using its Custom SQL API’s.
You can use the T4 Templates to initially generate the POCO classes from you databases.
OrmLite has a typed LINQ-like API that lets you use lambda expressions to generate server-side SQL.
Please read the documentation on the OrmLite Home Page it has docs and examples of everything you want to know.